在 SQL Server 2008 中将一些行交换为列

Swap Some Rows into Columns in SQL Server 2008(在 SQL Server 2008 中将一些行交换为列)

问题描述

SQL Server 大师的另一个...

Another one for you SQL Server gurus...

我有一张这样的桌子...

I have a table like so...

AccountManager | Action                | Count
-----------------------------------------------------
Joe            | Client Negotiation    | 10
Bloggs         | Closing               | 1
Aunty          | Email                 | 12
Marie          | Preparing Contract    | 32

Action 列可能有许多不同类型的状态，这些状态不一定是固定的.

The Action column may have numerous different types of statuses which may not necessarily be fixed.

我需要输出如下:

AccountManager | Client Negotiation | Closing | Email | Preparing Contract
--------------------------------------------------------------------------
Joe            | 10                 | 0       | 0     | 0
Bloggs         | 0                  | 1       | 0     | 0
Aunty          | 0                  | 0       | 12    | 0
Marie          | 0                  | 0       | 0     | 32

这是怎么实现的?帮助！

How could this be achieved? Help!

推荐答案

按照以下演练

http://www.tsqltutorials.com/pivot.php

这篇关于在 SQL Server 2008 中将一些行交换为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！