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,436 reads
Posted in Dave Ballantynes blog on 27 May 2010