How to get All "Employee" name field in one row ?

declare @t table(id int,name varchar(10))
insert into @t values(1,'Amit'),(2,'Varun'),(3,'Rakesh'),(4,'Rajesh')
select * from @t
SELECT  STUFF((SELECT ',' + Name 
FROM @t FOR XML PATH('')), 1, 1, '' ) as t

---

ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you