关于行转列

select [Si],[Fe],[Cu],[Mn],[Mg],[Cr],[Zn],[Ti],[Na],[Ca] from ( select tagValue,tagname from OrbitMes_EquipmentEvent_H21001
where MarkDateTime='2018-11-25 16:56:03.523' and TagName in ('si','Fe','cu','mn','mg','cr','zn','ti','na','ca') )s

PIVOT(max(tagValue) FOR [tagname] IN( [Si],[Fe],[Cu],[Mn],[Mg],[Cr],[Zn],[Ti],[Na],[Ca])) AS T