title: SQL-Server: Incorrect syntax near the keyword 'with'. If this statement is a common table expression
body: <pre><code>create table #temp
  (
    pName Varchar(20),
    DateBegin DateTime,
    DateEnd DateTime
  )
  
  Insert Into #temp(pName, DateBegin, DateEnd)
  Values('Player1', '01/04/2012', '01/05/2012')
  
  Insert Into #temp(pName, DateBegin, DateEnd)
  Values('Player2', '02/01/2012', '02/05/2012')
  
  
  With DateRange(dt) As
  (
      Select Convert(Datetime, '01/01/2012')
      UNion All
      Select DateAdd(dd, 1, Dat.dt) From DateRange Dat Where Dat.dt &lt; CONVERT(Datetime, '01/31/2012')
  )
  
  Select T.pName, Dt.dt from #temp T
  Inner Join DateRange Dt on Dt.dt BETWEEN T.DateBegin and T.DateEnd
  
  Drop Table #temp
  </code></pre>
  
  <hr>
  
  <p>Issue is with this following code line     </p>
  
  <pre><code>With DateRange(dt) As
  </code></pre>
  
  <p>It shows following error message</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>