Hierarchy ID Model Your Data Hierarchies With SQL Server 2008 Kent Tegels Code download available at:SQLHierarchyID2008_09a.exe(155 KB) This article is based on a prerelease version of SQL Server 2008 RC0. All information herein is subject to change. Contents Hierarchical Data A Bill of Materials Problem Using Entities to Understand the Problem A BOM System in SQL Server 2005 Create the Tables Que