Cacher is the code snippet organizer for pro developers

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