单行到多行 [英] 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屋!
查看全文