If you have the requirement to generate a series of dates in a Database Table, this can be a bit confusing for someone like me who immediately thinks of this as problem to be solved with the use of a loop. It turns out that using a recursive Common Table Expression, you can easily accomplish…