see this
declare @t table (Ename nvarchar(200), EmpNo int)
insert into @t
select 'Bhuvnesh' , 11 union
select 'girth' , 11 union
select 'pooja' , 12 union
select 'rana' , 12
select distinct EmpNo, STUFF((select ' ' + cast(Ename as nvarchar(20)) from @t where t.EmpNo = EmpNo FOR XML PATH('')),1,1,'')
from @t t
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)