⚜
Select
fb.OfficeID,
fb.SenderCustomerID,
Sum(fb.TransferSumm) 'FB'
from #FactBP fb
group by fb.OfficeID, fb.SenderCustomerID
Size: a a a
2021 September 21
DE
SELECT id, FB, factIntiqol
FROM (
Select
o.id,
Sum(fb.TransferSumm) 'FB'
from dbo.Offices o
Left join #FactBP fb
on fb.OfficeID = o.ID
group by o.ID
) FBSUM
JOIN (
Select
o.id,
Sum(i.CreditSumV) 'factIntiqol'
from dbo.Offices o
LEFT join #factIntiqol i on o.ID = i.OfficeID
group by o.ID
) ISUM
ON FBSUM.id = ISUM.id
DE
Я имел ввиду такую структуру
DE
SELECT id, FB, factIntiqol, (FB + factIntiqol) AS total⚜
select
o.Name as Officename,
isnull(max(OP.otp_bp_plan) + max(OP.vbp_plan),0) as PlanBP,
isnull(max(OP.otp_intiqol_plan) + max(OP.vintiqol_plan),0) as PlanIntiqol,
isnull(max(OP.otp_total_plan) + MAX(OP.vtotal_plan),0) as TotalPlan,
from #MonTransfers p
inner join dbo.Offices o on o.ID = p.OfficeID
inner join arvand.Branches b on o.BranchID = b.ID
Inner join arvand.mtt_plan OP on (OP.OfficeID = p.OfficeID and OP.PlanDate = @maxPlanDate)
Group by o.Name
Могу ли я эти поля тоже там добавить ?
o.Name as Officename,
isnull(max(OP.otp_bp_plan) + max(OP.vbp_plan),0) as PlanBP,
isnull(max(OP.otp_intiqol_plan) + max(OP.vintiqol_plan),0) as PlanIntiqol,
isnull(max(OP.otp_total_plan) + MAX(OP.vtotal_plan),0) as TotalPlan,
from #MonTransfers p
inner join dbo.Offices o on o.ID = p.OfficeID
inner join arvand.Branches b on o.BranchID = b.ID
Inner join arvand.mtt_plan OP on (OP.OfficeID = p.OfficeID and OP.PlanDate = @maxPlanDate)
Group by o.Name
Могу ли я эти поля тоже там добавить ?
DE
Какие?
⚜
from arvand.mtt_plan OP on (OP.OfficeID = p.OfficeID and OP.PlanDate = @maxPlanDate)
Group by o.Name
Group by o.Name
DE
Не используй фильтр в джойне
DE
Выноси его в WHERE
DE
Ну по одной агрегации на подзапрос, но чтобы приджойнить тебе нужно id
DE
А почему ты по имени группируешь, а не по id?
DE
А имена уникальны?
DE
По id будет быстрее