存储过程来更新表的记录代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】存储过程来更新表的记录

作者:Dezai.CN / 发布于2011/8/3/ 506

更新表的记录

<div>
CREATE OR REPLACE procedure DWUSER.update_DW_Amount as 
begin 
execute immediate 'truncate table DW_AMOUNT';
insert into DW_AMOUNT
select login_date,
login_amount,
login_fail_amount,
register_amount,
login_fail_amount/login_amount as LOGIN_FAIL_RATE
FROM

(select login_date, count(user_id) login_amount,count(case when result='Fail' then result end ) login_fail_amount
from (
select trunc(occur_date) login_date,user_id,result from T_SODW_ACTIVITY_LOG
WHERE occur_date > to_date('20110623','yyyymmdd') and type = 'SODW_ACT_018_20'
group by trunc(occur_date),user_id,result 
) group by login_date
) LOGIN_TABLE ,

(select trunc(send_date) registered_Date, count(id) register_amount from T_SODW_SUBSCRIBER_CODE
WHERE send_date > to_date('20110623','yyyymmdd') AND send_flag = 2 group by trunc(send_date)
) REGISTER_TABLE
where login_date=registered_Date order by login_date;
commit;
end;
</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　更新表的记录　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)