Data Hierarchies With SQL Server 2008http://blogs.msdn.com/b/msdnmagazine/archive/2008/09/05/8924626.aspxSQL Server 2008 supports a new data type, HierarchyID, that helps solve some of the problems in modeling and querying hier­archical information. In the September 2008 issue of MSDN Magazine , Kent Tegels introduces you to the HierarchyID data type byen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)