SQL Server 2008中的数据转置,您如何实现它 [英] Data transposition in SQL server 2008 , how do you accomplish it
问题描述
需要转换数据来自::
分组SumOfGroup
-------------- -----------------
1-3 3825076.35
4-6 8572872.62
7 -12 7439385.91
休息6733030.95
to ::
1 -3 4-6 7-12休息
-------------------------------- ---------------
3825076.35 8572872.62 7439385.91 6733030.95
你如何实现这个目标/>
我尝试过:
参考早期代码和互联网
你想做一个PIVOT。请参阅我关于转动的技巧 HERE [ ^ ]
need to transpose data from ::
Grouping SumOfGroup
-------------------------------
1-3 3825076.35
4-6 8572872.62
7-12 7439385.91
The Rest 6733030.95
to ::
1-3 4-6 7-12 The Rest
-----------------------------------------------
3825076.35 8572872.62 7439385.91 6733030.95
How do you achieve this
What I have tried:
Made reference to earlier codes and the internet
You want to make a PIVOT. See my artocle about pivotting HERE[^]
这篇关于SQL Server 2008中的数据转置,您如何实现它的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!