LQ XSTH重复出问题，XSCK开出去，手工插入数据SQL

最新推荐文章于 2022-10-28 08:46:10 发布

NO66781

最新推荐文章于 2022-10-28 08:46:10 发布

阅读量1.1k

点赞数

分类专栏： MSSQL

本文链接：https://blog.csdn.net/NO66781/article/details/89706258

版权

MSSQL 专栏收录该内容

17 篇文章 1 订阅

订阅专栏

INSERT INTO Pass_出库返回接口表_wait
            (物流中心,出库类型,货主,通知单号,通知单行号,货品编号,批号,灭菌批号,库类型,_date,出库数量,差异数量,开票数量,出库日期,货品名称,有效期至,生产日期,时间,包装,完成状态,任务行数,is_zx)

SELECT '1' AS 物流中心,'11' AS 出库类型,'010006' AS 货主,a.djbh AS 通知单号
      ,b.dj_sort AS 通知单行号,c.spbh AS 货品编号,b.pihao AS 批号,'' AS 灭菌批号,'1' AS 库类型
      ,CONVERT(CHAR(19),GETDATE(),120) AS _date,b.shl AS 出库数量,0 AS 差异数量,b.shl AS 开票数量
      ,CONVERT(CHAR(19),GETDATE(),120) AS 出库日期,c.spmch AS 货品名称,b.baozhiqi AS 有效期至,b.sxrq AS 生产日期
      ,CONVERT(CHAR(19),GETDATE(),120) AS 时间,c.jlgg AS 包装,'1' AS 完成状态,'2' AS 任务行数,'' AS is_zx
FROM lqksoanew.dbo.jzorder_hz AS a
     INNER JOIN lqksoanew.dbo.jzorder_mx AS b ON a.djbh = b.djbh
     INNER JOIN lqksoanew.dbo.spkfk AS c ON b.spid = c.spid 
WHERE a.djbh='XSGZDA00000351'