From 43f958768f63e08c7b20b6da720f10063a77f008 Mon Sep 17 00:00:00 2001 From: dubin <bindu_bean@163.com> Date: 星期日, 22 三月 2026 10:40:55 +0800 Subject: [PATCH] 入库提示无可用堆垛机 --- src/main/java/asr_show_diff.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/asr_show_diff.sql b/src/main/java/asr_show_diff.sql index 4282ce4..714621a 100644 --- a/src/main/java/asr_show_diff.sql +++ b/src/main/java/asr_show_diff.sql @@ -41,7 +41,7 @@ itembatch AS batch, itemSpc specs FROM - ( SELECT * FROM OPENROWSET ( 'SQLOLEDB', '192.168.1.147,1800'; 'XGMLK'; 'xunda0413', XDLinkLK.dbo.vwErpLKStorage ) WHERE LKName = '涓壃浜屾湡' ) a + ( SELECT * FROM OPENROWSET ( 'SQLOLEDB', '192.168.1.147,1800'; 'XGMLK'; 'xunda0413', XDLinkLK.dbo.vwErpLKStorage ) WHERE LKName = '楂橀湒绔嬪簱' ) a GROUP BY itemid, itemcode, -- Gitblit v1.9.1