Minor fix in Martina's query:
SELECT AA."Company Code", AA.Name,
(SELECT BA.Email + '; '
FROM myTable BA
WHERE BA.[Company Code] = AA.[Company Code] and BA.[Name] = AA.[Name]
FOR XML PATH('')
) AS Email
FROM (SELECT DISTINCT "Company Code", NAME
FROM myTable
) AA
>hello Martina
>
>so far query working fine but duplicate record is still in query output.
>
>Query Out Put:
>Company_Code Name Email
>001 Chung, Kristina abc@xyz.com;asdfg@gmail.com;
>001 Lawrence, Neal abc@xyz.com;asdfg@gmail.com;
>
>002 Gallagher, Marian maza@gmail.com;mazahir.naya@gmail.com;
>002 Steele, Alex maza@gmail.com;mazahir.naya@gmail.com;
>
>003 Hawkins, Stephanie rohit@gmail.com;mprint@pixel.com;
>003 Middleton, Tim rohit@gmail.com;mprint@pixel.com;
>
>004 Frame, Mark shanty@kuwait.com;
>
>Thank You.
>Best Regards,
>Mazahir
If it's not broken, fix it until it is.
My Blog