回答編集履歴
2
文章修正
test
CHANGED
|
@@ -86,9 +86,11 @@
|
|
|
86
86
|
|
|
87
87
|
**********************************************************/
|
|
88
88
|
|
|
89
|
+
|
|
90
|
+
|
|
89
|
-
[一時_日付範囲] AS
|
|
91
|
+
[一時_日付範囲_前日] AS
|
|
90
|
-
|
|
92
|
+
|
|
91
|
-
(SELECT TOP 7 [年月日] FROM
|
|
93
|
+
(SELECT TOP 7 CAST(CONVERT(VARCHAR,DATEADD(DAY,-1,CONVERT(DATETIME,CAST([年月日] AS VARCHAR),112)),112) AS NUMERIC(8,0)) AS [年月日] FROM
|
|
92
94
|
|
|
93
95
|
(SELECT TOP 7 [年月日] FROM [T].[DB].[受注残] GROUP BY [年月日] ORDER BY [年月日] DESC
|
|
94
96
|
|
|
@@ -104,24 +106,6 @@
|
|
|
104
106
|
|
|
105
107
|
|
|
106
108
|
|
|
107
|
-
[一時_日付範囲_前日] AS
|
|
108
|
-
|
|
109
|
-
(SELECT TOP 7 CAST(CONVERT(VARCHAR,DATEADD(DAY,-1,CONVERT(DATETIME,CAST([年月日] AS VARCHAR),112)),112) AS NUMERIC(8,0)) AS [年月日] FROM
|
|
110
|
-
|
|
111
|
-
(SELECT TOP 7 [年月日] FROM [T].[DB].[受注残] GROUP BY [年月日] ORDER BY [年月日] DESC
|
|
112
|
-
|
|
113
|
-
UNION
|
|
114
|
-
|
|
115
|
-
SELECT TOP 7 [年月日] FROM [T].[DB].[地区在] GROUP BY [年月日] ORDER BY [年月日] DESC
|
|
116
|
-
|
|
117
|
-
) X
|
|
118
|
-
|
|
119
|
-
ORDER BY [年月日] DESC
|
|
120
|
-
|
|
121
|
-
),
|
|
122
|
-
|
|
123
|
-
|
|
124
|
-
|
|
125
109
|
W_日付(Val,年月日,年月) AS(
|
|
126
110
|
|
|
127
111
|
SELECT CAST(DATEADD(DAY,-1,@EXEC_DATETIME ) AS DATE), CAST(CONVERT(NVARCHAR(10), DATEADD(DAY,-1,@EXEC_DATETIME ), 112) AS NUMERIC(8,0)), CAST(CONCAT(SUBSTRING(CONVERT(NVARCHAR(10), DATEADD(DAY,-1,@EXEC_DATETIME ), 112), 1, 6),'00') AS NUMERIC(8,0))
|
1
文章修正
test
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
|
|
3
3
|
昨日は多忙で返信を行うことができませんでした。
|
|
4
4
|
|
|
5
|
-
当方側で一応解決にこぎつけ
|
|
5
|
+
当方側で一応解決にこぎつけた（詳しい方に助力した）ので、対応SQLなどを報告させていただきます。
|
|
6
6
|
|
|
7
7
|
やはりまた自分が勘違いしていた仕様が多かったことで、後だし的な説明になってしまうことをご了承下さい。
|
|
8
8
|
|