;WITH CTE1 as (select whatever), CTE2 as (select whatever) SELECT * from SomeTable JOIN CTE1.... JOIN CTE2But this is NOT permitted
;with cte1 as (select whatever) select * from sometable join CTE1 select * from somedifferenttable join CTE1On the other issue with the link to the Microsoft Connect item, I understand what you mean, though no idea if it would ever be implemented. In reading the posts, I'm a little confused whether that became part of the SQL specification beyond the '99 standard (specifically, if it was expanded in SQL:2003)