Tools › Calendar / tally CTE
Date range filler (recursive CTE)
Reports need every day, including days with no orders. A tally / calendar CTE fills the gaps.
Recursive CTEs have a default 100-step cap. We set MAXRECURSION for a year of days. Do not point this at a million years.
Learn it on a real ticket
Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.
Clock in free