Example to create one row of data from multiple rows and have multiple columns,
I have a table with rows of data and I need to create one row of data that has multiple columns,
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
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.
* multipleSQLMicrosoft SQL Server
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst