What is the purpose of this part of the script ?

-- Enable the OLE automation on the server

EXEC sp_configure 'Ole Automation Procedures', 1;

Yes, I understand that separating the transactions with a GO will make it work, however this is but one part of a larger transaction that I was trying to complete...

Don't you need to create a linked server first ?

OUTSTANDING !!

ALL of this is VERY helpful,

Thank you all

FOLLOW-Up Question..

Are there any other objects that could be used in this situation?

Simply looking for alternatives and better performance.

I have gotten myself into a bad habit of only using UNION to avoid duplicates and had quickly brushed that thought away. As...

OK, I should not have suggested the possibility of using PIVOT for this, I just did not know what to put in the subject line, and maybe this was Not...

Try this

SELECT CarID, MAX(ColorID) FROM @ColorList GROUP BY CarID