title: How can I do a Cascading Delete with the SQL 2008 HierarchyID data type?
body: <p>I haven't used the HierarchyID much, so I'm a little unsure. If my table has a HierarchyID, how do I perform a cascading delete? (i.e. delete all 'children' when deleting the 'parent')</p>
  
  <p>I assume I would have to use a CTE and HierarchyID functions, but not sure how to go about it...</p>