固定資產(chǎn)無法取消月末結(jié)賬，對應的修改方法
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
