SELECT PersonID, ConcatedNatedCardnumbersByPersonIDWise from card
select PersonID,STUFF(( SELECT '],[' + CardNumber FROM [Card Table] Where [Card Table].PersonID = t2.PersonID Order by CardNumber FOR XML PATH('')), 1, 2, '') + ']' from [Card Table] as t2 group by PersonID
select PersonID, STUFF( (select ','+ CardNumber from TempTable1 sch where sch.PersonID = sch1.PersonID FOR XML PATH('')) ,1,1,'') from TempTable1 sch1 group by PersonID order by 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)