Duplicate Detection

  • Quick question? Does anyone have any good pointers for a Merge/Purge utility that directly connects to SQL server and then reports what is a duplicate?

    most of the one's I've found online consist of creating a txt file of your data and then run it through the software in which you have import the txt file into the db. Any thoughts or comments are much appreciated.

    Thanks

  • Post the table schema and the columns you would consider in deciding if a row where a duplicate or not... there's hardly any reason to go to text files and such... it's pretty easy to do in T-SQL...

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply