Convert Column value into Number of rows

Bahubali Gane

10y992

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

5 Replies

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

Tapan Patel10y ago
Accepted 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 Gane10y ago
Yes Guys Thank u for your suggestions.
Thank You very much Tapan,bikesh and vinay
Bikesh Srivastava10y ago
Hi,
you can use pivot table query..
Bahubali Gane10y ago
Thank You for your replay but i need column header should be rdr_no, 25,64,96 and 120
in resultant table
Vinay Singh10y ago
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