Baq to return each date within a two date parameters

[Banderson (Brandon Anderson)]

There is a CTE that someone made, but the CTE fails after 100.

Maximum recursion 100 has been exhausted before statement completion

I’ve created a CTE to get all dates from the first day of the year to the last day of the year. When I limit the date range to less than 100 days (April 10) then it runs fine. When I set the limit to 365 days (December 31) it reports "maximum recursion 100 has been exhausted before statement completion" and stops running. I’ve read that I have to set "option (maxrecursion 0)" but I can’t find anywhere to set that option. I’ve tried reading through the application help and looking through the exe…