汇总帐套汇总不了什么原因啊

MONING

各位高手,汇总帐套汇总不了什么原因啊,客户有我好几个帐套,按照标准流程做了汇总帐套,占执行后,有如下提示 ,去汇总帐套中查询却什么也没有?

[ 本帖最后由 MONING 于 2008-12-2 19:26 编辑 ]

MONING

=======================================
新的复制工作开始于2008-12-02 18:43:23
开始复制数据，从 zw0001 到 zw0003,2008-12-02 18:43:23
    开始复制    核算单位=PubHSDW|
BEGIN TRANSACTION

    结束复制    核算单位=PubHSDW|
    开始复制    辅助说明项=GL_Fzsmx|gsdm|
select *  into #GL_Fzsmx from zw0001.dbo.GL_Fzsmx where  gsdm=''
BEGIN TRANSACTION
Update #GL_Fzsmx set gsdm='01'
delete zw0003.dbo.GL_Fzsmx where  gsdm='01'
insert into zw0003.dbo.GL_Fzsmx select * from #GL_Fzsmx

    结束复制    辅助说明项=GL_Fzsmx|gsdm|
    开始复制    科目基本信息=GL_Kmxx|gsdm|Y,Xg_RQ|
select *  into #GL_Kmxx from zw0001.dbo.GL_Kmxx where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Kmxx set gsdm='01'
delete zw0003.dbo.GL_Kmxx where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.GL_Kmxx select * from #GL_Kmxx

    结束复制    科目基本信息=GL_Kmxx|gsdm|Y,Xg_RQ|
    开始复制    凭证摘要信息=GL_Pzzy|
select *  into #GL_Pzzy from zw0001.dbo.GL_Pzzy
BEGIN TRANSACTION

delete zw0003.dbo.GL_Pzzy
insert into zw0003.dbo.GL_Pzzy select * from #GL_Pzzy

    结束复制    凭证摘要信息=GL_Pzzy|
    开始复制    辅助项类别说明=GL_Fzxlb|gsdm|N,Xg_RQ|
select *  into #GL_Fzxlb from zw0001.dbo.GL_Fzxlb where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Fzxlb set gsdm='01'
delete zw0003.dbo.GL_Fzxlb where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.GL_Fzxlb select * from #GL_Fzxlb

    结束复制    辅助项类别说明=GL_Fzxlb|gsdm|N,Xg_RQ|
    开始复制    辅助项资料表=GL_Fzxzl|gsdm|N,Xg_RQ|
select *  into #GL_Fzxzl from zw0001.dbo.GL_Fzxzl where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Fzxzl set gsdm='01'
delete zw0003.dbo.GL_Fzxzl where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.GL_Fzxzl select * from #GL_Fzxzl

    结束复制    辅助项资料表=GL_Fzxzl|gsdm|N,Xg_RQ|
    开始复制    凭证类型=GL_Pzlx|gsdm|N,Xg_RQ|
select *  into #GL_Pzlx from zw0001.dbo.GL_Pzlx where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Pzlx set gsdm='01'
delete zw0003.dbo.GL_Pzlx where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.GL_Pzlx select * from #GL_Pzlx

    结束复制    凭证类型=GL_Pzlx|gsdm|N,Xg_RQ|
    开始复制    操作日志=GL_CZRZ||N,date|
select *  into #GL_CZRZ from zw0001.dbo.GL_CZRZ where date like '200812%'
BEGIN TRANSACTION

delete zw0003.dbo.GL_CZRZ where date like '200812%'
insert into zw0003.dbo.GL_CZRZ select * from #GL_CZRZ

    结束复制    操作日志=GL_CZRZ||N,date|
    开始复制    现金流量项目=GL_Xjllxm|gsdm|N,Xg_RQ|
select *  into #GL_Xjllxm from zw0001.dbo.GL_Xjllxm where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Xjllxm set gsdm='01'
delete zw0003.dbo.GL_Xjllxm where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.GL_Xjllxm select * from #GL_Xjllxm

    结束复制    现金流量项目=GL_Xjllxm|gsdm|N,Xg_RQ|
    开始复制    项目基础资料(项目代码定义)=GL_Xmzl|gsdm|N,Xg_RQ|
select *  into #GL_Xmzl from zw0001.dbo.GL_Xmzl where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Xmzl set gsdm='01'
delete zw0003.dbo.GL_Xmzl where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.GL_Xmzl select * from #GL_Xmzl

    结束复制    项目基础资料(项目代码定义)=GL_Xmzl|gsdm|N,Xg_RQ|
    开始复制    币种信息=PubBizh|gsdm|N,Xg_RQ|
select *  into #PubBizh from zw0001.dbo.PubBizh where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #PubBizh set gsdm='01'
delete zw0003.dbo.PubBizh where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.PubBizh select * from #PubBizh

    结束复制    币种信息=PubBizh|gsdm|N,Xg_RQ|
    开始复制    浮动汇率=PubHlb|gsdm|
