如何将Row转换为Column [英] How to convert Row into Column

问题描述

问候，



我有一个2行的桌子，让我们说

Greetings,

I have a table with 2 rows, lets say

PARAMETER_NAME[Column Header]     | PARAMETER_VALUE[Column Header]
Row1-FOLDER PATH       |	C:\RIMS\BATCH\DUMMY
Row2-FILE NAME         |	DUMMY_RRFANS_80_A.TXT

我想要的结果如

I want the result like

FOLDER PATH[Column Header] | FILE NAME[Column Header]   
Row-C:\RIMS\BATCH\DUMMY    | DUMMY_RRFANS_80_A.TXT

基本上我希望将结果行转换为列，

Basically I want the resulted rows converted into Columns,

推荐答案

你可以这样做 PIVOT 。



在SQL查询中使用数据透视的简单方法 [ ^ ]

http://technet.microsoft.com/en-us/library/ms177410（ⅴ = sql.105）.aspx [ ^ ]

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/ [ ^ ]

http://blogs.msdn.com/b /spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx [ ^ ]



-KR

You can do this using PIVOT.

Simple Way To Use Pivot In SQL Query[^]
http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]
http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx[^]

-KR

这篇关于如何将Row转换为Column的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！