I want to clean out our database. We have alot of duplicate records. I want
to run a query on email address to find all the remove all but one of the
duplicate records. I am only working with one table. Can someone help?

TIA
TRD

Check the following articles - they will walk you through
the process:
How to remove duplicate rows from a table in SQL Server
http://support.microsoft.com/?id=139444

How do I remove duplicates from a table?
http://databases.aspfaq.com/database/how-do-i-remove-duplicates-from-a-table.html

-Sue

On Wed, 27 Sep 2006 17:02:28 -0400, "TRD"
<tdejoh***@hotmail.com> wrote:

Show quoteHide quote

2005 TRY-CATCH BLOCKS - QUESTION
performance problems after upgrade to sql server 2005 sp1
SQL 2005 Eval
Create View based on User-Defined Function
SQL 2005 serious memory leak above 21 cores on Unisys ES7000
Backup and Restore best practices
Creating a Bottleneck.
Memory Issue
ran out of space
Database size for SQL Server 2000 Personal Edition ?