Generating a date series

Question

Accepted Answer

The anchor produces Jan 1. The recursive member adds one day each iteration while d < Jan 5. So iterations produce Jan 2, Jan 3, Jan 4, Jan 5. When d = Jan 5, the condition d < Jan 5 is false and recursion stops. The result set contains Jan 1 through Jan 5: five rows total. Generating date series this way is useful when you need a row for every date in a range, even dates with no activity in your data.