Home Forums SQL Server 7,2000 T-SQL eliminating duplicates RE: eliminating duplicates

  • July 1, 2008 at 6:35 am

    #836607

    You guys are missing the point of this particular exercise... despite the name of the post, this is NOT about the elimination of duplicates. Here's what the op wanted...

    1. Remove 1 row from any group of dupes.

    2. Remove all rows that are not dupes.

    3. Cannot use any form of intermediate table. No table variable, no temp table, not even the working table formed by a cursor.

    4. Cannot add any columns to the original table.

    --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)