Well, 2) is definitely out of the question. They're asked me to stay beyond my 6 month committment, and I said "No, thank you" -- mainly because their stored...

To SSCommitted,

This and other code was developed by their in-house Developers and has been around for years. Dynamic SQL are a fairly common method for them to employ. ...

Thank you for responding, Sean.

I should have been more precise in my original posting for everybody. I, myself, rarely use dynamic SQL, and never use cursors. I was...

Sorry, didn't think to mention that the temporary table on server1 contains over 50 fields, and can have around 2,000 rows. Yes, the 2 servers are already linked.

Does your soultion...