PROCEDURE P_WT_B501(V_AREACODE IN STRING,
START_DATE IN STRING,
END_DATE IN STRING,
XNH_BB_501_CURSOR OUT T_CURSOR) IS
LL_START DATE;
LL_END DATE;
TABLE_NAME VARCHAR2(20);
BEGIN
LL_START := TO_DATE(START_DATE || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss');
LL_END := TO_DATE(END_DATE || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss');
OPEN XNH_BB_501_CURSOR FOR
select
D01,--本月次数
D02---累计次数-----
from (
select
sum(case when mytp =2 and d504_45 in(11,14) then 1 else 0 end ) d01,---本月次数-----
sum(case when mytp =2 and d504_45 in(11,14) then 1 else 0 end ) d02---累计次数-----累计是累计当年的
from (
select 1 sum1,d504_25,d504_53,hospital_level lv,d504_45,1 mytp,0 d501_30,D504_113,D504_114,D504_55 from d504 ,sy_dept where d504_24 in ('1','3')
and d504_55 >= LL_START
and d504_55 <= LL_END
and d504_05 like V_AREACODE||'%'
and d504_46 = jg_dm
union all
select 1 sum1,d501_19,d501_27,hospital_level lv,d501_34,2 mytp,d501_30,D501_84,D501_83,D501_18 from d501 ,sy_dept where d501_15 in ('1','3')
and d501_18 >= LL_START
and d501_18 <= LL_END
and d501_09 like V_AREACODE||'%'
and d501_17 = jg_dm
) t
);
end;
请大神帮忙修改一下，累计的，我不知道怎么搞，谢谢大家，帮帮忙