SQL aggregation function: STRING_AGG

STRING_AGG is an aggregate function that takes all expressions from rows and concatenates them into a single string. FOR XML PATH is the previous version of the STRING_AGG function : select a.NameSurname -- previous version , stuff((select ',' + x.Ph...