• A simple script to get comma seperated result. 😎

    declare @empids varchar(max);

    set @empids = '';

    select @empids = convert(varchar, empid) + ', ' + @empids

    FROM employee

    select @empids

    --output

    --, 1 , 2, 3 , 4