Цитата:
Сообщение от
Recoilme
Теперь всё правильно???
НЕА
ТЫТЫСЫБЕГИН
SELECT ФОРАПДЭЙТ TOP 100
dbo.INVENTSUM.DATAAREAID, dbo.INVENTSUM.ITEMID AS ITEMID, MAX(dbo.INVENTSUM.POSTEDQTY) -
ISNULL(SUM(dbo.INVENTTRANS.QTY),0) /*Спасибо Владимиру Максимову*/ AS QTY,
dbo.INVENTSUM.INVENTDIMID
FROM dbo.INVENTSUM LEFT OUTER JOIN
dbo.INVENTTRANS ON dbo.INVENTSUM.INVENTDIMID = dbo.INVENTTRANS.INVENTDIMID AND
dbo.INVENTSUM.ITEMID = dbo.INVENTTRANS.ITEMID
AND
dbo.INVENTSUM.DATAAREAID = dbo.INVENTTRANS.DATAAREAID
WHERE
dbo.INVENTSUM.DATAAREAID = 'ABC' AND ((dbo.INVENTTRANS.RECID IS NULL) OR ((dbo.INVENTTRANS.DATEPHYSICAL >= CONVERT(DATETIME, '2006-01-01 00:00:00', 102)) AND ((dbo.INVENTTRANS.STATUSRECEIPT = 1) OR
(dbo.INVENTTRANS.STATUSISSUE = 1) OR
(dbo.INVENTTRANS.STATUSRECEIPT = 2) OR
(dbo.INVENTTRANS.STATUSISSUE = 2) OR
(dbo.INVENTTRANS.STATUSRECEIPT = 3) OR
(dbo.INVENTTRANS.STATUSISSUE = 3)) )
GROUP BY
dbo.INVENTSUM.DATAAREAID, dbo.INVENTSUM.ITEMID, dbo.INVENTSUM.INVENTDIMID
ТЫТЫСЫКОММИТ