title: Easiest way to populate a temp table with dates between and including 2 date parameters
body: <p>What is the easiest way to populate a temp table with dates including and between 2 date parameters. I only need the 1st day of the month dates.</p>
  
  <p>So for example if @StartDate = '2011-01-01' and @EndDate = '2011-08-01'</p>
  
  <p>Then I want this returned in the table</p>
  
  <pre><code>2011-01-01
  2011-02-01
  2011-03-01
  2011-04-01
  2011-05-01
  2011-06-01
  2011-07-01
  2011-08-01
  </code></pre>