Re: finding and removing duplicates rows
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 03/17/04
- Next message: Wayne: "Transaction log allocated size- I need to make it smaller"
- Previous message: Erland Sommarskog: "Re: Performance goes down"
- In reply to: Stephen: "Re: finding and removing duplicates rows"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 18 Mar 2004 00:54:00 +0100
On 17 Mar 2004 05:24:49 -0800, Stephen wrote:
>Thanks for the message, it definately helped solve a lot of issues.
>
>Is there a way to do everything mentioned, but without having a unique
>key for each record?
No. If all columns in two rows are the same, there's no way to tell
them apart. Any where clause will either select both rows or none of
them. If you want to eliminate duplicates, you have to add an IDENTITY
or GUID column, or else you will delete both rows instead of one of
the duplicates.
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: Wayne: "Transaction log allocated size- I need to make it smaller"
- Previous message: Erland Sommarskog: "Re: Performance goes down"
- In reply to: Stephen: "Re: finding and removing duplicates rows"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
