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 14, 2011 at 9:47 am

    #1298413

    Jeff Moden (3/10/2011)

    CirquedeSQLeil (3/10/2011)

    Nice article Jeff. I have used a very similar method to this for very large hierarchies. Nice examples and well explained and illustrated.

    Thank you, Jason. Since you're working with very large hierarchies, have you or are you using the HierarchyID datatype at all?

    No, we don't use the HierarchyID datatype - not at all.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events