Home Forums SQL Server 2005 SQL Server 2005 General Discussion number the Group on data from two columns duplicated RE: number the Group on data from two columns duplicated

  • March 2, 2010 at 6:28 pm

    #1127483

    Jeff Moden (1/15/2010)

    shaini.binu (1/15/2010)

    Hi,

    I have solved the puzzle with the help of cursurs, Thanks for all the help,

    Thanks

    Sh.

    Two way street here, shaini... please post the code for your solution.

    Heh... so much for Shaini... 😉 Stuck with cursors and doesn't even know he has a problem... yet.

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