Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

  • November 14, 2012 at 7:37 am

    #1558927

    mister.magoo (11/14/2012)

    you can use

    row_number() over (order by @@spid)

    Yes, that's the one!