Incorrect syntax near the keyword 'with'...previous statement must be terminated with a semicolon

Question

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?

user_3134543 · Answer

Try with upgrading SQL Server Database COMPATIBILITY_LEVEL

ALTER DATABASE DatabaseName SET COMPATIBILITY_LEVEL = 130

Reference Link :- https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database?view=sql-server-ver15

Incorrect syntax near the keyword 'with'...previous statement must be terminated with a semicolon

4 Answers