• mickyT (10/20/2013)


    The 'no reverse' is an interesting requirement.

    I believe what we have here is homework about how to use WHILE loops and the instructor probably never heard of a Tally or Numbers table. Although it's good for people in the tuning business, I wish instructors would get a clue about such "pseudo cursors".

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