Transform columns into rows

soriaedu79 · #1 (**permalink**) 04-29-10, 19:22

Hello,

I´m totally stuck with this problem. I have searched the solution in the forums but the things I saw didn`t work fine.

I have this table:

Code:

ID | Total_time | Partial_time
-----------------------------------------
1         60            30

and I want to transform if in this one:

Code:

ID | Parameter | Value
----------------------------------------
1    Total_time      60
1    Partial_time    30

Any help? I guess that it´s not a difficult solution but I'm not able to find it.

Thank you so much in advance.

Edu[/code]

r937 · #2 (**permalink**) 04-29-10, 22:16

Code:

SELECT id
     , 'Total_time' AS parameter
     , Total_time AS value
  FROM daTable
UNION ALL
SELECT id
     , 'Partial_time'
     , Partial_time 
  FROM daTable

soriaedu79 · #3 (**permalink**) 04-30-10, 09:27

Thank you so much, if works!!!

Regards

Internet Services

Web Development

Digital Marketing

Consumer Tech