I have a table w/ 17K line items. There are only 8.5k I want because each one is duplicated exactly twice. How do I get one of each of these line Items into a new Table?
I tried this:
Select DISTINCT * from DuplicateTable INTO NewTable
And it doesnt work. I am still getting the 17K transported over... any solutions?Since you got the full 17K items, there is something that is different about the whole row. Pick a pair of "duplicates, and set them side by side. You should be able to pick out a difference, whether it be an identity column, GUID column, or just some detail column that is not part of what should have been the primary key. Good luck.
Showing posts with label prob. Show all posts
Showing posts with label prob. Show all posts
Subscribe to:
Posts (Atom)