Thread: Running Total
View Single Post
  #2 (permalink)  
Old 12-30-08, 15:14
dportas dportas is offline
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 732
Please always say what version you are using. In 2005 use CUBE/ROLLUP. In 2008 use GROUPING SETS.

SELECT JobNo, PartNo, SUM(Quantity) Quantity
FROM Stock
GROUP BY PartNo,JobNo WITH ROLLUP;

SELECT JobNo, PartNo, SUM(Quantity) Quantity
FROM Stock
GROUP BY GROUPING SETS ((JobNo,PartNo),(PartNo),());
Reply With Quote