Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Displaying Sorted Hierarchies (SQL Spackle) RE: Displaying Sorted Hierarchies (SQL Spackle)

  • March 10, 2011 at 7:21 am

    #1297089

    GSquared (3/10/2011)

    I've used a variation on this solution for sorting before, and found that it works best if you pad numerical values with leading zeroes to a fixed length, before sorting them as character data.

    Hi Gus,

    Thanks for stopping by. I agree... even better is the method of converting numeric ID data to BINARY(4) data and concatenating that information into a VARBINARY() column... sans slashes, of course.

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