select @tables as tablesname into #425103tablename
while 1=1
begin
select @i=charindex(',',tablesname) from #425103tablename;
if @i=0 begin
select @subTableName=tablesname from #425103tablename;
select @SQLString='insert into #425103SaleCost select a.* from vender b,'
+ ltrim(rtrim(@subTableName))
+ ' a where a.venderid=b.venderid and sdate between '%D1%'
and '%D2%' %Venderid% ';
execute (@SQLString);
break;
end
else begin
select @subTableName=substring(tablesname,1,charindex(',',tablesname)-1) from #425103tablename;
select @SQLString='insert into #425103SaleCost select a.* from vender b, '
+ ltrim(rtrim(@subTableName))
+ ' a where a.venderid=b.venderid and sdate between '%D1%'
and '%D2%' %Venderid% %KL% %zL%';
execute (@SQLString);
update #425103tablename
set tablesname=substring(tablesname,charindex(',',tablesname)+1,len(tablesname))
where 1=1;
end;
end;
while 1=1
begin
select @i=charindex(',',tablesname) from #425103tablename;
if @i=0 begin
select @subTableName=tablesname from #425103tablename;
select @SQLString='insert into #425103SaleCost select a.* from vender b,'
+ ltrim(rtrim(@subTableName))
+ ' a where a.venderid=b.venderid and sdate between '%D1%'
and '%D2%' %Venderid% ';
execute (@SQLString);
break;
end
else begin
select @subTableName=substring(tablesname,1,charindex(',',tablesname)-1) from #425103tablename;
select @SQLString='insert into #425103SaleCost select a.* from vender b, '
+ ltrim(rtrim(@subTableName))
+ ' a where a.venderid=b.venderid and sdate between '%D1%'
and '%D2%' %Venderid% %KL% %zL%';
execute (@SQLString);
update #425103tablename
set tablesname=substring(tablesname,charindex(',',tablesname)+1,len(tablesname))
where 1=1;
end;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货