Hi Thom,
Sorry for the reply.
I am coming from an SAP HANA background where CTEs are still evolving . We dont have the option of doing recursive CTE or rCTES (Frankly I was not aware that there existed something like rCTEs).
I tried to breakup your rCTE and did individual select statements.Obviously that did not work ..
BR
Arshad
Did you tried the method that I explained in the article? It's simple, does not require CTEs and will be very fast.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2