Ars Technica

TSQL - want to update Column2 with values from Column1 but in scrambled order...?

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 ...