This is a classic crosstab problem. You handle it by case expressions to test the value in the fields column to populate a column in the result...

Jack is right. We need some sort of image to work from.

However, you will probably find examples similar to your problem if you search on "CONCATENATE",...

I have a lot of catching up to do! :w00t:

Just want to say how great it is to see so much hard discussion and comparison going on in...

Gus, I rewrote your function as an inline table valued function and it gets the job done in half the time of the ConcatMaxTest function, but still three times longer...

It's not a big deal, Steve. Folks have been referring to Flo as "she/her". I swapped a few cordial posts with Flo a couple...

VK... my observation is that there is a world of valuable information to be learned from the people who hang around SSC. I shamelessly take every opportunity to...

Thanks, Gail. I was sure about the ORDER BY, but not the clustered index. I couldn't find any of the threads where either was discussed.

Y'all quit picking on my man, Florian. 😉

Thanks, AL. 🙂

There is a lot of new (to me) stuff out there that is worth practicing with. I don't really "own" a technique...

While I never wired boards, Jeff, I did start out with 80 column cards and 7mb of disk and time to have lunch while the code compiled. ...

Sorry about raising the ORDER BY issue. I threw that in while looking at the tests and just had a brain-short not thinking about the functions themselves. ...

Flo: I'm not at my laptop right now, so I can't test your code. I'll do so at the earliest opportunity. Couple of...

Jeff you shoulda been a lawyer :-D. Wasn't it you asking why people needed to do this on another thread? I'm in total agreement that passing summary...

Your first example confuses me a little. (Why 42d and not 42e? Typo?)

However, if you are only wanting to get one single row back for each...

I'm afraid more information is required. Your MATCHSRNO in the output set obviously references other rows in the output set, but I am not seeing the correlation between...