• leonie6214 (4/16/2013)


    I am sorry but I was not aware of the rules. However, I did include the table structure w/insert statements; I also attached an excel spreadsheet with the desired output in the previous post.

    Anyway, you may have resolved my issue. I will test it and reply to you again.

    Thanks for you help.

    leonie6214

    Not rules. Just trying to help and the requirements changed and the data load didn't work.

    Glad you got it to work, though.

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