Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

  • Article

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".

4.9 (60)

2014-09-19 (first published: )

21,386 reads


Improving TweetDeck with Better TweetDeck


If you are at involved with the #sqlfamily, you are bound to hear about...

Interview with Bob Ward


This is the eight interview we have done. This time our guest is the...

SQL in the City Comes Back to Seattle


This year at the PASS Summit, Redgate is holding our SQL in the City...

Read the latest Blogs


Selecting data from two columns

By GPGAgent

The table has many columns, two of which are mutually exclusive, LocationNo and assetNo,...

Refresh data warehouse with production data

By Lord Slaagh

Hello SSC, I want to create a package that refreshes the tables in my...

SSIS Deployment w params

By Darryl Wilson

<!--more-->Hi I have a simple package that exports data via ftp using a dynamic...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers