Sqlserver 行转列

分类: 文章 • 2023-03-25 16:46:36

sel Sqlserver 行转列 ect * from #RESULT2 pivot(sum(value) for company in (
[312AE],
[306AE-Consolidation Total],
[306AE],
[320AE],
[320AC],
[312AC],
[306AE-Consolidation Differ],
[306AC]
))a