--получаю список необходимых дат
WITH a(a) AS (   VALUES  ( date('2013-12-12') - 180 days )
            UNION ALL                
            SELECT  a + 1 DAY
            FROM    a
            WHERE   a < date('2013-12-12')
),

-- получаю границы диапазонов дат (если даты окончанию в таблице нет беру указанное значение) 
c as  (     select STARTDATE,
                           case when ENDATE is null 
                           then Date('2013-12-12')
                           else ENDATE
                           end as ENDATE
            from    TABLE
),

select  a as myDAY,
          case when exists (
              select  1
              from     c
              where   a BETWEEN c.STARTDATE AND c.ENDATE  
         ) then 1 else 0 end as FLAG
FROM    a 

WITH 
--список дней
a(a) AS (   VALUES  ( date('2013-12-12') - 180 days )
            UNION ALL                
            SELECT  a + 1 DAY
            FROM    a
            WHERE   a < date('2013-12-12')
),
--границы действующих просрочек 
c as  (     select   T.STARDATE,
                         CASE WHEN T.ENDDATE IS NULL 
                                 THEN date('2013-12-12')
                                 else ENDDATE
                         end as FACTDATE
from    TABLE
)
--дни с просрочками
select  a as myDAY,
        case when exists (
            select  1
            from    c  
            where   a <= c.STARDATE and a >= c.ENDDATE
        ) then 1 else 0 end as FLAG
FROM  a