Aggregate field to comma separated text Get link Facebook X Pinterest Email Other Apps May 08, 2013 --Works good with numbers, careful with text due to xml-conversion select stuff( ( select ','+AnimalId from dbo.Animal as a for xml path('') ), 1,1,'') AS AggregatedAnimalIdsAsString Read more