Re: Summarising data

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 20:45:56 +0200

And, as an alternative to the query Rohtash provided:

SELECT Stock_Code, Location, sum(Quantity)
FROM #MyTable
GROUP BY Stock_Code, Location WITH ROLLUP

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)