问题描述
我有一群人.让我们称他们为A,B,C.我有一张表格显示他们每个月的工资......
I have a group of people. Lets call them A,B,C. I have a table that shows how much they were paid each month....
这张桌子可以而且确实会持续很多年..
THIS table can and does go on for years and years..
有没有办法对这个表进行透视(我认为没有什么需要聚合的,通常在透视中完成)在一个如下所示的表中?
Is there a way to pivot this table (nothing as I see really needs to be aggregated which is usually done in pivots) In a table that looks like the following?
以前没有遇到过这样的事情,但认为这是一个常见问题有什么想法吗?
Haven't run into something like this before but assume it is a common problem any ideas?
推荐答案
如果您使用的是 SQL Server 2005(或更高版本),这里是代码:
If you are using SQL Server 2005 (or above), here is the code:
无论您拥有多少不同的状态,这都将起作用.它使用 PIVOT
动态组合查询.对动态列执行 PIVOT 的唯一方法是动态组装查询,这可以在 SQL Server 中完成.
This will work no matter how many different status you have. It dynamically assembles a query with PIVOT
. The only way you can do PIVOT with dynamic columns is by assembling the the query dynamically, which can be done in SQL Server.
其他示例:
- 也许是 SQL Server PIVOT?
- 如何通过将 SQL Server 连接到单个表来构建摘要?
这篇关于在 T-SQL 中透视数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!