Опять оптимизация запроса
while select AccountNum, Voucher, AmountCur
from
rAssetTrans //Ищем все ОС, которые введены в эксплуатацию
where rAssetTrans.AssetTransType == RAssetTransType::Acquisition
&& rAssetTrans.TransDate <= transDate
join
rAssetStandards
where rAssetStandards.AssetId == rAssetTrans.AccountNum
&& rAssetStandards.AssetGroup != 'СО'
&& rAssetStandards.AssetGroup != '01'
&& rAssetStandards.PostingProfile != 'НМА'
{
ledgerAccount = (
select firstonly firstfast AssetDebAccountNum_ru
from
LedgerJournalTrans
where LedgerJournalTrans.Voucher == _voucher
&& (LedgerJournalTrans.AssetDebAccountNum_ru != 'XX-00-00-з001'
|| LedgerJournalTrans.AssetDebAccountNum_ru != '')
).AssetDebAccountNum_ru;
....................
}
|