>Yes, that seems better, much better
>_

I posted a blog about it

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/cte-and-hierarchical-queries It's a first version, so the critique / improvements suggestions are more than welcomed.