SQL - Pivot on Multiple Columns

tq so much

it very helpfull

Thank you sir

Thanks a lot, it solved my issue.

Thank you so much, this was so helpful! :)

Nice

Silent Movie?!!!!

using union query and one column
select [Year] ,CameraQt,CameraValue,ComputerQt,ComputerValue from
(
Select [year],product +'Qt' as Product,Qt as Value from PivotTable
union
Select [year],product +'Value' as Product,AMT as Value from PivotTable) as Sub3
Pivot
(
Sum(Value)
for Product
in (CameraQt,CameraValue,ComputerQt,ComputerValue)

) as PV

Thanks for bringing an insight on one of the less known feature, pivoting in SQL server