Zkrácená mzdová statistika s účty MD - DAL

Zkrácená mzdová statistika s účty MD - DAL je sestava pro Generátor sestav II.

SQL definice

select distinct P.kod, C.vyznam,
(select count(*) from pichacky P2 where P2.kod = P.kod and P2.datum >= %DATUMOD% and P2.datum <= %DATUMDO%) as pocet,
(select sum(dny) from pichacky P2 where P2.kod = P.kod and P2.datum >= %DATUMOD% and P2.datum <= %DATUMDO%) as dny,
(select sum(hodiny) from pichacky P2 where P2.kod = P.kod and P2.datum >= %DATUMOD% and P2.datum <= %DATUMDO%) as hodiny,
(select ceiling(sum(castka)) from pichacky P2 where P2.kod = P.kod and P2.datum >= %DATUMOD% and P2.datum <= %DATUMDO%) as castka,
C.kod_uc,
(select ucet_md from kody_uc KUC where C.kod_uc = KUC.kod_uc) as ucet_MD,
(select ucet_dal from kody_uc KUC where C.kod_uc = KUC.kod_uc) as ucet_DAL,
(select nazev from kody_uc KUC where C.kod_uc = KUC.kod_uc) as nazev

from pichacky P, ciselnik C
where P.kod = C.kod and P.datum >= %DATUMOD% and P.datum <= %DATUMDO%
order by P.kod

Odkazy

• hd 61840
• Generátor sestav II
• Generátor sestav II (příklady sestav)