Would this not work and be a little less wacky?

Create table #Contact

(contactID int,

firstName Nvarchar(50),

MiddleName Nvarchar(50),

Lastname Nvarchar(50),

Suffix Nvarchar(50),

EmailAddress Nvarchar(50))

INSERT INTO #Contact

Select ContactID, Firstname, MiddleName,

LastName, Suffix,...

I've been playing around with it this morning and have already found it helpful. We run massive matching (fuzzy) and deduping jobs that can run for days so tuning...