OK, I have a table of names. Lets say we want to do secret santa assignments for whatever reason. Code: --// Create our SOURCE table DECLARE @t1 TABLE ( id int, name nvarchar(16), scrambledOrderName ...
Most professional business programmers have found themselves on the receiving end of more than a few crazy requirement or design documents at least once in their careers. These stoic programmers grind ...
We are dummying up some sample data for testing. I want to take any number that is NOT 100 and then multiple it by (for example) 0.8. I was thinking I could look at sys.objects and sys.columns to get ...