THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » hierarchies   (RSS)
  • Time to Start Plotting My 2016 Database Design Book

    Note: A new version has been talked about for years, but it is not a guarantee. This post is my way of introducing the new features of SQL Server, and follow on posts will be code filled example of how the features will work. I am making no promises at this time, but when I can, I will. With the recent release of a CTP version of what is called ...
    Posted to Louis Davidson (Weblog) by drsql on June 16, 2015
  • Re-Inventing the Recursive CTE

    Working with hierarchies in SQL Server never fails to be absolutely fascinating. On the face of things they’re super-easy to model and seem to fit perfectly well: parent_key, child_key, self-referencing FK, and you’re done. But then you go to query the thing and there is a complete breakdown. Prior to SQL Server 2005 the product included zero ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 7, 2015
  • Speaking this week at Richmond SQL Server User Group

    Thursday night, at 6:00 (or so) I will be speaking in Richmond ( ), talking about How to Implement a Hierarchy using SQL Server. The abstract is: One of the most common structures you will come across in the real world is a hierarchy (either a single parent ''tree'' or a multi-parent ''graph''). Many systems ...
    Posted to Louis Davidson (Weblog) by drsql on June 8, 2014
  • 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 Continued Fractions technique that Tropashko presented in a later ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • 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 else. But anyway, the point is, I'm going to adhere to that standard.  But ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Privacy Statement