OK, I have a table of names. Lets say we want to do secret santa assignments for whatever reason. --// Create our SOURCE table DECLARE @t1 TABLE ( id ...