Create Table tbl_Customer_Bank_Details ( [Customer ID] int, [Customer Name] varchar(50), [Bank Account No] varchar(50) ) GO Insert into tbl_Customer_Bank_Details Values (1,'Imran','A001') Insert into tbl_Customer_Bank_Details Values (1,'Imran','A002') Insert into tbl_Customer_Bank_Details Values (1,'Imran','A003') Insert into tbl_Customer_Bank_Details Values (2,'Bob','B001') Insert into tbl_Customer_Bank_Details Values (2,'Bob','B002') GO Select * from tbl_Customer_Bank_Details SELECT [Customer ID], [Customer Name] , STUFF((SELECT ', ' + A.[Bank Account No] FROM tbl_Customer_Bank_Details A Where A.[Customer ID]=B.[Customer ID] FOR XML PATH('')),1,1,'') As [Bank Accounts] From tbl_Customer_Bank_Details B Group By [Customer ID], [Customer Name]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)