Your example shows
SELECT *
From dbo.Organization
WHERE @BossNode.IsDescendant(EmployeeID)
How is this rewriten using IsDescendantOf?
Thanks for the article, very interesting!
Jake
Found the answer in case any other newbs stumble across this:
DECLARE @C AS HierarchyID
SELECT *
From dbo.Organization
WHERE @C.IsDescendantOf(Organization.EmployeeID)