Кол-во дней наличия товара : Супермаг Плюс (Супермаг 2000)

select dt,
               article,
               locid,
               sum(quant) over(partition by locid, article order by dt) ost
               from (select dt, article, sum(quantity) quant, locid
                  from (select d.createdat dt,
                               t.article,
                               t.quantity,
                               d.locationto locid
                          from smdocuments d, smspec t
                         where d.doctype in ('WI', 'IW', 'CR')
                           and d.docstate >= 2
                           and d.doctype = t.doctype
                           and d.id = t.docid
                           and d.createdat <= :DateEnd
                           and t.article in
                               (select article
                                  from smcardassort
                                 where idassort = :assort)
                        union all
                        select d1.createdat dt,
                               t1.article,
                               -t1.quantity quantity,
                               d1.locationfrom locid
                          from smdocuments d1, smspec t1
                         where d1.doctype in ('WO', 'IW', 'CS')
                           and d1.docstate >= 2
                           and d1.doctype = t1.doctype
                           and d1.id = t1.docid
                           and d1.createdat <= :DateEnd
                           and t1.article in
                               (select article
                                  from smcardassort
                                 where idassort = :assort)
                        union all
                        select a.dt dt, b.article, 0 quantity, c.id locid
                          from dates a, smcard b, smstorelocations c
                         where a.dt between '01.04.2004' and :dateend
                           and b.article in
                               (select article
                                  from smcardassort
                                 where idassort = :assort)
                           and c.id <> -1)
                 group by dt, article, locid)