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, EmailAddress

FROM Person.Contact