Select distinct ST2.Product, (Select ST1.Country + ',' AS [text()] From dbo.AA ST1 Where ST1.Product = ST2.Product ORDER BY ST1.Product For XML PATH ('')) [Country] From dbo.AA ST2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)