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 Continued Fractions technique that Tropashko presented in a later ...

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 else. But anyway, the point is, I'm going to adhere to that standard.  But ...