Sql Query PIVOT - Row into column

Question

0.00/5 (No votes)

See more:

SQL

SQL-Server

SQL-Server-2008R2

, +

Hi,

I have problem in fetching value in the table as like below.

Table : TestTable

SQL

ID            Name             Dept              ExpiryDate
1            Rajesh              IT                 23-Jan-16 
2            Keerthi             CSE                23-Jan-16
3            Rajesh              Mech               24-Jan-16
4            Venkat              IT                 28-Jan-16
5            VenKat              IT                 29-Jan-16
6            Priya               CSE                30-Jan-16

Output :

SQL

Name           IT               CSE                 MECH

Rajesh        23-Jan-16                          24-Jan-16

Keerthi                      23-Jan-16

Venkat        29-Jan-16     

Priya         30-Jan-16

I need Name into Row and Dept into Columns. ExpiryDate as values.

Thanks,
Suresh

Posted 24-Jan-16 3:31am

itsureshuk

Updated 2-Feb-16 4:56am

Add a Solution

1 solution

Add a Solution

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

OriginalGriff · Accepted Answer · 2016-01-24T04:10:00

Solution 1

Try:

SQL

SELECT *
FROM (SELECT Name, Dept, ExpiryDate FROM TestTable) a
PIVOT (
   MAX(ExpiryDate) 
   FOR Dept in ([IT], [CSE],[Mech]) 
) AS data

Posted 24-Jan-16 4:10am

OriginalGriff

Updated 24-Jan-16 4:11am

v2

Sql Query PIVOT - Row into column

1 solution

Solution 1

Add your solution here

Preview 0

Sql Query PIVOT - Row into column

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us