|
gangadhara.ms
Constraint Violating Yak Guru
India
497 Posts |
 Posted - 11/06/2012 : 03:51:51
|
Hi All,
I have a table which i need to find out the Opening balance and closing balance for the sales team for the last 1 week.
-- Get what Rep has been SHIPPED
SELECT mo.Material_ID, ss.BatchNumber,SUM(ss.Quantity) as [Shipped], ExpiryDate
FROM Material_Order_Sample_Shipment ss
JOIN Material_Order mo ON mo.ID = ss.Material_Order_ID
WHERE mo.Rep_ID = @Rep_ID AND ss.Material_Order_ID IN (SELECT ID FROM Material_Order WHERE Status_ID = 2 AND
datereceived >=dateadd(dd,-7,getdate()))
GROUP BY ss.BatchNumber, mo.Material_ID, ExpiryDate
ORDER BY mo.Material_ID
Please help me to get the query to get the transaction for 1 week.
Or any suggestion welcome.
Regards,
Gangadhara
Thanks,
Gangadhara MS
SQL Developer and DBA |
|
Opening balence and closign balence
