begin
set @tableName = 'CallDetail_20090601'
if exists (select * from dbo.sysobjects where [name]=@tableName )
begin --else SUBSTRING(ANI,0,4) else SUBSTRING(DNI,0,4)
if(@calltype = '2') --全部 end as ANITel,case
set @select=N' insert into #mycalldetail select case when SUBSTRING(ANI,0,3)=013 then SUBSTRING(ANI,1,7) end as ANI,
case when SUBSTRING(DNI,0,3)=013 then SUBSTRING(DNI,1,7) end as DNI from '+@tableName+' where CustID='+@CustID+' and ServerID='+@ServerID+'; select * from #mycalldetail '
end
end
exec(@select)
set @tableName = 'CallDetail_20090601'
if exists (select * from dbo.sysobjects where [name]=@tableName )
begin --else SUBSTRING(ANI,0,4) else SUBSTRING(DNI,0,4)
if(@calltype = '2') --全部 end as ANITel,case
set @select=N' insert into #mycalldetail select case when SUBSTRING(ANI,0,3)=013 then SUBSTRING(ANI,1,7) end as ANI,
case when SUBSTRING(DNI,0,3)=013 then SUBSTRING(DNI,1,7) end as DNI from '+@tableName+' where CustID='+@CustID+' and ServerID='+@ServerID+'; select * from #mycalldetail '
end
end
exec(@select)
create table #mycalldetail(ANI varchar(7),DNI varchar(7))
set @tableName = 'CallDetail_20090601'
--...
end
select * into #mycalldetail from tb 语法也行
insert into ##mycalldetail