title: How to create a list of dates from a daterange without using a CTE
body: <p>The following link explains how to turn a date range into a list of dates.
  I used this approach and it works fine but the query is not performing (I used Maxrecursion 0 to unlimit).</p>
  
  <p><a href="http://blog.justinstolle.com/sql-turn-a-date-range-into-a-list-of-dates/" rel="nofollow">http://blog.justinstolle.com/sql-turn-a-date-range-into-a-list-of-dates/</a></p>
  
  <p>Is there any other solution to get this done? (using subquery or declare table?)</p>