Getting the sql query output to comma separated value. For example, In the below query instaed of getting values into row by row, the below query will give the result in 1 row as a comma separated.
declare @name varchar(500)
set @name=''
select @name = coalesce(@name+lastname +',','') from employees where employeeid in (1,2,3,4,5);
select substring(@name,1,len(@name)-1)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|