query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
41.0704 |
2024-06-06 00:00:00.0 |
6.6594 |
233 |
2 |
46.8069 |
2024-06-07 00:00:00.0 |
5.7365 |
233 |
3 |
52.1355 |
2024-06-08 00:00:00.0 |
5.3286 |
233 |
4 |
56.2628 |
2024-06-09 00:00:00.0 |
4.1273 |
233 |
5 |
60.4906 |
2024-06-10 00:00:00.0 |
4.2278 |
233 |
6 |
68.6374 |
2024-06-11 00:00:00.0 |
8.1468 |
233 |
7 |
76.4602 |
2024-06-12 00:00:00.0 |
7.8228 |
233 |
8 |
83.6555 |
2024-06-13 00:00:00.0 |
7.1953 |
233 |
9 |
91.6572 |
2024-06-14 00:00:00.0 |
8.0017 |
233 |
10 |
100.2417 |
2024-06-15 00:00:00.0 |
8.5845 |
233 |
11 |
108.2914 |
2024-06-16 00:00:00.0 |
8.0497 |
233 |
12 |
113.3857 |
2024-06-17 00:00:00.0 |
5.0943 |
233 |
13 |
118.6251 |
2024-06-18 00:00:00.0 |
5.2394 |
233 |
14 |
123.6163 |
2024-06-19 00:00:00.0 |
4.9912 |
233 |
15 |
130.6235 |
2024-06-20 00:00:00.0 |
7.0072 |
233 |
16 |
139.5246 |
2024-06-21 00:00:00.0 |
8.9011 |
233 |
17 |
147.9245 |
2024-06-22 00:00:00.0 |
8.3999 |
233 |
18 |
156.0042 |
2024-06-23 00:00:00.0 |
8.0797 |
233 |
19 |
165.1129 |
2024-06-24 00:00:00.0 |
9.1087 |
233 |
20 |
173.6834 |
2024-06-25 00:00:00.0 |
8.5705 |
233 |
21 |
182.2539 |
2024-06-26 00:00:00.0 |
8.5705 |
233 |
22 |
190.8244 |
2024-06-27 00:00:00.0 |
8.5705 |
233 |
23 |
199.3949 |
2024-06-28 00:00:00.0 |
8.5705 |
233 |
24 |
207.9654 |
2024-06-29 00:00:00.0 |
8.5705 |
233 |
25 |
216.5359 |
2024-06-30 00:00:00.0 |
8.5705 |
233 |
26 |
225.1064 |
2024-07-01 00:00:00.0 |
8.5705 |
233 |
27 |
233.6769 |
2024-07-02 00:00:00.0 |
8.5705 |
233 |
28 |
242.2474 |
2024-07-03 00:00:00.0 |
8.5705 |
233 |
29 |
250.8179 |
2024-07-04 00:00:00.0 |
8.5705 |
233 |
30 |
259.3884 |
2024-07-05 00:00:00.0 |
8.5705 |
233 |
31 |
267.9589 |
2024-07-06 00:00:00.0 |
8.5705 |
233 |
32 |
276.5294 |
2024-07-07 00:00:00.0 |
8.5705 |
233 |
33 |
285.0999 |
2024-07-08 00:00:00.0 |
8.5705 |
233 |
34 |
293.6704 |
2024-07-09 00:00:00.0 |
8.5705 |
233 |
35 |
302.2409 |
2024-07-10 00:00:00.0 |
8.5705 |
233 |
36 |
310.8114 |
2024-07-11 00:00:00.0 |
8.5705 |
233 |
37 |
319.3819 |
2024-07-12 00:00:00.0 |
8.5705 |
233 |
38 |
327.9524 |
2024-07-13 00:00:00.0 |
8.5705 |
233 |
39 |
336.5229 |
2024-07-14 00:00:00.0 |
8.5705 |
233 |
40 |
345.0934 |
2024-07-15 00:00:00.0 |
8.5705 |
233 |
41 |
353.6639 |
2024-07-16 00:00:00.0 |
8.5705 |
233 |
42 |
362.2344 |
2024-07-17 00:00:00.0 |
8.5705 |
233 |
43 |
370.8049 |
2024-07-18 00:00:00.0 |
8.5705 |
233 |
44 |
379.3754 |
2024-07-19 00:00:00.0 |
8.5705 |
233 |
45 |
387.9459 |
2024-07-20 00:00:00.0 |
8.5705 |
233 |
46 |
396.5164 |
2024-07-21 00:00:00.0 |
8.5705 |
233 |
47 |
405.0869 |
2024-07-22 00:00:00.0 |
8.5705 |
233 |
48 |
413.6574 |
2024-07-23 00:00:00.0 |
8.5705 |
233 |
49 |
422.2279 |
2024-07-24 00:00:00.0 |
8.5705 |
233 |
50 |
430.7984 |
2024-07-25 00:00:00.0 |
8.5705 |
233 |
51 |
439.3689 |
2024-07-26 00:00:00.0 |
8.5705 |
233 |
52 |
447.9394 |
2024-07-27 00:00:00.0 |
8.5705 |
233 |
53 |
456.5099 |
2024-07-28 00:00:00.0 |
8.5705 |
233 |
54 |
465.0804 |
2024-07-29 00:00:00.0 |
8.5705 |
233 |
55 |
473.6509 |
2024-07-30 00:00:00.0 |
8.5705 |
233 |
56 |
482.2214 |
2024-07-31 00:00:00.0 |
8.5705 |
233 |
57 |
490.7919 |
2024-08-01 00:00:00.0 |
8.5705 |
233 |
58 |
499.3624 |
2024-08-02 00:00:00.0 |
8.5705 |
233 |
59 |
507.9329 |
2024-08-03 00:00:00.0 |
8.5705 |
233 |
60 |
516.5034 |
2024-08-04 00:00:00.0 |
8.5705 |
233 |
61 |
525.0739 |
2024-08-05 00:00:00.0 |
8.5705 |
233 |
62 |
533.6444 |
2024-08-06 00:00:00.0 |
8.5705 |
233 |
63 |
542.2149 |
2024-08-07 00:00:00.0 |
8.5705 |
233 |
64 |
550.7854 |
2024-08-08 00:00:00.0 |
8.5705 |
233 |
65 |
559.3559 |
2024-08-09 00:00:00.0 |
8.5705 |
233 |
66 |
567.9264 |
2024-08-10 00:00:00.0 |
8.5705 |
233 |
67 |
576.4969 |
2024-08-11 00:00:00.0 |
8.5705 |
233 |
68 |
585.0674 |
2024-08-12 00:00:00.0 |
8.5705 |
233 |
69 |
593.6379 |
2024-08-13 00:00:00.0 |
8.5705 |
233 |
70 |
602.2084 |
2024-08-14 00:00:00.0 |
8.5705 |
233 |
71 |
610.7789 |
2024-08-15 00:00:00.0 |
8.5705 |
233 |
72 |
619.3494 |
2024-08-16 00:00:00.0 |
8.5705 |
233 |
73 |
627.9199 |
2024-08-17 00:00:00.0 |
8.5705 |
233 |
74 |
636.4904 |
2024-08-18 00:00:00.0 |
8.5705 |
233 |
75 |
645.0609 |
2024-08-19 00:00:00.0 |
8.5705 |
233 |
76 |
653.6314 |
2024-08-20 00:00:00.0 |
8.5705 |
233 |
77 |
662.2019 |
2024-08-21 00:00:00.0 |
8.5705 |
233 |
78 |
670.7724 |
2024-08-22 00:00:00.0 |
8.5705 |
233 |
79 |
679.3429 |
2024-08-23 00:00:00.0 |
8.5705 |
233 |
80 |
687.9134 |
2024-08-24 00:00:00.0 |
8.5705 |
233 |
81 |
696.4839 |
2024-08-25 00:00:00.0 |
8.5705 |
233 |
82 |
705.0544 |
2024-08-26 00:00:00.0 |
8.5705 |
233 |
83 |
713.6249 |
2024-08-27 00:00:00.0 |
8.5705 |
233 |
84 |
722.1954 |
2024-08-28 00:00:00.0 |
8.5705 |
233 |
85 |
730.7659 |
2024-08-29 00:00:00.0 |
8.5705 |
233 |
86 |
739.3364 |
2024-08-30 00:00:00.0 |
8.5705 |
233 |
87 |
747.9069 |
2024-08-31 00:00:00.0 |
8.5705 |
233 |
88 |
756.4774 |
2024-09-01 00:00:00.0 |
8.5705 |
233 |
89 |
765.0479 |
2024-09-02 00:00:00.0 |
8.5705 |
233 |
90 |
773.6184 |
2024-09-03 00:00:00.0 |
8.5705 |
233 |
91 |
782.1889 |
2024-09-04 00:00:00.0 |
8.5705 |
233 |
92 |
790.7594 |
2024-09-05 00:00:00.0 |
8.5705 |
233 |
93 |
799.3299 |
2024-09-06 00:00:00.0 |
8.5705 |
233 |
94 |
807.9004 |
2024-09-07 00:00:00.0 |
8.5705 |
233 |
95 |
816.4709 |
2024-09-08 00:00:00.0 |
8.5705 |
233 |
96 |
825.0414 |
2024-09-09 00:00:00.0 |
8.5705 |
233 |
97 |
833.6119 |
2024-09-10 00:00:00.0 |
8.5705 |
233 |
98 |
842.1824 |
2024-09-11 00:00:00.0 |
8.5705 |
233 |
99 |
850.7529 |
2024-09-12 00:00:00.0 |
8.5705 |
233 |
100 |
859.3234 |
2024-09-13 00:00:00.0 |
8.5705 |
233 |
101 |
867.8939 |
2024-09-14 00:00:00.0 |
8.5705 |
233 |
102 |
876.4644 |
2024-09-15 00:00:00.0 |
8.5705 |
233 |
103 |
885.0349 |
2024-09-16 00:00:00.0 |
8.5705 |
233 |
104 |
893.6054 |
2024-09-17 00:00:00.0 |
8.5705 |
233 |
105 |
902.1759 |
2024-09-18 00:00:00.0 |
8.5705 |
233 |
106 |
910.7464 |
2024-09-19 00:00:00.0 |
8.5705 |
233 |
107 |
919.3169 |
2024-09-20 00:00:00.0 |
8.5705 |
233 |
108 |
927.8874 |
2024-09-21 00:00:00.0 |
8.5705 |
233 |
109 |
936.4579 |
2024-09-22 00:00:00.0 |
8.5705 |
233 |
110 |
945.0284 |
2024-09-23 00:00:00.0 |
8.5705 |
233 |
111 |
953.5989 |
2024-09-24 00:00:00.0 |
8.5705 |
233 |
112 |
962.1694 |
2024-09-25 00:00:00.0 |
8.5705 |
233 |
113 |
970.7399 |
2024-09-26 00:00:00.0 |
8.5705 |
233 |
114 |
979.3104 |
2024-09-27 00:00:00.0 |
8.5705 |
233 |
115 |
987.8809 |
2024-09-28 00:00:00.0 |
8.5705 |
233 |
116 |
996.4514 |
2024-09-29 00:00:00.0 |
8.5705 |
233 |
117 |
1005.0219 |
2024-09-30 00:00:00.0 |
8.5705 |
233 |
118 |
1013.5924 |
2024-10-01 00:00:00.0 |
8.5705 |
233 |
119 |
1022.1629 |
2024-10-02 00:00:00.0 |
8.5705 |
233 |
120 |
1030.7334 |
2024-10-03 00:00:00.0 |
8.5705 |
233 |
121 |
1039.3039 |
2024-10-04 00:00:00.0 |
8.5705 |
233 |
122 |
1047.8744 |
2024-10-05 00:00:00.0 |
8.5705 |
233 |
123 |
1056.4449 |
2024-10-06 00:00:00.0 |
8.5705 |
233 |
124 |
1065.0154 |
2024-10-07 00:00:00.0 |
8.5705 |
233 |
125 |
1073.5859 |
2024-10-08 00:00:00.0 |
8.5705 |
233 |
126 |
1082.1564 |
2024-10-09 00:00:00.0 |
8.5705 |
233 |
127 |
1090.7269 |
2024-10-10 00:00:00.0 |
8.5705 |
233 |
128 |
1099.2974 |
2024-10-11 00:00:00.0 |
8.5705 |
233 |
129 |
1107.8679 |
2024-10-12 00:00:00.0 |
8.5705 |
233 |
130 |
1116.4384 |
2024-10-13 00:00:00.0 |
8.5705 |
233 |
131 |
1125.0089 |
2024-10-14 00:00:00.0 |
8.5705 |
233 |
132 |
1133.5794 |
2024-10-15 00:00:00.0 |
8.5705 |
233 |
133 |
1142.1499 |
2024-10-16 00:00:00.0 |
8.5705 |
233 |
134 |
1150.7204 |
2024-10-17 00:00:00.0 |
8.5705 |
233 |
135 |
1159.2909 |
2024-10-18 00:00:00.0 |
8.5705 |
233 |
136 |
1167.8614 |
2024-10-19 00:00:00.0 |
8.5705 |
233 |
137 |
1176.4319 |
2024-10-20 00:00:00.0 |
8.5705 |
233 |
138 |
1185.0024 |
2024-10-21 00:00:00.0 |
8.5705 |
233 |
139 |
1193.5729 |
2024-10-22 00:00:00.0 |
8.5705 |
233 |
140 |
1202.1434 |
2024-10-23 00:00:00.0 |
8.5705 |
233 |
141 |
1210.7139 |
2024-10-24 00:00:00.0 |
8.5705 |
233 |
142 |
1219.2844 |
2024-10-25 00:00:00.0 |
8.5705 |
233 |
143 |
1227.8549 |
2024-10-26 00:00:00.0 |
8.5705 |
233 |
144 |
1236.4254 |
2024-10-27 00:00:00.0 |
8.5705 |
233 |
145 |
1244.9959 |
2024-10-28 00:00:00.0 |
8.5705 |
233 |
146 |
1253.5664 |
2024-10-29 00:00:00.0 |
8.5705 |
233 |
|
CACHED |
false |
EXECUTIONTIME |
15 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '233') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'}
ORDER BY ddate ASC |