Copy-paste detected
Цитата:
Сообщение от
mazzy
вот какие запросы были:
Код:
-- наивный: 4% по плану запроса, выполнено за 1:17, выбрано 342294 записи
with trans as (
SELECT
isnull(accTable.SUMACCOUNT, isnull(accGroup.SumAccount, accAll.SumAccount)) as pSumAccount,
tr.*
from custtrans as tr
join custtable as tab on (tab.accountnum = tr.accountnum)
left join CUSTLEDGERACCOUNTS as accTable
on (accTable.DATAAREAID = 'eras'
and accTable.POSTINGPROFILE = tr.POSTINGPROFILE
and accTable.AccountCode = 0 and accTable.NUM = tab.ACCOUNTNUM)
left join CUSTLEDGERACCOUNTS as accGroup
on (accTable.DATAAREAID = 'eras'
and accGroup.POSTINGPROFILE = tr.POSTINGPROFILE
and accGroup.AccountCode = 1 and accGroup.NUM = tab.CUSTGROUP) Во втором left join должно быть
Код:
on (accGroup.DATAAREAID = 'eras'
вместо
Код:
on (accTable.DATAAREAID = 'eras'