|
发表于 2012-10-11 13:52:51
|
显示全部楼层
SELECT C.cWhCode, C.cInvCode, C.cFree1, C.cFree2, C.cFree3, C.cFree4, C.cFree5,
C.cFree6, C.cFree7, C.cFree8, C.cFree9, C.cFree10, C.cBatch, C.bStopFlag,
C.BGSPSTOP, C.dLastCheckDate, C.cCheckState, C.dLastYearCheckDate,
C.cVMIVenCode, MAX(C.cMassUnit) AS cMassUnit, MAX(C.iMassDate) AS iMassDate,
MAX(C.dVDate) AS dVDate, MAX(C.dMdate) AS dMdate,
(CASE WHEN isnull(I.cSRPolicy, '') = 'LP' AND isnull(I.bspecialorder, 0)
= 1 THEN C.iSoType ELSE 0 END) AS iSoType, (CASE WHEN isnull(I.cSRPolicy, '')
= 'LP' AND isnull(I.bspecialorder, 0) = 1 THEN C.iSodid ELSE 0 END) AS iSodid,
SUM(C.iQuantity) AS iQuantity, SUM(C.iNum) AS iNum, SUM(C.fOutQuantity)
AS fOutQuantity, SUM(C.fOutNum) AS fOutNum, SUM(C.fInQuantity) AS fInQuantity,
SUM(C.fInNum) AS fInNum, SUM(C.fTransInQuantity) AS fTransInQuantity,
SUM(C.fTransInNum) AS fTransInNum, SUM(C.fTransOutQuantity)
AS fTransOutQuantity, SUM(C.fTransOutNum) AS fTransOutNum, SUM(C.fPlanQuantity)
AS fPlanQuantity, SUM(C.fPlanNum) AS fPlanNum, SUM(C.fDisableQuantity)
AS fDisableQuantity, SUM(C.fDisableNum) AS fDisableNum, SUM(C.fAvaQuantity)
AS fAvaQuantity, SUM(C.fAvaNum) AS fAvaNum, SUM(C.fStopQuantity)
AS fStopQuantity, SUM(C.fStopNum) AS fStopNum
FROM dbo.CurrentStock C INNER JOIN
dbo.Inventory I ON C.cInvCode = I.cInvCode LEFT OUTER JOIN
dbo.Warehouse W ON C.cWhCode = W.cWhCode
WHERE (ISNULL(W.bInAvailCalcu, 0) = 1)
GROUP BY C.cWhCode, C.cInvCode, C.cFree1, C.cFree2, C.cFree3, C.cFree4, C.cFree5,
C.cFree6, C.cFree7, C.cFree8, C.cFree9, C.cFree10, C.cBatch, C.bStopFlag,
C.BGSPSTOP, C.dLastCheckDate, C.cCheckState, C.dLastYearCheckDate,
C.cVMIVenCode, C.dVDate, (CASE WHEN isnull(I.cSRPolicy, '') = 'LP' AND
isnull(I.bspecialorder, 0) = 1 THEN C.iSoType ELSE 0 END),
(CASE WHEN isnull(I.cSRPolicy, '') = 'LP' AND isnull(I.bspecialorder, 0)
= 1 THEN C.iSodid ELSE 0 END)
是哪个条件限制了 |
|