troubleshooting Question

Example to create one row of data from multiple rows and have multiple columns,

Avatar of Terry Ambrosius
Terry Ambrosius asked on
* multipleSQLMicrosoft SQL Server
12 Comments1 Solution140 ViewsLast Modified:
I have a table with rows of data and I need to create one row of data that has multiple columns,  

ord           color
1               ink1
1              ink2
1              ink3
1              ink4

How can I role the table to look like this:
ord               col1    col2     col3     col4
1                   ink1    ink2     ink3    ink4

I tried the stuff command and that will just create     1 row with 2 fields,   ord     and ink    
                                                                                                                                  1         ink1,ink2,ink3,ink4
Thought this would be easy, and I am not a SQL expert by any means.  
But I could sure use some help in the way of an example.

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 12 Comments.
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 12 Comments.
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