I just happen to have a beautiful test bed for such testing in my "Hierarchies on Steroids" articles. When I get the chance, I'll convert the rCTE in the first article to a WHILE loop and see what happens.
--Jeff Moden
Change is inevitable... Change for the better is not.