how to merge one column values with same primary key please...

I think you may want this

select a.Social, count(a.model_no) as PlanCount, STUFF((select '; ' + Model_no 
FROM dbo.cpDetails D1 LEFT JOIN TBACTDetails A1 ON D1.AcctNo = A1.Social 
WHERE A1.model_NAME IS NULL AND A1.Social = A.Social
FOR XML PATH('')),1,2,'') as ModelNos
FROM dbo.cpDetails D LEFT JOIN TBACTDetails A ON D.AcctNo = A.Social 
WHERE A.model_NAME IS NULL
GROUP BY D.AcctNo  

Since I don't have your table structures and data in these tables, this is a guess of how the query will look like. You may want to adjust.

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog