固定资产无法取消月末结账，对应的修改方法
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
