Home Forums SQL Server 2005 T-SQL (SS2K5) How to insert missing periods ? RE: How to insert missing periods ?

  • 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.