Recursive CTEs

A recursive CTE has an anchor query, then a query that refers back to the CTE itself, run repeatedly until it returns nothing. The simplest use is generating a series of numbers.

The most useful version is a date spine: a complete calendar you LEFT JOIN your data onto, so days with no activity still appear as zeros instead of vanishing.

Always give the recursion a stopping condition. Without one it runs until the engine kills it.