SQL Query to convert column to row

Amitesh Verma

11y1.3kSQL

i want to convert the data from column to row

my data is

week percentachieve
Week1 0.002
Week2 0.004
Week3 0.003
Week4 0.003
Week5 0.002
Week6 0.014

new data would be like

week1 week2 week3 week4 week5 week6

0.002 0.004 0.003 0.003 0.002 0.014

help needed

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Supreeth J11y ago
Accepted answer
hi,

Try this...

CREATE TABLE pvt (weeks varchar(50), percentachieve decimal(5,3))
or u can use
declare @T table (weeks varchar(50), percentachieve decimal(5,3))

insert into @T values ('Week1', 0.002)

select * from @T //Normal Query

select
'weeks' as ColName,
weeks as ColValue
from @T
union all
select
'percentachieve' as ColName,
cast(percentachieve as varchar(50)) as ColValue
from @T //Changed Query
0
Abhay Shanker11y ago
you can also check below url

http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html
0

this the example query

SELECT VendorID, Employee, Orders FROM

 (SELECT VendorID, Emp1, Emp2, Emp3, Emp4, Emp5    FROM pvt) p

 UNPIVOT  (Orders FOR Employee IN (Emp1, Emp2, Emp3, Emp4, Emp5) )AS unpvt;

Amitesh Verma11y ago
It is not clear yet ,can you show this by using a temptable in sql

Thanks
0
Supreeth J11y ago
Hi,

Converting Rows to Columns (PIVOT) and
Columns to Rows (UNPIVOT) in SQL Server

Please go through following link, u may get some idea,

http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html

http://stackoverflow.com/questions/5337380/converting-columns-into-rows-with-their-respective-data-in-sql-server
+1