How to convert columns into rows(UNPIVOT) in sql server

Question

HiHow to convert columns into rows in sql server 2012 that i inserted and selected it from temp table with exampleThe way is using piviot and unpivot table  isnt true

Shashikant · Accepted Answer

HiPlease refer below Sql scriptCreate the table and insert values as portrayed in the previous exampleCREATE TABLE pvt VendorID int Emp1 int Emp2 int    Emp3 int Emp4 int Emp5 intGOINSERT INTO pvt VALUES 143544INSERT INTO pvt VALUES 241555INSERT INTO pvt VALUES 343544INSERT INTO pvt VALUES 442554INSERT INTO pvt VALUES 551555GOUnpivot the tableSELECT VendorID Employee OrdersFROM    SELECT VendorID Emp1 Emp2 Emp3 Emp4 Emp5   FROM pvt pUNPIVOT   Orders FOR Employee IN       Emp1 Emp2 Emp3 Emp4 Emp5AS unpvtGORefer below link for more informationhttpsmsdnmicrosoftcomenuslibraryms17741028vsql10529aspx

Shashikant · Answer

Please refer below linkhttpstackoverflowcomquestions14921002sqlpivotnested

How to convert columns into rows(UNPIVOT) in sql server

Company

Explore

Follow us

Contact Us