Microsoft SQL Server
How to fill in gaps in time series
In some cases it is necessary to have an unbroken time series, for instance to have all days during a year. But what if some days are missing from the data? How can we fill in gaps in time series?