|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
UpdatSQL_400_2004.txt 文件;
----------------------------------------------------------
开始升级861
已经是861版本
开始调用Userdef
结束调用Userdef
不需要数据类型转换
结束升级861
开始收缩数据库
结束收缩数据库
需要升级870
升级870错误
Success = 1 Failed = 2 NoAction = 3 state值为2
升级账套:UFDATA_400_2004年度账失败,错误号: 升级SQL Server数据库。
结束升级UFDATA_400_2004
退出UpdateOneDB :
UFDATA_400_2004: 升级失败!
ufdata文件
--------------------------------------------
数据库名: UFDATA_400_2004
D:\U8SOFT\Admin\SQLFILE8700\Main\Ufdata\Structure\Data_PRP_CA_mix_NL.sql
错误信息:
-2147217900
列名 'ionpdtamo_auxi' 无效。
执行如下语句时出错:
CREATE PROCEDURE CaP_CalPrepare
(
@dMaxDate nvarchar(12), --计算期间的最大日
@dMinDate nvarchar(12), --计算期间的最小日
@iPeriod int --计算期间
)
AS
-- 工时
insert into CA_timst(cppid,cbatch,irealwkt,iperiod)
select B.irealcoid,B.cbatch,isnull(sum(A.irealwkt),0) as irealwkt,@iPeriod from ca_batchmap_cur B
inner join CA_daytis A on A.cppid = B.irealcoid and A.cbatch = B.cbatch
where A.ddate>=@dMinDate and A.ddate<=@dMaxDate
group by B.irealcoid,B.cbatch;
insert into CA_timst(cppid,cbatch,irealwkt,iperiod)
select B.irealcoid,B.cbatch,0,@iPeriod from ca_batchmap_cur B
left join (select cppid,cbatch from CA_timst where iperiod = @iPeriod) A on A.cppid = B.irealcoid and A.cbatch = B.cbatch
Where A.cPPID Is Null;
-- 完工
insert into CA_comps(cppid,cbatch,iwastequa,iqua,iperiod)
select B.irealcoid,B.cbatch,isnull(sum(A.iwastequa),0) as iwastequa,isnull(sum(A.iqua),0) as iqua,@iPeriod from ca_batchmap_cur B
inner join CA_dacps A on A.cppid = B.irealcoid and A.cbatch = B.cbatch
where A.ddate>=@dMinDate and A.ddate<=@dMaxDate
group by B.irealcoid , B.cbatch ;
insert into CA_comps(cppid,cbatch,iwastequa,iqua,iperiod)
select B.irealcoid,B.cbatch,0,0,@iPeriod from ca_batchmap_cur B
left join (select cppid,cbatch from CA_timst where iperiod = @iPeriod) A on A.cppid = B.irealcoid and A.cbatch = B.cbatch
Where A.cPPID Is Null;
-- 耗用
insert into CA_propu(cppid,cbatch,cuseppid,iqua,iperiod)
select A.cPPID,A.cBatch,A.cuseppid,sum(A.iqua) as iqua,@iPeriod from CA_ppudr A
inner join ca_batchmap_cur B on A.cppid = B.irealcoid and A.cbatch = B.cbatch
inner join (select distinct irealcoid,ibomtype from ca_batchmap_cur) C on A.cppid = C.irealcoid
where A.ddate>=@dMinDate and A.ddate<=@dMaxDate and isnull(iqua,0) <> 0 and A.cppid <> A.cuseppid
group by a.cPPID , a.cBatch, a.cuseppid;
-- 盘点
insert into ca_enmop(cppid,cbatch,ionpdtamo,ionpdtamo_auxi,irate,ifinpdtamo,ifinpdtamo_auxi,ionpwkt,iperiod,cunit)
select B.irealcoid,B.cbatch,0,0,C.irate,0,0,0,@iPeriod,'' from ca_batchmap_cur B
left join (select * from ca_enmop where iperiod = @iPeriod) A on A.cppid = B.irealcoid and A.cbatch = B.cbatch
left join caq_invrate C on B.invcode = C.cinvcode
Where A.cPPID Is Null ;
-- 如果在产品分配是按材料倒记,清空相应成本中心的ca_quo标志,
update A set A.bchkflag = 0
from ca_quoall A
inner join ca_batchmap_cur B on A.cppid = B.irealcoid and A.cbatch = B.cbatch
where A.bchkflag = 1 and isnull(A.iquo,0) > 0
-- 删除为bchkflag=1并且没有录入定额的数据
delete from ca_quoall
where bchkflag = 1
|
|