2013-03-06

TSQL - Handling multiple CTEs


with
       cte(Num) as
       (
              select 1 as Num
              union all
              select 1.2
       )
       , cte2(Num2) as
       (
              select 2 as Num2
       )
select *
from
       cte cross join cte2
;

No comments:

Post a Comment