SQLServerCentral.com Content tagged T-SQL, Hierarchy

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Thu, 15 Nov 2012 07:00:00 UT

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

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

Tue, 13 Nov 2012 07:00:00 UT

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".

Displaying Sorted Hierarchies (SQL Spackle)

Thu, 10 Mar 2011 07:00:00 UT

Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.