Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Simple question about IsDescendantOf

Answered Simple question about IsDescendantOf

  • Saturday, January 26, 2013 2:36 AM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Saturday, January 26, 2013 2:55 AM
     
     Answered
    Sign In to Vote
    0

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

    Tom