Aggregate field to comma separated text

--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