Hello, did not think this would be to difficult, but cannot find a clean way to do this. First I am not a SQL person by no means.
I have a table with multiple rows of data and need to roll it up to one row of data.
need the data to look like
spec code1 code2
12345 abc def
67891 xyz rst
I tried the xml feature, but how to get rid of the xml tags in the output,
Tried stuff command, but code not get it to work yet.
Must be an easier way. Any help/example would be appreciated.
Would be creating a view once I figure out how to make that work.
If code is variable (not known upfront or a large number) you might need to do this with a script