• Hi Parker,

    As far as I experienced, CTEs are using same execution plans as a normal view query.

    So as you wrote I believe it makes no sense to use CTEs instead of views.

     

    But if you are working with hierarchical data then CTEs are the address to look for a reliable solution

     

    Eralper

    http://www.kodyaz.com