Строки через запятую #MsSql
(SELECT STUFF(( SELECT ', ' + rtrim(ltrim(ph.EmailString))
FROM Email AS ph
join Contact_Email ccp on (ccp.Email = ph.Id)
where ccp.Contact = cc.id
FOR XML PATH('') ), 1,1,'') AS activities ) AS EMAIL ,