动态方式将行转换为列(SQL Server 2005) [英] Dynamic way convert row into column(SQL server 2005)

问题描述

亲爱的，
我有一个表名Item(Item_id，Item_name)表数据，例如

Dear,
I have a table name Item(Item_id,Item_name) table data like

1   BasicSalary 
2   Medical 
3   Loandry 
4   Transport   
5   Rent    
6   GrossSalary 
7   OverTime 

可以更多..

现在的要点是，我需要一个可以按照以下方式进行安排的查询.

it can be more..

now the main point i need a query that can arrange it following way.

BasicSalary,Medical,Loandry,Transport, Rent,GrossSalary, OverTime 

因为我需要用它来创建新表.这一件事可能会更多.

任何帮助将不胜感激.
Mahmud

because I need this for creating a new table.One thing this item can be more.

Any help will be appreciated gratefully.
Mahmud

推荐答案

DECLARE @ConcatenatedValues NVARCHAR (MAX)
SELECT @ConcatenatedValues = COALESCE(@ConcatenatedValues + ',', '') + ColumnFromTable
FROM Table

SELECT @ConcatenatedValues

这篇关于动态方式将行转换为列(SQL Server 2005)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！