单行到多行 [英] single Row to multiple Rows

问题描述

我有Table Servive，我只是想要将列标题作为描述和值作为下一栏

 [IncomeHeadID] [InventoryControlHeadID]，[CostOfGoodLabHeadID]，[CostOfGoodHeadID] [CashHeadID] 
 12 11 22 44 44 

i想要这样

描述值
 [IncomeHeadID] 12 
 [InventoryControlHeadID] 11 
 [CostOfGoodLabHeadID] 22 
 [CostOfGoodHeadID] 44 
 [CashHeadID] 44 

感谢提前...

解决方案

如果您知道标题名称或想要更改它们，请执行以下操作：



选择收入头ID作为incomeHeadIdDescripton ，IncomeHeadId，

库存控制头ID作为IncomeControlHeadIdDescription，IncomeControlHe adId

来自表1;



不确定是否可以从查询动态加载列名，但如果使用数据库组件则可以...

查看过去的答案：如何将列名称作为具有值的行 [ ^ ]

我不确定此链接是否会为您提供准确的解决方案，但这可以帮助你解决这个问题。



这是链接，

http://msdn.microsoft.com/en-us/library/ms177410（v = SQL.105）的.aspx [ ^

hi ,
I have Table Servive,i just Wanto retreve Column headings As Description and Values As Next Column

[IncomeHeadID][InventoryControlHeadID],[CostOfGoodLabHeadID] ,[CostOfGoodHeadID] [CashHeadID]
    12             11                        22                       44            44

i want like this

Description                Value
[IncomeHeadID]              12
[InventoryControlHeadID]     11
[CostOfGoodLabHeadID]        22
[CostOfGoodHeadID]           44
[CashHeadID]                 44

thanks In advance...

解决方案

If you know the heading names or want to change them just do this:

Select "income head Id" as incomeHeadIdDescripton, IncomeHeadId,
"Inventory control head Id" as IncomeControlHeadIdDescription, IncomeControlHeadId
From table 1;

Not sure if you can load column names dynamically from a query, but could if you used a database component...

See past answer: How to get Column names as rows with values[^]

I am not pretty sure that this link would give you the exact solution, but this would help you to solve the requirement.

Here is the link,
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]

这篇关于单行到多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！