declare @empids varchar(max);
set @empids = '';
select @empids = convert(varchar, empid) + ', '  + @empids 
		FROM    employee

select @empids

--output
--, 1 , 2, 3 , 4