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

Try this:

declare @ConcatEmpolyee VARCHAR(MAX) = ''

SELECT @ConcatEmpolyee = @ConcatEmpolyee + EmployeeName + ',' FROM dbo.<<YourTable>>

Select Left(@ConcatEmpolyee,LEN(@ConcatEmpolyee) - 1)

---

Regards Harsh