求大神看一下sql server2012一个查询

EXCEL 数据透视呀

select distinct [A],[B],t2.s1,[1] t1,t2.s2,[2] t2,t2.s3,[3] t3 from
(select [A]
,[B]
,[S]
,[V]
FROM [HardWareInfo].[dbo].[t])
P pivot (Max([V]) for [S] in ([1],[2],[3])) as pvt
CROSS APPLY(
select [1] s1,[2] s2,[3] s3 from
(select [A]
,[B]
,[S]
,[s] ss
FROM [HardWareInfo].[dbo].[t])
P pivot (Max([ss]) for [S] in ([1],[2],[3])) as pvt) t2

百度，数据库列转行。