dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Please see the following. It's pretty simple to do once you know how...I was initially expecting to have to use the standard rCTE adjacency list traversal, but then it seemed the OPs requirements were a bit simpler. That why I said it looked "too easy."
Understood and, to be sure, I wasn't knocking you. I was just offering an alternative.
--Jeff Moden
Change is inevitable... Change for the better is not.