title: Check date interval with SQL Server
body: <p>Hi in a stored procedure I want to select rows that are in an interval of a month where
  @Anno is the year of the start and @Mese is the month of the date start. I try this:</p>
  
  <pre><code>WHERE FinePeriodo &gt;= CAST((@Anno + '-' + @Mese + '-01 00:00:00') as datetime)
      AND FinePeriodo &lt; 
             DATEADD(month, 10, CAST(
                 (@Anno + '-' + @Mese + '-01 00:00:00') as datetime)) 
  </code></pre>
  
  <p>But it doesn't work.</p>
  
  <p>How can I do?</p>
  
  <p>thanks</p>