How to find ALL Ancestors using HierarchyID for SQL Server

Posted by Luke101 on Stack Overflow See other posts from Stack Overflow or by Luke101
Published on 2010-04-18T02:28:12Z Indexed on 2010/04/18 2:33 UTC
Read the original article Hit count: 1295

I have searched the internet for an answer to this. I don't want to use recursion using getancestor because I think that defeats the purpose. I am trying to get the lowest ancestor of a child. I am using this for breadcrumbs. Thanks

© Stack Overflow or respective owner

Related posts about hierarchical-data

Related posts about hierarchy