Find/Change/Delete duplicates

[Nickman]

Hi

Table design is:

TCustomer TProduct TReport
.Cust_ID .Cust_ID .Cust_ID
.Name
.Zip

I have to find duplicates in TCustomer. The first found Record is saved and the TProdut.Cust_ID/TReport.Cust_ID of the duplicates has to be changed to the "first found record". Then the duplicate is to be deleted.

- I cannot copy the Table (ca. 3GB, over 1 mio. records)
- If possible, all in SQL
- Using SQL Server 7.0

thx in advance
Nick

 

[tlbroadbent]

Nick,

Post this question in the SQL Server forum (forum183) where you'll get a SQL Server specific answer. This is an ANSI SQL forum and SQL Server is not 100% ANSI compliant. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.