What is pivot Operator ?? Why use Pivot Operator

Pivot is very usefull and important  Operator in SQL Because if we want to convert Rows in Columns  then we use Pivot Operator  and One Column Define Differnt Result set 

For Example

We have table Of Daily Income 

We want To change Months Columns in Row In this Situation we Use Pivot operator

Select * From

(

Select   Vendor, IncomeDay, Income Amount

from  Daily Income 

)

Src

Pivot

(

Sum( Income Amount) For IncomeDay In

([January],[Feb],[March]) 

) As PivotTable

It Give us Result like This