Unanswered: Table with Duplicate Entry with Primary Keys
We have a SQL Server 6.5 table, with composite Primary Key, having the Duplicate Entry for the Key. I wonder how it got entered there? Now when we are trying to import this table to SQL2K, it's failing with Duplicate row error. Any Help?
I don't have a clue how it got duplicated. If you don't care which copy you use, just pick one of them (use SELECT DISTINCT). If you want to preserve both copies, you need to decide how you want to preserve them because you'll have to change something in the PK in order to keep both rows.