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
C:\KSOAWS\tomcat\webapps\ROOT\WEB-INF\classesproxoolC:\KSOAWS\tomcat\confserverC:\KSOAWS\tomcat\bins
erp下傳update wms_jxddhz set wmflg='N' where wmflg in ('E','T') and rq>'2017-08-01'update wms_pf_dj
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMINtnsnamesORCL = (DESCRIPTION =
部門品種客戶銷售情況分析去物流select c.spid,c.djbh,c.rq,a.spbh,a.spmch,a.shpgg,a.dw,a.jlgg,a.shengccj,a.shpchd,b.da
select IDENTITY(INT,1,1) AS 序號,* into #a1 from spkfkdjokselect 'XJPZ'+right('00000'+cast(xuhao as nv
--查自身結(jié)轉(zhuǎn)數(shù)量是否不正確select shqjzhshl,cwjcsl+cksl-bqrsh,bqrsh-cksl, from ymjzhk where spid='SPH00000562' o