SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2010

Challenge 19 – An Explanation of a Query

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved traversing a hierarchy of employees and rolling a count of orders from subordinates up to superiors.

The first concept I shall address is the hierarchyId , which is constructed… Read more

0 comments, 1,691 reads

Posted in Dave Ballantynes blog on 27 May 2010