convert the columns into rows using sql server

narasiman rao

10y875

select 1, convert(char(12),b.cbm_batch_start_dt,106) as Startdt,
convert(char(12),b.cbm_batch_end_dt,106) as Enddt,a.course as Course from tb_rankwise_coursesettings as a,CO_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.

3 Replies

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

Nigel Fernandes10y ago
Use UNPIVOT
Amit Kumar Singh10y ago
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 Menoth10y ago
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..!!