Membuat Temporary Query untuk di Manupulasi datanya :
CREATE TABLE Prod
(IDP INT,DataDate DATETIME,QtyIN INT, QtyOut INT)
INSERT Prod
VALUES( 2,'2014-11-17',404,0),
(2,'2014-11-18',373,0),
(2,'2014-11-19',1350,0),
(66,'2014-11-17',3624,0),
(66,'2014-11-18',3576,0),
(66,'2014-11-19',0,57),
(67,'2014-11-17',9353,0),
(67,'2014-11-18',0,92),
(67,'2014-11-19',0,90)
=====================================================================
WITH t AS
(
SELECT IDP, SUM(QtyIn) AS 'IN', SUM(QtyOut) as 'OUT'
FROM Prod Where DataDate<'2014-11-18'
GROUP BY IDP
UNION
SELECT IDP, SUM(QtyIn) AS 'IN', SUM(QtyOut) as 'OUT'
FROM Prod Where DataDate>'2014-11-18' and DataDate<='2014-11-19'
GROUP BY IDP
)
Select IDP,SUM([IN]),SUM([OUT]) From t Group By IDP;
=====================================================================
EmoticonEmoticon