SQL Query to convert column to row

Question

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

Supreeth J · Answer

hi Try this... CREATE TABLE pvt (weeks varchar(50) percentachieve decimal(53)) or u can use declare @T table (weeks varchar(50) percentachieve decimal(53)) 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

Supreeth J · Answer

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

Abhay Shanker · Answer

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

Partha Sarathi · Answer

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 Verma · Answer

It is not clear yet can you show this by using a temptable in sql Thanks