single Row to multiple Rows

Question

1.00/5 (2 votes)

See more:

, +

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...

Posted 17-Sep-13 2:01am

Member 10172439

Updated 17-Sep-13 2:05am

Maciej Los

v2

Add a Solution

Comments

abbaspirmoradi 17-Sep-13 8:07am

same question: How to get Column names as rows with values[^]

Maciej Los 17-Sep-13 8:09am

Based on what codition?

5 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zerotimedev · Answer 1 · 2013-09-17T02:09:00

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...

Maciej Los · Answer 2 · 2013-09-17T02:11:00

Solution 2

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

Posted 17-Sep-13 2:11am

Maciej Los

v2

Thomas ktg · Answer 3 · 2013-09-17T02:18:00

Solution 3

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[^]

Posted 17-Sep-13 2:18am

Thomas ktg

Saral S Stalin · Answer 4 · 2013-09-17T02:19:00

Try below script. This requires that you know column names in advance, and I think that is the case here

SQL

DECLARE @Table TABLE ([IncomeHeadID] INT, [InventoryControlHeadID] INT,[CostOfGoodLabHeadID] INT ,[CostOfGoodHeadID] INT, [CashHeadID] INT)
INSERT @Table VALUES (12,11,22,44,44)

SELECT Description, Value
FROM
(SELECT *
FROM @Table) pvt
UNPIVOT ( Description FOR Value IN (
[IncomeHeadID] , [InventoryControlHeadID] ,[CostOfGoodLabHeadID]  ,[CostOfGoodHeadID] , [CashHeadID] ) ) unpvt

rachitagarwal2828 · Answer 5 · 2013-09-17T05:21:00

Solution 5

You can use pivot table for this

Posted 17-Sep-13 5:21am

rachitagarwal2828

single Row to multiple Rows

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

single Row to multiple Rows

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us