Subscribe to this blog
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, 550 reads
Posted in Dave Ballantynes blog on 27 May 2010