This post by Simon Ince explores the topic of Hierarchies with HierarchyID in SQL 2008. If you’ve been following my blog you should remember a couple of posts about hierarchical data in SQL Server, and how Common Table Expressions can be a great way to
Read More...