如何在SQL Server中将行显示为列 [英] how to display rows into column in sql server

问题描述

大家好，

我的记录如下:

Hi All,

I have record as follows:

Name Date        Status
AAA  01/02/2011   P
AAA  01/03/2011   P 
AAA  01/04/2011   A
BBB  01/02/2011   P
BBB  01/03/2011   P 
BBB  01/04/2011   A
CCC  01/02/2011   P
CCC  01/03/2011   P 
CCC  01/04/2011   A

我想要的结果是:

I want result as :

Name  01/02/2011 01/03/2011 01/04/2011 
AAA   P            P           A  
BBB   P            P           A  
CCC   P            P           A  

请帮帮我.

谢谢Mohd Wasif


[edit]已添加代码块-OriginalGriff [/edit]

Please help me.

Thanking you Mohd Wasif


[edit]Code block added - OriginalGriff[/edit]

推荐答案

请注意使用PIVOT表:MSDN [ ^ ]

Look at using a PIVOT table: MSDN[^]

SELECT Name,
CASE WHEN Date = '01/02/2011' THEN Status END AS [01/02/2011],
CASE WHEN Date = '01/03/2011' THEN Status END AS [01/03/2011],
CASE WHEN Date = '01/04/2011' THEN Status END AS [01/04/2011]
FROM TableName

这篇关于如何在SQL Server中将行显示为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！