Microsoft SQL Server (MSSQL) Older versions of MSSQL used complex XML paths for row aggregation, but modern versions (2017+) utilize STRING_AGG ().