convert the columns into rows using sql server

Question

select 1 convert(char(12)b.cbm_batch_start_dt106) as Startdt convert(char(12)b.cbm_batch_end_dt106) as Enddta.course as Course from tb_rankwise_coursesettings as aCO_BATCH_MASTER as b where a.course = b.cmn_minor_code and a.Rank = 'CHENGR' and b.cbm_active 'd' and b.cbm_batch_start_dt between '2015-08-01 00:00:00.000' and '2015-12-30 00:00:00.000' order by b.cbm_batch_start_dt asc When i run the above query output as follows Startdt Enddt Course 10 Aug 2015 21 Aug 2015 REO 24 Aug 2015 04 Sep 2015 REO 14 Dec 2015 25 Dec 2015 REO But i want the output as follows REO 10 Aug 2015 21 Aug 2015 24 Aug 2015 04 Sep 2015 14 Dec 2015 25 Dec 2015 for getting output what changes i have to made in my above sql query.

Nigel Fernandes · Answer

Use UNPIVOT

Amit Singh · Answer

Hey 1.https://www.simple-talk.com/sql/t-sql-programming/switching-rows-and-columns-in-sql/ 2.http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html 3.http://stackoverflow.com/questions/21287855/sql-query-to-convert-columns-into-rows 4.http://stackoverflow.com/questions/5337380/converting-columns-into-rows-with-their-respective-data-in-sql-server

Rajeesh Menoth · Answer

Hi Converting Rows to Columns – PIVOT You can use PIVOT...!!! Reference : http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html The answer is helpful.Then please accept it ..!!