Browse by Tags

• Swinging From Tree to Tree Using CTEs, Part 2: Adjacency to Nested Intervals

  In our previous installment , we saw how to convert Adjacency Lists into Nested Sets using a CTE. In this episode, we will convert the Adjacency List into a Nested Intervals encoding. Specifically, this encoding will make use of the Nested Intervals with Read More... Posted Wednesday, July 12, 2006 10:49 PM by Adam Machanic | 4 Comments Filed under: Hierarchies, T-SQL

• Swinging From Tree to Tree Using CTEs, Part 1: Adjacency to Nested Sets

  I'm not sure how many times over the last several years I've seen the same tired article titles... "Climbing Trees in SQL," "Climbing Up the SQL Tree," or maybe, "Naked Coeds Playing in the Trees!" ... Oh wait, I think that last one might be something Read More... Posted Wednesday, July 12, 2006 10:47 PM by Adam Machanic | 19 Comments Filed under: Hierarchies, T-SQL