äÏÂÒÏÇÏ ×ÓÅÍ ÄÎÑ!!!
FB 1.5
IBExpert
óÏÂÓÔ×ÅÎÎÏ ÓÔÏÌËÎÕÌÓÑ Ó ÔÁËÏÊ ÐÒÏÂÌÅÍÏÊ, ÏÄÉÎ É ÔÏÔ-ÖÅ ÚÁÐÒÏÓ
× ÈÒÁÎÉÍÏÊ ÐÒÏÃÅÄÕÒÅ É × SQL òÅÄÁËÔÏÒÅ
×ÏÚ×ÒÁÝÁÅÔ ÒÁÚÎÙÅ ÐÌÁÎÙ
.....
select v.Type_owner, sum(c.Money_doc)
from Z_spr_link l,Z_calculation c,Z_spr v
where c.For_period=:For_procdate
and c.Worker_code=:Worker_code
and c.Vo_code=l.Object
and l.Owner=:Gvo
and l.Begin_date <= :For_procdate
and l.End_date >= :For_procdate
and v.Code=c.vo_code
group by v.Type_owner
.....
÷ ÐÒÏÃÅÄÕÒÅ ×ÙÄÁÅÔÓÑ ÐÌÁÎ
SORT (JOIN (C INDEX (FK_Z_CALCULATION_WORKER),V INDEX (PK_Z_SPR),L INDEX
(UNQ_Z_SPR_LINK,FK_Z_SPR_LINK_OWNER,FK_Z_SPR_LINK_OBJECT,FK_Z_SPR_LINK_END_DATE)))
÷ ÒÅÄÁËÔÏÒÅ
SORT (JOIN (C INDEX (Z_CALCULATION_IDX4),V INDEX (PK_Z_SPR),L INDEX
(UNQ_Z_SPR_LINK)))
îÕ Á ×ÏÐÒÏÓÁ Ä×Á.
ðÅÒ×ÙÊ - ÐÏÞÅÍÕ ÔÁË ÐÒÏÉÓÈÏÄÉÔ
÷ÔÏÒÏÊ - ËÁË ÓÄÅÌÁÔØ ÞÔÏÂÙ × ÐÒÏÃÅÄÕÒÅ ÂÙÌ ÐÌÁÎ ÔÁËÏÊ-ÖÅ ËÁË É ×
ÒÅÄÁËÔÏÒÅ
ÎÅ ÐÒÉÛÉ×ÁÑ ÐÌÁÎ ÒÕËÁÍÉ Ë ÚÁÐÒÏÓÕ
íÁËÍÁË
