Brisanje sumarnih prometa i priprema za novu sync

--POREDJENJE
--------------------------------------------------------------------------------------------------
declare @datum datetime
set @datum = '2019-01-15'

select g.acDocType, sum(p.anQty * (p.anPrice - p.anPrice * p.anRebate / 100) * 1.17) as Iznos
from tHE_Move g
inner join tHE_MoveItem p on g.acKey = p.acKey
where g.acDocType in ('3Y30','32Y0', '3Y20') and g.adDate = @datum
group by g.acDocType

select g.blagajna, sum(p.kolicina * (p.mpc - p.mpc * p.rabat / 100)) as Iznos
from rGlava g
inner join rPozicije p on g.kljuc = p.kljuc
where g.blagajna in ('3Y30','32Y0', '3Y20') and g.datum = @datum
group by g.blagajna

select g.blagajna, sum(p.kolicina * (p.mpc - p.mpc * p.rabat / 100)) as Iznos
from rGlavaSUM g
inner join rPozicijeSUM p on g.kljuc = p.kljuc
where g.blagajna in ('3Y30','32Y0', '3Y20') and g.datum = @datum
group by g.blagajna

--BRISANJE ZBIRNIH DOK
--------------------------------------------------------------------------------------------------
delete tHE_Move where acDocType in ('3Y30','32Y0', '3Y20') and adDate >= '2019-01-15'

if object_id('tempdb..#k') is not null
drop table #k

select kljuc
into #k
from rGlavaSUM where blagajna in ('3Y30','32Y0', '3Y20') and datum >= '2019-01-15'

delete g
from rGlavaSUM g
inner join #k t on g.kljuc = t.kljuc

delete g
from rPozicijeSUM g
inner join #k t on g.kljuc = t.kljuc

delete g
from rGlavaBlgSUM g
inner join #k t on g.kljuc = t.kljuc

update rGlava
set Syn = 'N'
where blagajna in ('3Y30','32Y0', '3Y20') and datum >= '2019-01-15'