CareerCup

Adding example for the above which I missed

create table DailyIncome(VendorName nvarchar(10), IncomeDay nvarchar(10), IncomeAmount int)
--drop table DailyIncome

Just a sample Insert

insert into DailyIncome values ('SPIKE', 'FRI', 100)
insert into DailyIncome values ('SPIKE', 'MON', 300)
insert into DailyIncome values ('FREDS', 'SUN', 400)
insert into DailyIncome values ('SPIKE', 'WED', 500)
insert into DailyIncome values ('SPIKE', 'TUE', 200)
insert into DailyIncome values ('JOHNS', 'WED', 900)
insert into DailyIncome values ('SPIKE', 'FRI', 100)
insert into DailyIncome values ('JOHNS', 'MON', 300)


Getting the Pivot Data
eg :
select * from DailyIncome
pivot (avg (IncomeAmount) for IncomeDay in ([MON],[TUE],[WED],[THU],[FRI],[SAT],[SUN])) as AvgIncomePerDay


Any aggregate functions could be used like Sum, Max


Outcome:
There are still more Inserts which are not included in the above statement, this is just a sample output.


VendorId MON TUE WED THU FRI SAT SUN
---------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
FREDS 500 350 500 800 900 500 400
JOHNS 300 600 900 800 300 800 600
SPIKE 600 150 500 300 200 100 400

A pivot table is a frequently used method of summarizing and displaying especially report data by means of grouping and aggregating values.
The results will transform Rows into Columns (i.e Rotate)

USE CASE statement