Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

  • April 3, 2014 at 8:27 am

    #1702885

    kathy.m.davis.ctr (4/3/2014)

    Thank you for the excellent information! Is there a way to order the personnel in each level by something besides EmployeeID? My user wants to specify the order of the personnel in each level. For example, in level 2, instead of ordering Lynne, Bob, Ken and Marge, he wants Marge, Bob, Lynne, Ken. He wants to do this for each level. Our table has a column UICOrder (int) where the user enters the order of how he wants the items in each level to appear. Your solution in this article works for me except for the ordering of the levels. Any assistance is greatly appreciated!

    Thank you,

    Kathy Davis

    I'll have to take a look at this after work tonight, Kathy. And, thanks for the feedback.

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