steve.tarry (1/21/2015)
Thanks for the piece of code. Very nice. In the grand scheme of things the CTE query executes very quickly but happy to use a better solution.Great stuff.
Have a good day.
CTEs are great. It's the recursive ones that increment that are both a performance and resource usage problem.
--Jeff Moden
Change is inevitable... Change for the better is not.