SQLServerCentral / Article Discussions / Discuss content posted by Peter Petrov / Article Discussions by Author / Yet Another Deleting Duplicate Records (in-place) / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:07:24 GMT20RE: Yet Another Deleting Duplicate Records (in-place)http://www.sqlservercentral.com/Forums/Topic629418-623-1.aspxThanks, 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,PeterThu, 15 Jan 2009 13:19:03 GMTPeter PetrovRE: Yet Another Deleting Duplicate Records (in-place)http://www.sqlservercentral.com/Forums/Topic629418-623-1.aspxPeter,You can do it with CTE like thisWITH x As (select row_number() over (partition by id1, id2 order by id2) nr FROM MyTab)delete FROM x where nr &gt; 1Thanks,OdedWed, 14 Jan 2009 22:01:35 GMTodeddrorYet Another Deleting Duplicate Records (in-place)http://www.sqlservercentral.com/Forums/Topic629418-623-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/TSQL/65420/">Yet Another Deleting Duplicate Records (in-place)</A>[/B]Sat, 03 Jan 2009 21:28:49 GMTPeter Petrov