select *  into #PubHlb from zw0001.dbo.PubHlb where  gsdm=''
BEGIN TRANSACTION
Update #PubHlb set gsdm='01'
delete zw0003.dbo.PubHlb where  gsdm='01'
insert into zw0003.dbo.PubHlb select * from #PubHlb

    结束复制    浮动汇率=PubHlb|gsdm|
    开始复制    部门信息=PubBmxx|gsdm|N,Xg_RQ|
select *  into #PubBmxx from zw0001.dbo.PubBmxx where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #PubBmxx set gsdm='01'
delete zw0003.dbo.PubBmxx where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.PubBmxx select * from #PubBmxx

    结束复制    部门信息=PubBmxx|gsdm|N,Xg_RQ|
    开始复制    地区资料=PubDQZL|gsdm|N,Xg_RQ|
select *  into #PubDQZL from zw0001.dbo.PubDQZL where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #PubDQZL set gsdm='01'
delete zw0003.dbo.PubDQZL where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.PubDQZL select * from #PubDQZL

    结束复制    地区资料=PubDQZL|gsdm|N,Xg_RQ|
    开始复制    集团公司资料=PubGSZL||N,Xg_RQ|
BEGIN TRANSACTION

    结束复制    集团公司资料=PubGSZL||N,Xg_RQ|
    开始复制    往来单位信息=PubKSZL|gsdm|N,Xg_RQ|
select *  into #PubKSZL from zw0001.dbo.PubKSZL where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #PubKSZL set gsdm='01'
delete zw0003.dbo.PubKSZL where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.PubKSZL select * from #PubKSZL

    结束复制    往来单位信息=PubKSZL|gsdm|N,Xg_RQ|
    开始复制    职员信息=PubZYXX|gsdm|N,Xg_RQ|
select *  into #PubZYXX from zw0001.dbo.PubZYXX where Xg_RQ like '200812%' and  gsdm=''
BEGIN TRANSACTION
Update #PubZYXX set gsdm='01'
delete zw0003.dbo.PubZYXX where Xg_RQ like '200812%' and  gsdm='01'
insert into zw0003.dbo.PubZYXX select * from #PubZYXX

    结束复制    职员信息=PubZYXX|gsdm|N,Xg_RQ|
    开始复制    项目核算科目=GL_Xmkm|
select *  into #GL_Xmkm from zw0001.dbo.GL_Xmkm
BEGIN TRANSACTION

delete zw0003.dbo.GL_Xmkm
insert into zw0003.dbo.GL_Xmkm select * from #GL_Xmkm

    结束复制    项目核算科目=GL_Xmkm|
    开始复制    往来核算科目=GL_Wlkm|
select *  into #GL_Wlkm from zw0001.dbo.GL_Wlkm
BEGIN TRANSACTION

delete zw0003.dbo.GL_Wlkm
insert into zw0003.dbo.GL_Wlkm select * from #GL_Wlkm

    结束复制    往来核算科目=GL_Wlkm|
    开始复制    科目余额=GL_Kmye|gsdm|Y,,,kjnd|
select *  into #GL_Kmye from zw0001.dbo.GL_Kmye where kjnd='2008' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Kmye set gsdm='01'
delete zw0003.dbo.GL_Kmye where kjnd='2008' and  gsdm='01'
insert into zw0003.dbo.GL_Kmye select * from #GL_Kmye

    结束复制    科目余额=GL_Kmye|gsdm|Y,,,kjnd|
    开始复制    辅助余额=GL_Fzye|gsdm|Y,,,kjnd|
select *  into #GL_Fzye from zw0001.dbo.GL_Fzye where kjnd='2008' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Fzye set gsdm='01'
delete zw0003.dbo.GL_Fzye where kjnd='2008' and  gsdm='01'
insert into zw0003.dbo.GL_Fzye select * from #GL_Fzye

    结束复制    辅助余额=GL_Fzye|gsdm|Y,,,kjnd|
    开始复制    项目累计额=GL_Xmlje|gsdm|Y,,,kjnd|
select *  into #GL_Xmlje from zw0001.dbo.GL_Xmlje where kjnd='2008' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Xmlje set gsdm='01'
delete zw0003.dbo.GL_Xmlje where kjnd='2008' and  gsdm='01'
insert into zw0003.dbo.GL_Xmlje select * from #GL_Xmlje

    结束复制    项目累计额=GL_Xmlje|gsdm|Y,,,kjnd|
    开始复制    凭证目录(凭证登记表)=GL_Pzml|gsdm|Y,,kjqj
select *  into #GL_Pzml from zw0001.dbo.GL_Pzml where kjqj='' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Pzml set gsdm='01'
delete zw0003.dbo.GL_Pzml where kjqj='' and  gsdm='01'
insert into zw0003.dbo.GL_Pzml select * from #GL_Pzml

    结束复制    凭证目录(凭证登记表)=GL_Pzml|gsdm|Y,,kjqj
    开始复制    凭证内容（分录信息)=GL_Pznr|gsdm|Y,,kjqj
select *  into #GL_Pznr from zw0001.dbo.GL_Pznr where kjqj='' and  gsdm=''
BEGIN TRANSACTION
Update #GL_Pznr set gsdm='01'
delete zw0003.dbo.GL_Pznr

MONING

汇总时的软件图景