I've found not exact solution, but i hope it would be helpful.
SELECT [ID] AS [UserID], [Name], [Place],
STUFF( (SELECT', ' + [Spec] AS 'text()'
FROM @detailtable t2
WHERE t2.[ID] = t1.[ID]
FOR XML PATH('')), 1, 1, '') AS [Specs],
STUFF( (SELECT', ' + [Qualification] AS 'text()'
FROM @detailtable t2
WHERE t2.[ID] = t1.[ID]
FOR XML PATH('')), 1, 1, '') AS [Qualifications]
FROM @usertable t1
GROUP BY [ID], [Name], [Place]
GO
Result:
UserID | Name | Place | Specs | Qualifications |
---|
1 | Vidya | Delphi | Hi, Hello | +2, Degree |
2 | Minu | Banglore | NULL | NULL |