I want to concatenate columns with a
SELECT *. For example:
SELECT * FROM Table1
Result: Col1 Col2 ---- ---- Joe Smith
I want to do something like
SELECT CONCAT(*) FROM Table1
The reason I can't mention the columns by name is that they are being produced by a PIVOT from rows, so there could be any number these columns.
If anyone knows the answer, or knows how to Get the data from any number of rows into a single cell, separated by a comma, please let me know.