I think source control and versioning, of some sort, is the only way to do this kind of thing.

Calculated from what? A text file? An Excel file? Data entry through an application or web page?

I don't know of a legal way to get a free copy of Excel 2007, so can't help you there.

You need to put the complex Select on top of the CTE, before From:

SELECT DISTINCT

fpartno,

...

That's what I'm saying. I think it might. Just an idea, not a proven concept. Might be worth checking, if you can.

I don't know if it will do that. It might not.

Is it possible you installed 2008 R2?

Pull up the prior version from source control and recover it from there, is, I'm assuming, out of the question. That's the only reliable means I can think of.

"Better" is subjective, but I use SQL Server deployment into msdb.

The only thing I can think of is that the later version of Excel has more bloat to it and is slower. That would be normal, but I can't...

If you're inserting from a tabular source, you could cross join it to a single row of the static data.

Are the two computers significantly different in terms of hardware? How about services loaded and running? Free resources?

Move the CTE into a derived table in the From clause. See if that does what you need.

You select the articles (tables) you want to replicate, and the data relevant to them gets sent over.

What's the SQL version? Select @@version.