Hi Mazahir,

SELECT AA."Company Code", AA.Name,
             (SELECT BA.Email+';'
                 FROM myTable BA
                 WHERE BA."Company Code"=AA."Company Code"
                FOR XML PATH('')
             ) AS Email
  FROM (SELECT DISTINCT "Company Code", NAME 
                FROM myTable
           ) AA

MartinaJ

>Hello universal Team
>i am not much advance in writing MS-SQL Query help me to get following output from the table.
>
>i have following information in my Table
>
>Company Code| Name | Email
>001 | ABC | ABC@123.com
>001 | ABC | EFG@123.com
>001 | ABC | EFG@123.com
>002 | AAABBBCCC | maza@gmail.com
>002 | AAABBBCCC | Maza.Naya@gmai.com
>
>Query Out Put Need:
>
>Company Code | Name | Email
>001 | ABC | ABC@123.com; EFG@123.com; EFG@123.com
>002 | AAABBBCCC | maza@gmail.com;Maza.Naya@gmai.com
>
>Thanks in Advance.
>Best Regards,
>Mazahir Naya