• 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)