回答編集履歴
2
条件が成立するときに設定する値の修正
answer
CHANGED
|
@@ -42,7 +42,7 @@
|
|
|
42
42
|
SET @sql2 = @sql2
|
|
43
43
|
+ " ,CASE WHEN arrivalTime"
|
|
44
44
|
+ " BETWEEN '" + @start + "' AND '" + @end + "'"
|
|
45
|
-
+ " THEN
|
|
45
|
+
+ " THEN energy"
|
|
46
46
|
+ " ELSE 0"
|
|
47
47
|
+ " END AS '" + @start + "'"
|
|
48
48
|
END
|
|
@@ -51,7 +51,7 @@
|
|
|
51
51
|
SET @sql3 = @sql3
|
|
52
52
|
+ " ,CASE WHEN arrivalTime"
|
|
53
53
|
+ " BETWEEN '" + @start + "' AND '" + @end + "'"
|
|
54
|
-
+ " THEN
|
|
54
|
+
+ " THEN energy"
|
|
55
55
|
+ " ELSE 0"
|
|
56
56
|
+ " END AS '" + @start + "'"
|
|
57
57
|
END
|
|
@@ -60,7 +60,7 @@
|
|
|
60
60
|
SET @sql4 = @sql4
|
|
61
61
|
+ " ,CASE WHEN arrivalTime"
|
|
62
62
|
+ " BETWEEN '" + @start + "' AND '" + @end + "'"
|
|
63
|
-
+ " THEN
|
|
63
|
+
+ " THEN energy"
|
|
64
64
|
+ " ELSE 0"
|
|
65
65
|
+ " END AS '" + @start + "'"
|
|
66
66
|
END
|
|
@@ -69,7 +69,7 @@
|
|
|
69
69
|
SET @sql5 = @sql5
|
|
70
70
|
+ " ,CASE WHEN arrivalTime"
|
|
71
71
|
+ " BETWEEN '" + @start + "' AND '" + @end + "'"
|
|
72
|
-
+ " THEN
|
|
72
|
+
+ " THEN energy"
|
|
73
73
|
+ " ELSE 0"
|
|
74
74
|
+ " END AS '" + @start + "'"
|
|
75
75
|
END
|
1
重なり部分を両方に出す場合の記述を追加
answer
CHANGED
|
@@ -34,6 +34,9 @@
|
|
|
34
34
|
+ RIGHT("00" + CAST(@min AS VARCHAR), 2)
|
|
35
35
|
SET @end = RIGHT("00" + CAST(@hour AS VARCHAR), 2) + ":"
|
|
36
36
|
+ RIGHT("00" + CAST(@min + 9 AS VARCHAR), 2)
|
|
37
|
+
-- 時間の重なっている部分を両方に出すならこちら
|
|
38
|
+
-- SET @end = RIGHT("00" + CAST(@hour AS VARCHAR), 2) + ":"
|
|
39
|
+
-- + RIGHT("00" + CAST((@min + 10) % 60 AS VARCHAR), 2)
|
|
37
40
|
IF @hour < 6
|
|
38
41
|
BEGIN
|
|
39
42
|
SET @sql2 = @sql2
|