Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 568 reads

Posted in Dave Ballantynes blog on 27 May 2010