Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    37

    Unanswered: Another simple prob I cant fig out

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •