Perhaps somewhat tangential - but there are a couple of things that you may want to think about -

1. You may want to think about reusing variables instead of creating...

Just tried the following for academic reasons -

With the sample dataset, the execution plan seemed far simpler - you may want to give this a try too.

update t set

...

1. Can you post a sample of your code here?

2. How long does it take before it times out?

3. Is it fair to assume that you are working with "default"...

First of all, I completely concur with the above posts - you may want to provide more clarity.

Having said that, this is my attempt to help you keep moving -

You...

How many rows are in the tables? If it is too many, you may need to figure out a different approach -

But you may want to try this:

INSERT INTO LocalTable(...)

SELECT...

Don't know about DTS. But the easiest option that I can think of for other DB Objects is that you could try and generate SQL script file (been a while...

Oh, sorry, forgot to include the first question I wanted to ask -

0. What are you trying to get out of the query? You don't even seem to be selecting...

My Qs:

1. It seems you have forgotten to include the first query (you are refereing to two queries in your question).

2. How many records are in the table?

3. Have you...

Not sure why you are using dynamic sql here - it is not recommended (you may want to lookup SQL Injection for more info).

Will this not work for you?

CREATE PROCEDURE...