Incorrect syntax near the keyword 'with'

Question: Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespace clause or a change tracking context clause, the previous statement must be terminated with a semicolon:


Login to See the Rest of the Answer

Answer: The error message is quiet discriptive, if you have a CTE in your SQL Query, you need to terminate the leading Query to the CTE. the CTE should supposedly be the first to execute in the Call Tree.

Added by AI:
This error message usually indicates that there is a syntax error in a SQL query, specifically near the keyword "with". The error message also suggests that the previous statement should be terminated with a semicolon if it includes a common table expression, an xmlnamespace clause, or a change tracking context clause.

Here are a few potential reasons why you might be encountering this error:

1. Incorrect syntax: The most likely cause of this error is a syntax error in your SQL query. Check the syntax of your query and make sure that it is correct.

2. Missing semicolon: If you have a common table expression, an xmlnamespace clause, or a change tracking context clause in your query, you need to terminate the previous statement with a semicolon before starting the new clause.

3. Database compatibility: Some versions of SQL Server have different syntax requirements than others. Make sure that your query is compatible with the version of SQL Server that you are using.

To fix this error, try checking the syntax of your query and making sure that you have terminated any previous statements with semicolons if necessary. You may also need to ensure that your query is compatible with your version of SQL Server.