Define extremely large??

Will you have the need to reuse the archived data later for reporting tasks?? If this is the case then I would suggest you move that data...

Can you post the tables definition with some sample data, along with the expected output. Also the code to generate the newid would be nice. It'll be easier...

Maybe somebody already said that but I'm gonna said it anyways : A case statement (in vb or C++) is just a big list of if elseif elseif elseif...

That was my other solution .

There is no duplicate data in this list :

10 John A

20 ...

I can't talk on the behalf of amazon, but if you could post the tables definition, maybe we could give you some pointers.

It's always a good idea to have a check before a drop. That way you won't have errors when you run the script.

With the lack of follow up from the starter of the thread, I'll assume that this has been answered .

I tried on all my servers and still no difference (all sql server 2000 but with different service packs (3+)). So I'm officially out of ideas.

Have you contacted Microsoft...

Why are you trying to remove the duplicate ids and country?

Are you sure you need this in a single statement?

Is this what you're looking for???

Declare @a as int

set @a = 1

if @a = 1

begin

set @a = @a * 3

select @a as A

end

else

begin

set @a = @a / 3

select @a as...

Can you post the table definition of the table (telling which field needs to be updated)? I'll be able to give you the query then.

Also I meant this in...

HTH.

Isn't sp_executesql limited to 4000 characters?

I don't want to seem needy, but I don't see any duplicates in the data you sent us.

Which columns have duplicate values?