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.