22,302
社区成员




create proc black2bi(@intput varchar(2000))
as
begin
declare @sql varchar(2000)
create table #tab (fldEmail varchar(200))
select @sql='insert into #tab select '''+replace(@intput,',',''' union all select ''')+''' '
exec(@sql)
select a.fldEmail,isnull(b.fldloginName,'') fldloginName
from #tab a
left join tblUser b
on a.fldEmail=b.fldEmail
drop table #tab
end
create proc black2bi(@intput varchar(2000))
as
begin
declare @sql varchar(2000)
create table #tab (fldEmail varchar(200))
select @sql='insert into #tab select '''+replace(@intput,',',''' union all select ''')+''' '
exec(@sql)
select a.fldEmail,isnull(b.fldloginName,'') fldloginName
from tab a
left join tblUser b
on a.fldEmail=b.fldEmail
end
create proc black2bi(@intput varchar(2000))
as
begin
declare @sql varchar(2000)
create table #tab (fldEmail varchar(200))
select @sql='insert into #tab select '''+replace(@intput,',',''' union all select ''')+''' '
exec(@sql)
select a.fldEmail,b.fldloginName
from tab a
left join tblUser b
on a.fldEmail=b.fldEmail
end