Purging duplicate records

• Richard Buchner, Chicago

  Ten Centuries

  Points: 1390

  More actions

  October 24, 2002 at 1:04 pm

  #79692

  I have large table, it has quite a few duplicate records, on customer and order number and order date. I'd like to delete the duplicates , keeping the original.

  Any tips on how to do this? thanks

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  October 24, 2002 at 1:13 pm

  #439393

  Here is a KB article that might give you some ideas:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q139444

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP