固定资产无法取消月末结账,对应的修改方法 use ufdata_008_2012 --select * into fa_vtsobject20120423 from fa_vtsobject order by imonth,smodelid select * from fa_vtsobject order by imonth,smodelid use ufdata_008_2011 select * from fa_vtsobject order by imonth,smodelid
--从上一年中的表中补充缺少的记录
insert into ufdata_008_2012..fa_vtsobject( iMonth,sModelId,objVtsfile)
select iMonth,sModelId,objVtsfile from ufdata_008_2011..fa_Vtsobject
where iMonth not in (select DISTINCT(iMonth) from ufdata_008_2012..fa_vtsobject)
insert into fa_vtsobject(imonth,sModelId,objVtsfile,iyear)
select '6',sModelId,objVtsfile,iyear from fa_vtsobject where iyear=2021 and iMonth=5
--因为上一年的记录也缺少,所以要手工添加记录
insert into ufdata_008_2012..fa_vtsobject( iMonth,sModelId,objVtsfile)
select 1,sModelId,objVtsfile from ufdata_008_2011..fa_Vtsobject where iMonth =4