我正在简化一个复杂的select语句，因此以为我会使用常见的表表达式。

声明单个CTE可以正常工作。

WITH cte1 AS (
    SELECT * from cdr.Location
    )

select * from cte1

是否可以在同一SELECT中声明和使用多个cte？

即此SQL给出了一个错误

WITH cte1 as (
    SELECT * from cdr.Location
)

WITH cte2 as (
    SELECT * from cdr.Location
)

select * from cte1    
union     
select * from cte2

错误是

Msg 156, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'WITH'.
Msg 319, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

注意 我尝试将分号放入并得到此错误

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ';'.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near ';'.

可能不相关，但这在SQL 2008上。