解决方案: |
总帐gl_accsum中缺少11、12月份的记录,declare @i as int
set @i=select max(iperiod) from gl_mend where bflag=1
while @i>0
begin
insert into gl_accsum (a.ccode,cexch_name,iperiod,cbegind_c,cbegind_c_engl
,mb,md,mc,cendd_c,cendd_c_engl,
me,mb_f,md_f,mc_f,me_f,nb_s,nd_s,nc_s,ne_s)
select a.ccode,cexch_name,iperiod+1,cbegind_c,cbegind_c_engl,0,0,0,cendd_c,cendd_c_engl,
0,0,0,0,0,0,0,0,0
from gl_accsum a inner join
(select ccode,max(iperiod) as maxiperiod from gl_accsum group by ccode having count(*)<12) b
on a.ccode=b.ccode and iperiod=maxiperiod
set @i=@i-1
end |