Convert Column value into Number of rows

Question

Guys in Sql Server How to make Last Column Thats is Speed Column as a Row For Perticular Rdr_no column. Thank you in Advance RDR_No Cvt_no Sns_no H_no Speed ------- -------- ------- ---------- ------ 1169 B3_091 B3_040 96 025 1169 B3_091 B3_040 96 064 1169 B3_091 B3_040 96 096 1169 B3_091 B3_040 96 119 1146 B3_114 B3_024 54 026 1146 B3_114 B3_024 54 064 1146 B3_114 B3_024 54 095 1146 B3_114 B3_024 54 119 1161 B3_149 B3_053 17 025 1161 B3_149 B3_053 17 064 1161 B3_149 B3_053 17 096 1161 B3_149 B3_053 17 119 1167 B3_113 B3_122 103 026 1167 B3_113 B3_122 103 063 1167 B3_113 B3_122 103 095 1167 B3_113 B3_122 103 121

Tapan Patel · Answer

You can surely use Pivot query and here is the example for the same. http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html Please mark it as an answer if it resolves the issue.

Bahubali Gane · Answer

Yes Guys Thank u for your suggestions. Thank You very much Tapanbikesh and vinay

Bikesh Srivastava · Answer

Hi you can use pivot table query..

Bahubali Gane · Answer

Thank You for your replay but i need column header should be rdr_no 256496 and 120 in resultant table

Vinay Singh · Answer

Hi Try the link 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 http://stackoverflow.com/questions/21287855/sql-query-to-convert-columns-into-rows http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql