
SPH00000562发现结转数量少了90
–查自身结转数量是否不正确select shqjzhshl,cwjcsl+cksl-bqrsh,bqrsh-cksl, from ymjzhk where spid=’SPH00000562′ order...
–查自身结转数量是否不正确select shqjzhshl,cwjcsl+cksl-bqrsh,bqrsh-cksl, from ymjzhk where spid=’SPH00000562′ order...
select IDENTITY(INT,1,1) AS 序号,* into #a1 from spkfkdjok select ‘XJPZ’+right(‘00000’+cast(xuhao ...
部门品种客户销售情况分析去物流 select c.spid,c.djbh,c.rq,a.spbh,a.spmch,a.shpgg,a.dw,a.jlgg,a.shengccj,a.shpchd,b.danwbh,b.dwmch,b.quyu...
erp下传 update wms_jxddhz set wmflg=’N’ where wmflg in (‘E’,’T’) and rq>’2017...
C:\KSOAWS\tomcat\webapps\ROOT\WEB-INF\classes proxool C:\KSOAWS\tomcat\conf server C:\KSOAWS\tomcat\bin startup 环境变量 JAV...
select a.spid,d.spbh,d.spmch,d.shpgg,d.dw,d.shpchd,a.kcshl,a.kcje,b.hwshl,b.hwje,c.pcshl,c.pcje from spkfjc a left join ...