I have a bunch of phone number fields which for reasons beyond my control STORED THE FORMATTING DATA IN THE DATABASE (DAMN YOU WINDOWS 98 BRING BILL GATES IN HERE ...
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 ...