Hi All,

I have a table in SQL server 7 where all the records(rows) have been duplicated i.e. all rows have atleast 3 entries in the same table plus the table missed out the primary key. Now i wanted to delete all the duplicate records from the table at the same time one entry for the same (duplicate) row should remain in the database.
Can anyone help me out.

ExpertCalling

what does "plus the table missed out the primary key" mean?

how many columns are in this table? can you show some sample rows?

You can try this:

1) Rename the table with the duplicates.
2) Create a new empty table with primary key enabled.
3) Insert 'DISTINCT' from old table -- or:

Code:

INSERT INTO New_Table
SELECT * FROM Old_Table O
 WHERE NOT EXISTS (
       SELECT 1 FROM New_Table N
        WHERE N.Primary_Key = O.Primary_Key)