Friday, August 12, 2011

Rows to Column Pivot query


create table ProductSales(Salesperson varchar(50),Product varchar(50),SalesAmount money)



insert into ProductSales(Salesperson,Product,SalesAmount)values
('JOHN','SOAP',200),('PETER','SOAP',500),('JAMES','DETERGENT',100),('ROGER','DETERGENT',200)


SELECT SalesPerson, [SOAP] , DETERGENT
FROM (SELECT SalesPerson, Product, SalesAmount FROM ProductSales ) ps
PIVOT
(
SUM (SalesAmount)
FOR Product IN
([SOAP], DETERGENT)) AS pvt

No comments:

Post a Comment