>>>Delete myTable from myTable inner join Dups on myTable.DupKey = Dups.DupKey and myTable.PK > Dups.MinKey
>
>can you tell me about the last part? How does the primary key being greater than the minkey granted the minkey stands for minimum key going to help us?
The idea is to remove all duplicates except one. I chose the one with the Min primary key to stay in the table.
If it's not broken, fix it until it is.
My Blog