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