dbWriter SQL DELETING DUPLICATE RECORDS:
As you know it is difficult to get rid of duplicate records in a SQL
database.
There are a lot of scripts out there that will find them for you BUT
deleting them will only cause an error because the server cannot
distinguish between them.
THE FIX:
Modify the SQL table and add a unique integer identity column to the
table.
This will make each row unique and then you can delete or leave
any row YOU chose!!!
Then you can remove the column if you wish BUT without it you will
have the same problem in the future. |
