rsbutterfly16
Registered User.
- Local time
- Today, 07:57
- Joined
- Jun 5, 2006
- Messages
- 77
Hi guys , I am trying to do a dts in which copies a table with duplicates, and then puts the data but it cannot have any duplicates. What is the best way to do this? I remember long time ago I saw a trick of how to do this by coping the table and then inserting a pk into the table, not sure of how it was, but I don’t seem to find the article … I don’t want to omit all the duplicates, I have to keep one row and then omit the other copies.