tmp DY_StValueEnd%type
select * into tmp from DY_StValueEnd where iMeasurPointegerID = id and iDate between :DateSt and :DateEd;select sum(iStTime),
max(fMaxValue),
min(fMinValue),
sum(fAvgValue*iStTime),
sum(iTCheckOut),
sum(iOffUpTime),
sum(iOffDownTime) into timeST,nMaxValue,nMinValue,nSumValue,timeCK,timeUp,timeDown
from tmp;......drop table tmp;
select * into tmp from DY_StValueEnd where iMeasurPointegerID = id and iDate between :DateSt and :DateEd;select sum(iStTime),
max(fMaxValue),
min(fMinValue),
sum(fAvgValue*iStTime),
sum(iTCheckOut),
sum(iOffUpTime),
sum(iOffDownTime) into timeST,nMaxValue,nMinValue,nSumValue,timeCK,timeUp,timeDown
from tmp;......drop table tmp;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货