7/26/2019 Interogari de Populare Sub 1

1/1

Actualizare(Populare dimensiune Timp)

INSERT INTO Timp ( DataDoc, Luna, [Trim, An ) IN !"#$%a&i$depozit'md&!SELE"T DISTIN"T DataDoc, ont(DataDoc) AS Luna, DatePart(*+*,DataDoc) AS

[Trim, ear(DataDoc) AS An

-RO DocIncasare IN !"#$%a&i$sursa'md&!.

e/tra%e0incasari

SELE"T Re1-act'NrDoc, DataDoc, DocIncasare'"od"l, Scadenta, 2aloare,

II-(DataDoc3Scadenta,(DataDoc4Scadenta),5) AS 6ileIntarziere,

2aloare7(895'876ileIntarziere) AS Suma, 2aloare75'876ileIntarziere AS Penalitati

-RO DocIncasare, Re1-act, "lienti, -actura IN !"#$%a&i$sursa'md&!:;ERE DocIncasare'NrDocP ? Re1-act'NrDoc, DataDoc, DocIncasare'"od"l.

actualizare0incasari

INSERT INTO incasari ( "od"l, NrDoc, DataDoc, TotalIncasari, TotalPenalizari,Total6ileIntarziere, TotalDocumente ) IN !"#$%a&i$depozit'md&!SELE"T "od"l, NrDoc, DataDoc, TotalIncasari, TotalPenalizari, Total6ileIntarziere,

TotalDocumente

-RO trans1orm0incasari.