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