codecorner.galanter.net
T-SQL String Aggregate in SQL Server
T-SQL dialect of SQL doesn’t have aggregate functions for strings, but there is an easy workaround using magic of XML. Consider Employees table of the Northwind database. When I run following…