08 October 2010 09:32
Code from talk on Hierarchies at Edinburgh UG 2010-10-07
The code for the demo's I talked through at the Edinburgh SQL Server User Group can be found here: http://sqlblogcasts.com/blogs/tonyrogerson/UKSSUG/UG20101007%20-%20Hierarchies.zip
I explain recursive CTE's.
I show how to do an adjacency list (parent/child) in SQL using recursive CTE's.
Materialised Path in SQL.
Point in time hierarchy.
Filed under: Hierarchies