i want to know how can i use two pivot columns in a single query.

or

----

pivot <pivotcolumn1 > for < > in....

pivot <pivotcolumn2 > for < > in....

how to use two pivoted columns in a same query.