title: Incorrect syntax near the keyword 'with'...previous statement must be terminated with a semicolon
body: <p>Im using SQL Server 2005 . I have 2 WITH Clauses in my stored procedure</p>
  
  <pre><code>WITH SomeClause1 AS
  (
    SELECT ....
  )
  WITH SomeClause2 AS
  (
    SELECT ....
  )
  </code></pre>
  
  <p>But the error occurs</p>
  
  <p>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.</p>
  
  <p>What are my options? Is there any splitter I don't know about?</p>