|
как это делает сиквел...
чем не запрос "в наличии" с аналитикой Склад?
SELECT
A.ITEMID,
Name = (SELECT C.ItemName from dbo.InventTable C WHERE A.ITEMID=C.ITEMID),
B.INVENTLOCATIONID,
SUM(A.POSTEDQTY),
SUM(A.POSTEDVALUE),
SUM(A.PHYSICALVALUE),
SUM(A.DEDUCTED),
SUM(A.REGISTERED),
SUM(A.RECEIVED),
SUM(A.PICKED),
SUM(A.RESERVPHYSICAL),
SUM(A.RESERVORDERED),
SUM(A.ONORDER),
SUM(A.ORDERED),
SUM(A.ARRIVED),
SUM(A.QUOTATIONRECEIPT),
SUM(A.QUOTATIONISSUE),
SUM(A.PHYSICALINVENT),
SUM(A.POSTEDVALUESECCUR_RU),
SUM(A.PHYSICALVALUESECCUR_RU),
SUM(A.AVAILPHYSICAL),
SUM(A.AVAILORDERED)
FROM dbo.INVENTSUM A
INNER JOIN dbo.INVENTDIM B ON A.INVENTDIMID=B.INVENTDIMID
GROUP BY A.ITEMID,B.INVENTLOCATIONID
ORDER BY NAME
|