• dwain.c (11/15/2012)


    Jeff - Working through it now but its pretty deep and I expect it will take me awhile.

    Great explanations though!

    I'm going to try to see if I can adapt the approach to another problem I encountered recently that is "not quite" a hiearchy.

    Let me know if you decide to change your name to John. I have several article attributions to you I'll need to change.:-D

    Thanks, Dwain. I'd be interested in your "not quite a hierarchy" problem. Sounds interesting.

    Heh... nah. Not going to change my name. Too much paper work for us all. 😀

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