declare @str varchar(
1000
)
set @str = ' '
select @str = @str + ' , ' + cast(MainID as varchar) from Sale
set @str = rtrim(@str)
print @str
set @str = ' '
select @str = @str + ' , ' + cast(MainID as varchar) from Sale
set @str = rtrim(@str)
print @str
-----------------------------------------
declare @output nvarchar(1000);
select @output = coalesce(@output +',', '')+cast(MainID as varchar) from Sale;
print @output
select @output = coalesce(@output +',', '')+cast(MainID as varchar) from Sale;
print @output