This did the trick. Thanks for everybodies help.

I got that to work but wht I need now is to Drop the original column (not a problem) but then rename one of the new column back to the...

I am adding 4 new column into an already existing table then updating them.

How would you run this?

In an ALTER TABLE STATEMENT?

This worked like a champ. Thanks

So what do you suggest?

I need the Select Top 10 ... line to set the @@ROWCOUNT because it check the temp table to see if it has a record in...

Thanks, This worked great.

Yes, there will be multiple records in #SPs and from that I need the min and max encounter date which will be returned to the #log table.

This code just checks...

Sorry, it should have read:

IF @@ROWCOUNT > 0

BEGIN

-- Update #Log

INSERT

I took Jeff idea and ran with it. Its working fine now.

Thanks for all the input.

Thanks for everybodies input. I went with Lynn original code and it worked great. Thanks you all.

When I run the following code I get this error:

Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near '<'.

update

dbo.RespondentProperties...

So this was onging for a few days then I take it? Can you give me more detail on the exact implmentation you used to do this. This sounds like...

That seems to be a lengthy way to do it. What would you consider the right size for the batches?

You guys rock!!! PW's script worked like a champ. Although John's did return any thing. Not sure why. But thanks a lot.