回答編集履歴
2
もう一度訂正
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
FROM TEMP_DATE
|
18
18
|
|
19
|
-
WHERE DATEDIFF(day,
|
19
|
+
WHERE DATEDIFF(day, '2018/03/03', 日付) < 100 -1
|
20
20
|
|
21
21
|
)
|
22
22
|
|
1
SQL訂正
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
FROM TEMP_DATE
|
18
18
|
|
19
|
-
WHERE 日付
|
19
|
+
WHERE DATEDIFF(day, 日付, '2018/03/03') < 100
|
20
20
|
|
21
21
|
)
|
22
22
|
|
@@ -28,4 +28,6 @@
|
|
28
28
|
|
29
29
|
FROM TEMP_DATE
|
30
30
|
|
31
|
+
OPTION (MAXRECURSION 0)
|
32
|
+
|
31
33
|
```
|