declare @emp table ( name varchar(50) primary key )
insert @emp values
    ( 'Lino' ),
    ( 'John' ),
    ( 'Noel' )

select *
into #while_loop
from @emp

declare @name varchar(50), @str varchar(max)

while exists ( select * from #while_loop )
begin
    select top 1 @name = name
    from #while_loop
    
    delete #while_loop
    where name = @name
    
    set @str = case
        when @str is null
            then @name
        else @str + ',' + @name
    end
end

drop table #while_loop

print @str

declare @str varchar(max)

select
    @str = case
        when @str is null
            then name
        else @str + ',' + name
    end
from @emp

print @str