convert columns into rows

Question

0.00/5 (No votes)

See more:

date	        sess	code	course
14-Jan-13	1	CM	AFF
14-Jan-13	3	CM	AFF
17-Jan-13	1	NR	CTF

i want the output as follows in sql server using query,how can i do please reply.it is very helpful for me.

               AFF (course)
        1   2  3  4 (sess)
14-Jan-13   CM     CM

              CTF  (course)
        1   2  3  4 (sess)
17-Jan-13   NR

I want the above output, using query.

please reply.it is very helpful for me.

Posted 19-Jan-13 1:26am

Member 8054539

Updated 19-Jan-13 2:18am

Tharaka MTR

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tharaka MTR · Answer 1 · 2013-01-19T02:50:00

check the following query

SQL

SELECT *
FROM (
SELECT *
FROM [YOUR_TABLE_NAME]
) P
PIVOT (
MAX([code])
FOR [sess] IN ([1],[2],[3] ,[4])
) AS PVT

It returns the output as follows

date       course 1     2     3     4
---------- ------ ----- ----- ----- -----
2013-01-14 AFF    CM    NULL  CM    NULL
2013-01-17 CTF    NR    NULL  NULL  NULL

you can modify that by adding the where clause for course column

Pallavi Waikar · Answer 2 · 2013-01-19T02:21:00

go through following links...study them and try for ur database table's...
http://stackoverflow.com/questions/11323024/how-to-convert-columns-to-rows-in-sql-server[^]
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]
....it is called as PIVOT and UNPIVOT Table

convert columns into rows

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

convert columns into rows

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us