Hi all,
I want to display multiple aggregation in sql server
following code is working one
SELECT PRODUCT , FRED, KATE
FROM (
SELECT CUST, PRODUCT, QTY
FROM Product) up
PIVOT (max(QTY) FOR CUST IN (FRED, KATE) ) as p
ORDER BY PRODUCT.
my requirement is to display max(qty) and sum (qty)
like this
SELECT PRODUCT [prod / max sum], FRED, KATE
FROM (
SELECT CUST, PRODUCT, QTY
FROM Product) up
PIVOT (max(QTY) FOR CUST IN (FRED, KATE)+'-'+sum(QTY) FOR CUST IN (FRED, KATE) ) as p
ORDER BY PRODUCT
this is not working.
how to solve this
Regards
Baiju