[步骤]
SELECT pdbd.SupplierID,CONVERT(BIGINT, Sum(wppl.PutInNum)) AS PutTotalNum,
Sum(wppl.PutInNum * ( Isnull(pdbd.ActualProductPrice, 0) + Isnull(pdbd.UnitShipFee, 0) - Isnull(pdbd.UnitMinus, 0) )) AS PutTotalAmount
FROM dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) wppl
LEFT JOIN dbo.RB_Procurement_Detail_BuyList_Detail (NOLOCK) pdbd
ON pdbd.CustomerID = wppl.CustomerID
AND pdbd.DetailID = wppl.DetailID
AND pdbd.SKU = wppl.SKU
AND pdbd.ListNo = wppl.ListNo
LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb
ON pdb.ListNo = pdbd.ListNo
AND pdb.P_Code = pdbd.P_Code
AND pdb.CustomerID = pdb.CustomerID
WHERE wppl.CustomerID = @customerId
AND wppl.ListNo IS NOT NULL
AND pdb.ProcPayType IS NOT NULL
AND wppl.ListNo <> ''
AND wppl.PutInNum > 0
GROUP BY pdbd.SupplierID;
[结果]
[期望]
1.改善SQL 提醒性能，增加一些必要的逻辑。2。是否可以考虑读库查询
