title: How does hierarchyid data type work?
body: <p>I would like to make a CLR user-defined type in SQL Server 2005 that has the same performance benefits as hierarchyid to model hierarchies.</p>
  
  <p>Does anyone have any ideas/pointers?</p>