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

Posted on SQL Server Central See other posts from SQL Server Central
Published on Thu, 15 Nov 2012 07:00:00 UT Indexed on 2012/11/15 23:17 UTC
Read the original article Hit count: 331

Filed under:

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?

SQL Developer Bundle 12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

© SQL Server Central or respective owner