Yet Another Deleting Duplicate Records (in-place)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Peter Petrov » Yet Another Deleting Duplicate Records...

Yet Another Deleting Duplicate Records (in-place)

Rate Topic

Display Mode

Topic Options

Author

Message

Peter Petrov

Posted Saturday, January 03, 2009 9:28 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 18, 2013 2:36 PM
Points: 1,185, Visits: 288

Comments posted to this topic are about the item Yet Another Deleting Duplicate Records (in-place)

Post #629418

odeddror

Posted Wednesday, January 14, 2009 10:01 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 18, 2013 6:44 AM
Points: 194, Visits: 198

Peter,

You can do it with CTE like this

WITH x As (select row_number() over (partition by id1, id2 order by id2) nr FROM MyTab)
delete FROM x where nr > 1

Thanks,
Oded

Post #636820

Peter Petrov

Posted Thursday, January 15, 2009 1:19 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 18, 2013 2:36 PM
Points: 1,185, Visits: 288

Thanks, Oded.

Unfortunately the CTE method does not work with SQL 2000. Last year I needed to cleanup hundreds tables in order to introduce primary keys, before 2000 - 2005 conversion and my method worked pretty well.

Regards,
Peter

Post #637540

« Prev Topic | Next Topic »

Permissions