Hi,

Try this..

Hope this will help

SELECT OutTab.ID ,

Names =

STUFF ( ( SELECT ''+InrTab.Name

FROM [empInfo] InrTab

WHERE InrTab.id = OutTab.id

ORDER BY InrTab.id

FOR XML PATH(''),TYPE

).value('.','VARCHAR(MAX)')

, 1,0,SPACE(0))

FROM [empInfo] OutTab

GROUP BY OutTab.id;