title: HierarchyID How to get all Parent from a child
body: <p>i've a Problem with the hierarchyID and UserRights for a Menu. I only want to give the User the Right for Level 4 for example and my QUery should automaticly select all Parent from the Level 4 Child. 
  How to do this ?</p>
  
  <p>Do you understand my Problem ? I simply want all Parents (ancestors) from a child.</p>
  
  <p>Greets Manuel</p>