The new HIERARCHYID data type in SQL Server 2008 is a system-supplied CLRUDT that can be useful for storing and manipulating hierarchies. It is internally stored as a VARBINARY that represents the position of the current node in the hierarchy. You can create indexes,...