Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2011
    Location
    Corpus Christi, TX
    Posts
    26

    Unanswered: Process for Removing Duplicates in Table

    I have a very large table that can contain up 3 to 5 duplicate records. Every month around 100,000 new records come in. Sometimes it's an ammended record, other times is just duplicated by error.

    Is it possible to keep the latest record dumped into the table and delete the others? Does SQL track the order of the data being dropped into the table?

    The layout would look like this. There are 10-15 other columns in the table where adjustments can also be made.

    Lease# Year Month Production
    12345 2008 10 1,231
    12345 2008 10 1,250
    12345 2008 10 1,250

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    When the amended records arrive, are they complete or are they only the data to be changed?

  3. #3
    Join Date
    Oct 2011
    Location
    Corpus Christi, TX
    Posts
    26
    They are complete.

Posting Permissions

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