Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

Code download available at: SQLHierarchyID2008_09a.exe (155 KB)
Browse the Code Online

This article is based on a prerelease version of SQL Server 2008 RC0. All information herein is subject to change.

This article discusses: Modeling hierarchical data Creating a bill of materials system Moving to HierarchyID Testing the system

This article uses the following technologies:  SQL Server 2008

  Contents

Hierarchical Data
A Bill of Materials Problem
Using Entities to Understand the Problem
A BOM System in SQL Server 2005 
Create the Tables
Queries to Validate the Design
Taking Advantage of HierarchyID
Testing the HierarchyID Implementation
Wrapping Up 


http://msdn.microsoft.com/en-us/magazine/cc794278.aspx