08 October 2010 09:32 tonyrogerson

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.

HierarchyID

Point in time hierarchy.

 

Filed under:

Comments

# Twitter Trackbacks for Code from talk on Hierarchies at Edinburgh UG 2010-10-07 - Tony Rogerson's ramblings on SQL Server [sqlblogcasts.com] on Topsy.com

08 October 2010 10:24 by Twitter Trackbacks for Code from talk on Hierarchies at Edinburgh UG 2010-10-07 - Tony Rogerson's ramblings on SQL Server [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Code from talk on Hierarchies at Edinburgh UG 2010-10-07 - Tony Rogerson's ramblings on SQL Server         [sqlblogcasts.com]        on Topsy.com