質問編集履歴
1
一部修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -170,11 +170,11 @@
|
|
|
170
170
|
|
|
171
171
|
|3|パンC|DH-52R-45|完了|2021-08-03 09:00:00|2021-08-03 08:01:09|2|2|
|
|
172
172
|
|
|
173
|
-
|4|パンC|DH-52R-45|未納|2021-08-04 09:00:00|NULL|
|
|
173
|
+
|4|パンC|DH-52R-45|未納|2021-08-04 09:00:00|NULL|1||
|
|
174
174
|
|
|
175
175
|
|5|パンA|TH-123456|完了|2021-08-02 17:00:00|2021-08-02 16:01:09|1|1|
|
|
176
176
|
|
|
177
|
-
|6|パンA|TH-123456|未納|2021-08-03 17:00:00|NULL|
|
|
177
|
+
|6|パンA|TH-123456|未納|2021-08-03 17:00:00|NULL|2||
|
|
178
178
|
|
|
179
179
|
|
|
180
180
|
|
|
@@ -260,7 +260,7 @@
|
|
|
260
260
|
|
|
261
261
|
WHERE [納入状況] = '完了' And [完了日時] >= '2021-08-01'
|
|
262
262
|
|
|
263
|
-
GROUP BY CONVERT (varchar,dateadd(HOUR,-8.5,[納入完了日]),111),[品
|
|
263
|
+
GROUP BY CONVERT (varchar,dateadd(HOUR,-8.5,[納入完了日]),111),[商品コード]
|
|
264
264
|
|
|
265
265
|
|
|
266
266
|
|