troubleshooting Question

Display data horizontally

Avatar of no_hop
no_hop asked on
Microsoft SQL Server
1 Comment1 Solution863 ViewsLast Modified:
I'm wondering if there is a way to do this.  For instance if I have the following table:
ID     Salesman      Tools          Job_Num
1      John              Hammer      1
2      John              Drill             2
3      Jack               Hammer      1
4      Rob               Hammer      3

I was wondering how to display the query results horizontally in SQL server 2000.  The thing is, the number of salesman per job is unknown.  It could be anywhere from 1-5.  How can I display results horizontally based on job_number? Like:

Salesman    ColumnName    Tools         Tools2         Job_Num
John            Jack                 Hammer     Hammer      1
John            Null                  Drill           Null              2
etc....

Is there a way to do this.. Again, there is no exact amount of Salesman for any job, only that it could be between 1-5.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
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