title: Generate Dates between date ranges
body: <p>I need to populate a table that will store the date ranges between 2 given dates: 09/01/11 - 10/10/11</p>
  
  <p>So in this case the table would start from 09/01/11 and store each day till it got to 10/10/11
  I was wondering if there was a slick way of doing this in SQL Server - I am currently using SQL Server 2008. Thanks</p>