Viewing 15 posts - 17,311 through 17,325 (of 18,923 total)
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...
June 7, 2005 at 7:59 am
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...
June 7, 2005 at 7:55 am
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...
June 7, 2005 at 7:40 am
That was my other solution
.
June 7, 2005 at 7:24 am
There is no duplicate data in this list :
10 John A
20 ...
June 7, 2005 at 7:23 am
I can't talk on the behalf of amazon, but if you could post the tables definition, maybe we could give you some pointers.
June 7, 2005 at 7:14 am
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.
June 7, 2005 at 6:59 am
With the lack of follow up from the starter of the thread, I'll assume that this has been answered
.
June 7, 2005 at 6:57 am
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...
June 7, 2005 at 6:51 am
Why are you trying to remove the duplicate ids and country?
Are you sure you need this in a single statement?
June 7, 2005 at 6:48 am
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...
June 7, 2005 at 6:41 am
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?
June 7, 2005 at 6:26 am
Viewing 15 posts - 17,311 through 17,325 (of 18,923 total)