removing duplicate data from one table

[PJSWEAT]

Hi all, I am trying to figure out how to find duplicate records in a single table, and remove all but one of those records. I would also like to insert the records I am deleting into an audit table, any thoughts?
thanks!

 

[dodge20]

In Access help, if you do a search for delete duplicates, it gives you a step by step process on how to do this. It is pretty quick too. I think it is an append query, but I don't remember for sure.

Dodge20

 

[dodge20]

Sorry I thought I was in the Access forum. Can you get your data into Access?

Dodge20

 

[tlbroadbent]

http://support.microsoft.com/default.aspx?kbid=139444

http://support.microsoft.com/default.aspx?kbid=70956

faq183-2682 - Handle duplicate records

http://www.sqlteam.com/item.asp?ItemID=3331

http://www.databasejournal.com/features/mssql/article.php/1438651

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm