query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.6791 |
2025-06-01 00:00:00.0 |
7.6791 |
237 |
2 |
14.4542 |
2025-06-02 00:00:00.0 |
6.7751 |
237 |
3 |
23.1220 |
2025-06-03 00:00:00.0 |
8.6678 |
237 |
4 |
31.5012 |
2025-06-04 00:00:00.0 |
8.3792 |
237 |
5 |
38.2942 |
2025-06-05 00:00:00.0 |
6.7930 |
237 |
6 |
43.7613 |
2025-06-06 00:00:00.0 |
5.4671 |
237 |
7 |
50.9950 |
2025-06-07 00:00:00.0 |
7.2337 |
237 |
8 |
59.4696 |
2025-06-08 00:00:00.0 |
8.4746 |
237 |
9 |
64.4374 |
2025-06-09 00:00:00.0 |
4.9678 |
237 |
10 |
69.2340 |
2025-06-10 00:00:00.0 |
4.7966 |
237 |
11 |
76.8099 |
2025-06-11 00:00:00.0 |
7.5759 |
237 |
12 |
83.7372 |
2025-06-12 00:00:00.0 |
6.9273 |
237 |
13 |
90.6297 |
2025-06-13 00:00:00.0 |
6.8925 |
237 |
14 |
97.5306 |
2025-06-14 00:00:00.0 |
6.9009 |
237 |
15 |
104.5255 |
2025-06-15 00:00:00.0 |
6.9949 |
237 |
16 |
112.2656 |
2025-06-16 00:00:00.0 |
7.7401 |
237 |
17 |
121.5445 |
2025-06-17 00:00:00.0 |
9.2789 |
237 |
18 |
130.3397 |
2025-06-18 00:00:00.0 |
8.7952 |
237 |
19 |
138.6983 |
2025-06-19 00:00:00.0 |
8.3586 |
237 |
20 |
146.9084 |
2025-06-20 00:00:00.0 |
8.2101 |
237 |
21 |
154.5586 |
2025-06-21 00:00:00.0 |
7.6502 |
237 |
22 |
163.5399 |
2025-06-22 00:00:00.0 |
8.9813 |
237 |
23 |
172.2683 |
2025-06-23 00:00:00.0 |
8.7284 |
237 |
24 |
178.9207 |
2025-06-24 00:00:00.0 |
6.6524 |
237 |
25 |
184.6412 |
2025-06-25 00:00:00.0 |
5.7205 |
237 |
26 |
192.2654 |
2025-06-26 00:00:00.0 |
7.6242 |
237 |
27 |
201.1096 |
2025-06-27 00:00:00.0 |
8.8442 |
237 |
28 |
208.7769 |
2025-06-28 00:00:00.0 |
7.6673 |
237 |
29 |
215.6438 |
2025-06-29 00:00:00.0 |
6.8669 |
237 |
30 |
224.6550 |
2025-06-30 00:00:00.0 |
9.0112 |
237 |
31 |
233.2196 |
2025-07-01 00:00:00.0 |
8.5646 |
237 |
32 |
241.4683 |
2025-07-02 00:00:00.0 |
8.2487 |
237 |
33 |
250.0106 |
2025-07-03 00:00:00.0 |
8.5423 |
237 |
34 |
257.3059 |
2025-07-04 00:00:00.0 |
7.2953 |
237 |
35 |
263.8178 |
2025-07-05 00:00:00.0 |
6.5119 |
237 |
36 |
272.8618 |
2025-07-06 00:00:00.0 |
9.0440 |
237 |
37 |
281.1855 |
2025-07-07 00:00:00.0 |
8.3237 |
237 |
38 |
288.8762 |
2025-07-08 00:00:00.0 |
7.6907 |
237 |
39 |
296.9360 |
2025-07-09 00:00:00.0 |
8.0598 |
237 |
40 |
304.5637 |
2025-07-10 00:00:00.0 |
7.6277 |
237 |
41 |
311.8402 |
2025-07-11 00:00:00.0 |
7.2765 |
237 |
42 |
321.2682 |
2025-07-12 00:00:00.0 |
9.4280 |
237 |
43 |
329.9458 |
2025-07-13 00:00:00.0 |
8.6776 |
237 |
44 |
338.7388 |
2025-07-14 00:00:00.0 |
8.7930 |
237 |
45 |
347.9671 |
2025-07-15 00:00:00.0 |
9.2283 |
237 |
46 |
355.0686 |
2025-07-16 00:00:00.0 |
7.1015 |
237 |
47 |
361.8931 |
2025-07-17 00:00:00.0 |
6.8245 |
237 |
48 |
368.9198 |
2025-07-18 00:00:00.0 |
7.0267 |
237 |
49 |
376.5945 |
2025-07-19 00:00:00.0 |
7.6747 |
237 |
50 |
385.0056 |
2025-07-20 00:00:00.0 |
8.4111 |
237 |
51 |
393.0387 |
2025-07-21 00:00:00.0 |
8.0331 |
237 |
52 |
401.2194 |
2025-07-22 00:00:00.0 |
8.1807 |
237 |
53 |
410.5347 |
2025-07-23 00:00:00.0 |
9.3153 |
237 |
54 |
419.8136 |
2025-07-24 00:00:00.0 |
9.2789 |
237 |
55 |
428.8179 |
2025-07-25 00:00:00.0 |
9.0043 |
237 |
56 |
436.0575 |
2025-07-26 00:00:00.0 |
7.2396 |
237 |
57 |
444.1417 |
2025-07-27 00:00:00.0 |
8.0842 |
237 |
58 |
453.4137 |
2025-07-28 00:00:00.0 |
9.2720 |
237 |
59 |
462.3822 |
2025-07-29 00:00:00.0 |
8.9685 |
237 |
60 |
471.1573 |
2025-07-30 00:00:00.0 |
8.7751 |
237 |
61 |
479.5058 |
2025-07-31 00:00:00.0 |
8.3485 |
237 |
62 |
487.9332 |
2025-08-01 00:00:00.0 |
8.4274 |
237 |
63 |
494.7699 |
2025-08-02 00:00:00.0 |
6.8367 |
237 |
64 |
503.2896 |
2025-08-03 00:00:00.0 |
8.5197 |
237 |
65 |
511.5781 |
2025-08-04 00:00:00.0 |
8.2885 |
237 |
66 |
520.5392 |
2025-08-05 00:00:00.0 |
8.9611 |
237 |
67 |
529.3762 |
2025-08-06 00:00:00.0 |
8.8370 |
237 |
68 |
537.5212 |
2025-08-07 00:00:00.0 |
8.1450 |
237 |
69 |
545.6187 |
2025-08-08 00:00:00.0 |
8.0975 |
237 |
70 |
555.0165 |
2025-08-09 00:00:00.0 |
9.3978 |
237 |
71 |
564.2439 |
2025-08-10 00:00:00.0 |
9.2274 |
237 |
72 |
573.5369 |
2025-08-11 00:00:00.0 |
9.2930 |
237 |
73 |
582.8297 |
2025-08-12 00:00:00.0 |
9.2928 |
237 |
74 |
590.8794 |
2025-08-13 00:00:00.0 |
8.0497 |
237 |
75 |
597.5581 |
2025-08-14 00:00:00.0 |
6.6787 |
237 |
76 |
605.8339 |
2025-08-15 00:00:00.0 |
8.2758 |
237 |
77 |
614.2445 |
2025-08-16 00:00:00.0 |
8.4106 |
237 |
78 |
622.0886 |
2025-08-17 00:00:00.0 |
7.8441 |
237 |
79 |
629.5048 |
2025-08-18 00:00:00.0 |
7.4162 |
237 |
80 |
639.0035 |
2025-08-19 00:00:00.0 |
9.4987 |
237 |
81 |
647.6556 |
2025-08-20 00:00:00.0 |
8.6521 |
237 |
82 |
656.1861 |
2025-08-21 00:00:00.0 |
8.5305 |
237 |
83 |
664.9541 |
2025-08-22 00:00:00.0 |
8.7680 |
237 |
84 |
673.3782 |
2025-08-23 00:00:00.0 |
8.4241 |
237 |
85 |
681.4891 |
2025-08-24 00:00:00.0 |
8.1109 |
237 |
86 |
687.9803 |
2025-08-25 00:00:00.0 |
6.4912 |
237 |
87 |
694.1649 |
2025-08-26 00:00:00.0 |
6.1846 |
237 |
88 |
702.4171 |
2025-08-27 00:00:00.0 |
8.2522 |
237 |
89 |
711.1396 |
2025-08-28 00:00:00.0 |
8.7225 |
237 |
90 |
719.1086 |
2025-08-29 00:00:00.0 |
7.9690 |
237 |
91 |
726.6296 |
2025-08-30 00:00:00.0 |
7.5210 |
237 |
92 |
734.0159 |
2025-08-31 00:00:00.0 |
7.3863 |
237 |
93 |
741.4775 |
2025-09-01 00:00:00.0 |
7.4616 |
237 |
94 |
749.9022 |
2025-09-02 00:00:00.0 |
8.4247 |
237 |
95 |
755.8798 |
2025-09-03 00:00:00.0 |
5.9776 |
237 |
96 |
759.4680 |
2025-09-04 00:00:00.0 |
3.5882 |
237 |
97 |
759.7531 |
2025-09-05 00:00:00.0 |
0.2851 |
237 |
98 |
763.8836 |
2025-09-06 00:00:00.0 |
4.1305 |
237 |
99 |
766.9201 |
2025-09-07 00:00:00.0 |
3.0365 |
237 |
100 |
771.0861 |
2025-09-08 00:00:00.0 |
4.1660 |
237 |
101 |
777.3478 |
2025-09-09 00:00:00.0 |
6.2617 |
237 |
102 |
784.5713 |
2025-09-10 00:00:00.0 |
7.2235 |
237 |
103 |
791.2104 |
2025-09-11 00:00:00.0 |
6.6391 |
237 |
104 |
797.8700 |
2025-09-12 00:00:00.0 |
6.6596 |
237 |
105 |
807.0394 |
2025-09-13 00:00:00.0 |
9.1694 |
237 |
|
CACHED |
false |
EXECUTIONTIME |
15 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '237') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-13'}
ORDER BY ddate ASC |