troubleshooting Question

Pivot tables in SQL

Avatar of SBarrharo
SBarrharo asked on
1 Comment1 Solution120 ViewsLast Modified:
I am having trouble getting data to pivot in my results

I have three tables
a WIP table, a Staff table, and an Engagement table.
the wip table is timesheet detail and we're trying to a total of how many hours each staff worked on each engagement. i've written the following query which returns the data needed

SELECT   TOP 100     E.ClientName AS Client, E.ClientPartner AS Partner, sum(W.WIPHours) AS Hours, S.LastName
FROM            tblEngagement E RIGHT JOIN
                         tblTranWIP AS W ON E.ContIndex = W.ContIndex CROSS JOIN
                         Staff AS S
GROUP BY E.ClientName, S.LastName, E.clientPartner

Sample Data

staff    hours    engagement
joe        5            A
steve    10          A
joe        20          B

Desired result

engagement      Joe      Steve
A                          5            10
B                          20          0
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros