Simple question about IsDescendantOf

Question

Hi,

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.

---

Thanks, Sam

Answer 1

AFAIK, using a WHERE clause is the best way to do it. 

Tom