List Menu Hierarchy Using Sql Server Hierarchyid

I try to build a menu using the datatype hierarchyid. I have the root node and the current selected node. now I want to list of all elements that are related wetween root and selec

Solution 1:

Not entirely sure I understand the question but could you not do something like the following with the WHERE clause:

WHERE@selectedNode.IsDescendantOf(MenuNode.GetAncestor(1)) =1

Tom