清薪资和考核脚本

孙亮 2007-03-12

--清楚个险考核数据 delete from laassess where branchtype = '1'                                  ; delete from laassesshistory where branchtype = '1'                           ; delete from lAAssessmain where branchtype = '1'                              ; Delete From laindexinfo Where Indextype In ('03','02','04') and agentcode in (select agentcode from laagent where branchtype = '1'); commit;   ---团险考核的清库脚本－－－ Delete From LAASSESSHISTORY Where branchtype='2'; Delete From LAAssessMain Where branchtype='2'; Delete From laassess Where branchtype='2'; Delete From laindexinfo Where indextype in ('02','03') and agentcode in (select agentcode from laagent where branchtype = '2'); commit; ---银代考核的清库脚本－－－ Delete From LAASSESSHISTORY Where branchtype='3'; Delete From LAAssessMain Where branchtype='3'; Delete From laassess Where branchtype='3'; Delete From laindexinfo Where indextype in ('02','03') and agentcode in (select agentcode from laagent where branchtype = '3'); commit;   ---团险佣金和薪资的清库脚本 delete    from lawagelog       where    wageno like '2007%'        and branchtype = '2' and managecom like '8661%'; delete    from lawagehistory where    wageno like '2007%'        and branchtype = '2' and managecom like '8661%'; delete    from lawage          where    indexcalno    like '2007%' and branchtype = '2' and    managecom like '8661%'; delete    from lacommision     where    wageno like '2007%'        and branchtype = '2' and managecom like '8661%' ; delete    from lacharge        where wageno like '2007%'         and branchtype = '2' and managecom like '8661%'; delete from laindexinfo      where indextype not in ('02','03') and agentcode in (select agentcode from laagent where branchtype = '2') and indexcalno like '2007%' and    managecom like '8661%'; delete from laindexinfotemp where indextype not in ('02','03') and agentcode in (select agentcode from laagent where branchtype = '2') and indexcalno like '2007%' and    managecom like '8661%'; truncate table lmgrpcharge; commit;