Often when generating dynamic sql we must add some separator values in the string(s) we build. A function delivered way back in 2017 called STRING_AGG is a simple way to do this. Let’s look at some examples.
There are a lot of people who have never heard of the function and don’t know that there’s a better alternative to the combination of
FOR XML PATH to concatenate together strings.