Delete one of duplicated records | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Delete one of duplicated records

I can locate the duplicated records in a table. I have written a script using CURSOR and WHILE loop to travers the table and insert rows to other table and prevent to insert dupliacted records. It is very slow. Is there any faster or easier way to delete duplicated records? Note that I need to have only one of the duplicated records in my table. Thanks, CanadaDBA
I should write the title as "Keep one of duplicated records" CanadaDBA
There already is one. Look at the articles at . They have one that deals specifically with deleting them. And there’s definitely a faster way. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA. (Derrick’s mentioned) Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thank you gentelmen, Your replies are complete. CanadaDBA