问题描述:t3客户4个账套,其它三个正常结转了,有一个在建立年度账时提示错误
问题回复:
请执行以下语句: use UFDATA_002_2014 update accinformation set cvalue='8.213',cdefault='8.213' where csysid='aa' and cid='99' delete from dbo.GL_msysname drop table rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef select * into rpt_flddef from UFDATA_999_2011..rpt_flddef select * into rpt_fltdef from UFDATA_999_2011..rpt_fltdef select * into rpt_glbdef from UFDATA_999_2011..rpt_glbdef select * into rpt_grpdef from UFDATA_999_2011..rpt_grpdef select * into rpt_reldef from UFDATA_999_2011..rpt_reldef select * into rpt_folder from UFDATA_999_2011..rpt_folder select * into rpt_itmdef from UFDATA_999_2011..rpt_itmdef ALTER TABLE dbo.Rpt_FldDEF DROP COLUMN CurGroupCol ALTER TABLE dbo.Rpt_FldDEF DROP COLUMN CurSubTotalCol 执行后登录系统管理重新进行“升级sqlserver数据”操作,安装补丁执行脚本再建立2015年度账。