Deleting duplicate records

Results 1 to 2 of 2

Thread: Deleting duplicate records

  1. #1
    Join Date
    Dec 1969

    Default Deleting duplicate records

    I have a table (SQL Server) which has some duplicate email addresses. I want to delete the duplicates and then set a primary key for that field. Any ideas?<BR><BR>I thought I could simply make a new table with the same fields, set the primary key on the new field and then insert all the records from the old table into the new. But I get a primary key violation error when I try that...

  2. #2
    Join Date
    Dec 1969

    Default RE: Deleting duplicate records<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts