本文介绍了单行到多行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有Table Servive,我只是想要将列标题作为描述和值作为下一栏
[IncomeHeadID] [InventoryControlHeadID],[CostOfGoodLabHeadID],[CostOfGoodHeadID] [CashHeadID] 12 11 22 44 44i想要这样
描述值 [IncomeHeadID] 12 [InventoryControlHeadID] 11 [CostOfGoodLabHeadID] 22 [CostOfGoodHeadID] 44 [CashHeadID] 44感谢提前...
解决方案如果您知道标题名称或想要更改它们,请执行以下操作: 选择收入头ID作为incomeHeadIdDescripton ,IncomeHeadId, 库存控制头ID作为IncomeControlHeadIdDescription,IncomeControlHe adId 来自表1; 不确定是否可以从查询动态加载列名,但如果使用数据库组件则可以...
查看过去的答案:如何将列名称作为具有值的行 [ ^ ]
我不确定此链接是否会为您提供准确的解决方案,但这可以帮助你解决这个问题。 这是链接, msdn.microsoft/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 44i want like this
Description Value [IncomeHeadID] 12 [InventoryControlHeadID] 11 [CostOfGoodLabHeadID] 22 [CostOfGoodHeadID] 44 [CashHeadID] 44thanks 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, msdn.microsoft/en-us/library/ms177410(v=sql.105).aspx[^]更多推荐
单行到多行
发布评论