From c3eed248a6c8d9a4a445f8b0be8f3f306785b3ea Mon Sep 17 00:00:00 2001
From: zc <zc>
Date: 星期三, 31 七月 2024 17:56:25 +0800
Subject: [PATCH] 视图

---
 src/main/java/asr_show_diff.sql |   31 ++++++++++++++++---------------
 1 files changed, 16 insertions(+), 15 deletions(-)

diff --git a/src/main/java/asr_show_diff.sql b/src/main/java/asr_show_diff.sql
index 35e983a..4282ce4 100644
--- a/src/main/java/asr_show_diff.sql
+++ b/src/main/java/asr_show_diff.sql
@@ -3,21 +3,23 @@
 	SUM ( erpQty ) erpQty,
 	matnr,
 	maktx,
-	pgNo,
-	outOrderNo,
-	batch,
-	model ,specs
+	MIN ( pgNo ) pgNo,
+	MIN ( outOrderNo ) outOrderNo,
+	MIN ( batch ) batch,
+	model,
+	MIN ( specs ) specs
 FROM
 	(
 	SELECT CAST
 		( SUM ( anfme ) AS INT ) asrsQty,
-		0 AS erpQty,
-		matnr,
+		0 AS erpQty,	matnr,
 		model,
+
 		maktx,
 		pg_no AS pgNo,
 		out_order_no AS outOrderNo,
-		batch ,specs
+		batch,
+		specs
 	FROM
 		asr_loc_detl
 	GROUP BY
@@ -26,7 +28,8 @@
 		pg_no,
 		out_order_no,
 		batch,
-		model,specs UNION ALL
+		model,
+		specs UNION ALL
 	SELECT
 		0,
 		CAST ( SUM ( numis ) AS INT ),
@@ -35,15 +38,16 @@
 		itemname,
 		'' AS pgNo,
 		'' AS outOrderNo,
-		itembatch AS batch
-		,itemSpc specs
+		itembatch AS batch,
+		itemSpc specs
 	FROM
 		( SELECT * FROM OPENROWSET ( 'SQLOLEDB', '192.168.1.147,1800'; 'XGMLK'; 'xunda0413', XDLinkLK.dbo.vwErpLKStorage ) WHERE LKName = '涓壃浜屾湡' ) a
 	GROUP BY
 		itemid,
 		itemcode,
 		itemname,
-		itembatch ,itemSpc
+		itembatch,
+		itemSpc
 	) b
 WHERE
 	1 = 1
@@ -51,7 +55,4 @@
 GROUP BY
 	matnr,
 	model,
-	maktx,
-	pgNo,
-	outOrderNo,
-	batch,specs
\ No newline at end of file
+	maktx
\ No newline at end of file

--
Gitblit v1.9.1