Skip to content
Advertisement

Concatenating selective string values using STUFF

I’m trying to concatenate values onto one line, but only if the EEID is the same. I know how to concatenate values using Stuff, but I can’t seem to get it to work with only selective records.
For the table below I only want to concatenate eeid = 690.

My result should be:

Advertisement

Answer

You need a correlated clause:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement