Assuming the fields are varchar, you can write the following code
DECLARE @ListEmp VARCHAR(MAX)
SELECT @ListEmp = COALESCE(@ListEmp+',' ,'') + EmpName FROM table_name
SELECT @ListEmp
if the fields are numeric, then convert the EmpName to varchar and then append the same..