Community

Fill In Missing Dates for SQL Server Query Output

(Jim Evans) When analyzing and reporting data occurrences over time with a roll up by a date part like week, day, hour, etc. often you will have gaps in your date values that will need to be accounted for.