Does anyone have a method to create multiple CSV aggregate columns similar to what STRING_AGG() does using FOR XML without having multiple scans of the table for inner and outer references? My TSQL foo and google foo is failing me this afternoon, or its not possible #sqlhelp

@SQLPoolBoy Is the FOR XML a requirement? There is always a CLR.

@SQLPoolBoy I don’t think it’s possible using FOR XML, because FOR XML transforms a table expression rather than a column/scalar expression.