Is there a LIST like aggregate function in SQL Server?
If not, is there any way one can be defined or the desired result achived by other means?