title: t-sql get all dates between 2 dates
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/271595/getting-dates-between-a-range-of-dates">Getting Dates between a range of dates</a>  </p>
  </blockquote>
  
  
  
  <p>Let's say I have 2 dates (date part only, no time) and I want to get all dates between these 2 dates inclusive and insert them in a table. Is there an easy way to do it with a SQL statement (i.e without looping)?</p>
  
  <pre><code>Ex:
  Date1: 2010-12-01
  Date2: 2010-12-04
  
  Table should have following dates:
  2010-12-01, 2010-12-02, 2010-12-03, 2010-12-04
  </code></pre>