Common Table Expressions CTEs query recursion recursive queries recursive queries Recursive Queries Using Common Table Expressions recursive common table expression Common Table Expressions Microsoft Recursive Query using Common Table Expressions recursive common table expression Recursive Common Table Expression TechNet has some examples for you recursive common table expression Recursive Queries Using Common Table Expressions CTEs