If I use IsDescendantOf(@HierarchyIdOfParentNode) = 1, the result includes the parent node as well. How do I use IsDescendantOf without having the parent node included in the result set?
It's easy enough to add a WHERE clause and exclude the parent node but I thought there may be a better way to do it.
AFAIK, using a WHERE clause is the best way to do it.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?