Drew Burlingame (3/17/2006)Thanks for taking the time to post this article.I am curious as to performance compared to other methods of getting heirarchical data like adjacency, nested, etc.?The CTE method of unrolling a hierarchy uses the adjacency model.