Hierarchies: Convert Adjacency List to Nested Sets

Editor’s Note: The following MVP Monday post is by SQL Server MVP Jeff Moden and is part of our special series on SQL Server 2012. Hierarchies: Convert Adjacency List to Nested Sets Introduction If you search the Internet for articles on hierarchical data in SQL Server, you’ll find that there are many types of hierarchies…