Want to convert 3 rows in 3 columns with inner join in SQL Server

Question

I have a result set like this

And query for this result set is

SELECT 
    dt.GangName, u.UserFullName,dt.Designation, v.RegNo, 
    dt.SignInTime, dt.SignOutTime, z.ZoneName
FROM 
    DutyRoosterTeam dt
INNER JOIN 
    DutyRooster dr ON dr.DutyRoosterID = dt.DutyRoosterID
INNER JOIN 
    Users u ON u.UserId = dt.UserID
INNER JOIN 
    Vehicle v ON v.VehicleId = dt.MTLID
INNER JOIN 
    Zone z ON z.ZoneId = dt.ZoneID

But I want result set like this

score 0 · Accepted Answer · edited May 23 '17 at 11:58

0

My copy-pasta-fu is strong. Take a look at the solution provided by bluefeet here:

Convert Rows to columns using 'Pivot' in SQL Server

edited May 23 '17 at 11:58

Community

1
1

answered Apr 05 '16 at 14:48

T Gray

712
4
10

Want to convert 3 rows in 3 columns with inner join in SQL Server

1 Answers1