Im using SQL Server 2005 . I have 2 WITH Clauses in my stored procedure
WITH SomeClause1 AS ( SELECT .... ) WITH SomeClause2 AS ( SELECT .... )
But the error occurs
Incorrect syntax near the keyword ‘with’. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
What are my options? Is there any splitter I don’t know about?
Advertisement
Answer
Use a comma to separate CTEs
;WITH SomeClause1 AS ( SELECT .... ) , SomeClause2 AS ( SELECT .... )