I have a table having this structure:
idrecord
nation
value
What I have to get by a query is grouping records by nation, summing and
counting the values, dividing negative by positive.
Therefore:
USA, sumOfPositiveValues, CountOfPositiveValues, sumOfNegativeValues,
CountOfNegativeValues
ITALY, sumOfPositiveValues, CountOfPositiveValues, sumOfNegativeValues,
CountOfNegativeValues
FRANCE, sumOfPositiveValues, CountOfPositiveValues, sumOfNegativeValues,
CountOfNegativeValues
I hope I was clear enough :-)
Thanks.

Luciano

Op 28-10-2010 21:28, Luciano (DOC) schreef:
Hi Luciano,

You can use something like this:

SELECT Nation,
SUM(CASE WHEN Value >= 0 THEN Value END),
COUNT(CASE WHEN Value >= 0 THEN Value END),
SUM(CASE WHEN Value < 0 THEN Value END),
COUNT(CASE WHEN Value < 0 THEN Value END)0
FROM YourTable
GROUP BY Nation;

(untested - for a tested reply, please see www.aspfaq.com/5006)


--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

"Hugo Kornelis" <hugo (AT) perFact (DOT) REMOVETHIS.info.INVALID> ha scritto nel
messaggio news:8iu3fcFfn1U1 (AT) mid (DOT) individual.net...

Great, thank you very much!

Luciano