/*
2013-9-18,小科问题
原本固定资产8月启用,后想改成9月启用,改完之后
修改卡片就报错,EOF或BOF
*/
use ufdata_001_2013
go
update fa_cards set iinputperiod='9'
go
update fa_q_Cards set dbldeprT9=dbldeprT8
update fa_q_Cards set ldeprmonths9=ldeprmonths8
update fa_q_Cards set lusedmonths9=lusedmonths8
update fa_q_Cards set dblmonthvalue9=dblmonthvalue8
update fa_q_Cards set dbldeprT8=0
update fa_q_Cards set ldeprmonths8=0
update fa_q_Cards set lusedmonths8=0
update fa_q_Cards set dblmonthvalue8=0
go
update fa_DeprTransactions set iinputperiod='9'
update fa_DeprTransactions set dbldeprT9=dbldeprT8
update fa_DeprTransactions set ldeprmonths9=ldeprmonths8
update fa_DeprTransactions set lusedmonths9=lusedmonths8
update fa_DeprTransactions set dblmonthvalue9=dblmonthvalue8
update fa_DeprTransactions set dbldeprT8=0
update fa_DeprTransactions set ldeprmonths8=0
update fa_DeprTransactions set lusedmonths8=0
update fa_DeprTransactions set dblmonthvalue8=0
go
update fa_total set iperiod='9'
go
update fa_Cards set lUsedMonths=DateDiff(m, dstartdate,'2013-8-1')
go
update fa_q_Cards
set fa_q_Cards.linputdeprmonths=fa_Cards.lUsedMonths
from fa_q_Cards
left join fa_Cards
on fa_q_Cards.scardnum=fa_Cards.scardnum
go
update fa_q_Cards set ldeprmonths9=linputdeprmonths
update fa_q_Cards set lusedmonths9=linputdeprmonths
update fa_q_Cards set lusedmonths=linputdeprmonths
go
update fa_DeprTransactions
set fa_DeprTransactions.linputdeprmonths=fa_Cards.lUsedMonths
from fa_DeprTransactions
left join fa_Cards
on fa_DeprTransactions.scardnum=fa_Cards.scardnum
go
update fa_DeprTransactions set ldeprmonths9=linputdeprmonths
update fa_DeprTransactions set lusedmonths9=linputdeprmonths
go