【应收账款】切换新数据库

DELETE FROM YSDJ
DELETE FROM XDMX
DELETE FROM DZMX
DELETE FROM DZCY
DELETE FROM FPMX
DELETE FROM SKDMX
DELETE FROM SKMX
DELETE FROM JEMX
DELETE FROM LSFP
DELETE FROM LSTABLE
DELETE FROM HZMX

 

insert into yszk2..ysdj(xsdh,dwid,jzrq,ysje,qrbz,dzbz,drrq,beizhu)
select xsdh,dwid,jzrq,ysje,qrbz,dzbz,drrq,beizhu from ysdj where dzbz=0 and qrbz!=2

insert into yszk2..ysdj(xsdh,dwid,jzrq,ysje,qrbz,dzbz,drrq,beizhu)
select xsdh,dwid,jzrq,ysje,qrbz,'1',drrq,beizhu from ysdj where dzbz=0 and qrbz=2

insert into yszk2..ysdj(xsdh,dwid,jzrq,ysje,qrbz,dzbz,drrq,beizhu)
select xsdh,dwid,jzrq,ysje,qrbz,dzbz,drrq,beizhu from ysdj where dzbz=1

insert into yszk2..ysdj(xsdh,dwid,jzrq,ysje,qrbz,dzbz,drrq,beizhu)
select xdh,dwid,jzrq,ysje,qrbz,dzbz,qrrq,beizhu from xdmx where dzbz=0 and qrbz!=2

insert into yszk2..fpmx(dzdh,dwid,zs,fplx,beizhu,fptt,fphm,fpje,skbz)
select dzdh,dwid,zs,fplx,kpdw,fptt,fphm,fpje,skbz from fpmx where skbz=0


INSERT INTO  yszk2..DZMX( DZDH,DWID,ZS,XSDH,DZRQ)
SELECT DZDH,DWID,ZS,XSDH,DZRQ  FROM DZMX WHERE DZDH IN (
SELECT DISTINCT dzdh from fpmx where skbz=0 )

INSERT INTO yszk2..DZCY(DWID,SFDH,JE,RQ)
select DWID,DZDH,CYJE,DZRQ from dzcy where dzdh in (
SELECT DISTINCT dzdh from fpmx where skbz=0 )

INSERT INTO yszk2..JEMX(DWID,SFDH,RQ,JE)
SELECT DISTINCT B.DWID,B.DZDH,B.DZRQ,SUM(A.YSJE) FROM  YSDJ A, (SELECT DWID,DZDH,XSDH,DZRQ  FROM DZMX WHERE DZDH IN (SELECT DISTINCT dzdh from fpmx where skbz=0 ) ) B
WHERE A.XSDH=B.XSDH  GROUP BY DZDH,B.DWID,B.DZRQ


delete from ysdj where xsdh in(
select xsdh from ysdj group by xsdh having count(*)>1) and drrq='2014-10-14 16:40:05.900'

update ysdj set xsdh='22'+replace(replace(replace(CONVERT(varchar, drrq, 120 ),'-',''),' ',''),':','') where xsdh in(
select xsdh from ysdj group by xsdh having count(*)>1)


select * from ysdj where xsdh in(
select xsdh from ysdj group by xsdh having count(*)>1)  order by drrq