T-SQL Challenges

Technical Article

TSQL Challenge 19 - Working with consolidated calculations on hierarchical structures

  • Article

This challenge involves generating an organizational hierarchy and calculating the total orders created by each employee and his/her subordinates. It involves a number of challenges such as generating a resultset in the correct hierarchical form, calculating the orders created by each employee and his/her subordinates and finally calculating the total orders created by self and all the subordinates.

2009-12-14

2,432 reads

Blogs

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

FabCon 2025 Recap

By

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Read the latest Blogs

Forums

The Subtle Differences Between COALESCE and ISNULL

By omu

Comments posted to this topic are about the item The Subtle Differences Between COALESCE...

SQL Server Collations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Collations

Why would using a variable vs Hard Value impact a Query's Performance

By YSLGuru

Why would using variables in place of hard coded numbers impact a query's performance? ...

Visit the forum

Question of the Day

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

See possible answers