Home Forums SQL Server 2005 T-SQL (SS2K5) How to insert missing periods ? RE: How to insert missing periods ?
Steve Jones - SSC Editor
SSC Guru
Points: 734542
More actions
August 6, 2008 at 12:01 pm
#854042
You could left join with a table of all periods, including 0s for NULLs (CASE or ISNULL).
Or you could "populate" 0 orders with the missing periods.