set @sql =
			'
			 select uc.UserName,
					r.RoleName
			from ' + @PortalDb30 + '.dbo.aspnet_Membership m
					inner join ' + @Portal + '.dbo.UserConfig uc
						on uc.userid = m.userid
					inner join ' + @Portal + '.dbo.Company c
						on c.CompanyCode = uc.CompanyCode
					inner join ' + @Portal + '.dbo.aspnet_UsersInRoles ur
						on ur.userid = uc.userid
					inner join ' + @Portal + '.dbo.aspnet_Roles r
						on r.RoleId = ur.RoleId
			where c.CompanyCode = ''' + @CompanyCode + ''''

		If @UserName is NOT NULL
			set @sql = @sql + ' and uc.UserName = ''' + @UserName + ''' order by uc.UserName '
		Else If @RoleName IS NOT NULL
			set @sql = @sql + ' and r.RoleName = ''' + @RoleName + ''' order by uc.UserName'
		Else
			set @sql = @sql + ' order by uc.UserName'		

		
		exec sp_executesql @sql

declare @tbl table (
	pkey	int identity(1, 1),
	fruit	varchar(20) not null
	)

insert into @tbl(fruit)
select 'Apples' union all
select 'Bananas' union all
select 'Cherries'

select *
from @tbl

declare @csv_list varchar(max) = ''

update @tbl
set	@csv_list += fruit + ','

set @csv_list = LEFT(@csv_list, len(@csv_list) - 1)  -- Remove trailing comma

select @csv_list csv