create function fun(@userid varchar(200))
returns varchar(2000)
as
begin
declare @re varchar(2000)
set @re=''
select @re=@re+','+username from userinfo
where charindex(userid, @userid)>0return(stuff(@re, 1, 1, ''))
endselect meetingid, meetingname,
createrid=dbo.fun(createrid),
joinid=dbo.fun(joinid)
from meetinginfo
returns varchar(2000)
as
begin
declare @re varchar(2000)
set @re=''
select @re=@re+','+username from userinfo
where charindex(userid, @userid)>0return(stuff(@re, 1, 1, ''))
endselect meetingid, meetingname,
createrid=dbo.fun(createrid),
joinid=dbo.fun(joinid)
from meetinginfo
returns varchar2(2000)
is
v_re varchar2(2000);
begin
p_re:='';
select v_re||','|| username into v_re from userinfo
where instr(userid, p_userid)>0;return substr(v_re,2,length(v_re)-1);
end;
fun(createrid) as createrid ,
fun(joinid) as joinid
from meetinginfo