query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
6.9433 |
2025-06-01 00:00:00.0 |
6.9433 |
204 |
2 |
13.7000 |
2025-06-02 00:00:00.0 |
6.7567 |
204 |
3 |
22.1452 |
2025-06-03 00:00:00.0 |
8.4452 |
204 |
4 |
29.0132 |
2025-06-04 00:00:00.0 |
6.8680 |
204 |
5 |
35.1706 |
2025-06-05 00:00:00.0 |
6.1574 |
204 |
6 |
41.0744 |
2025-06-06 00:00:00.0 |
5.9038 |
204 |
7 |
48.2280 |
2025-06-07 00:00:00.0 |
7.1536 |
204 |
8 |
56.4671 |
2025-06-08 00:00:00.0 |
8.2391 |
204 |
9 |
60.8610 |
2025-06-09 00:00:00.0 |
4.3939 |
204 |
10 |
66.8740 |
2025-06-10 00:00:00.0 |
6.0130 |
204 |
11 |
73.8579 |
2025-06-11 00:00:00.0 |
6.9839 |
204 |
12 |
80.1634 |
2025-06-12 00:00:00.0 |
6.3055 |
204 |
13 |
86.8603 |
2025-06-13 00:00:00.0 |
6.6969 |
204 |
14 |
93.7367 |
2025-06-14 00:00:00.0 |
6.8764 |
204 |
15 |
100.9947 |
2025-06-15 00:00:00.0 |
7.2580 |
204 |
16 |
108.9979 |
2025-06-16 00:00:00.0 |
8.0032 |
204 |
17 |
118.3627 |
2025-06-17 00:00:00.0 |
9.3648 |
204 |
18 |
126.6865 |
2025-06-18 00:00:00.0 |
8.3238 |
204 |
19 |
135.4095 |
2025-06-19 00:00:00.0 |
8.7230 |
204 |
20 |
143.7650 |
2025-06-20 00:00:00.0 |
8.3555 |
204 |
21 |
151.8661 |
2025-06-21 00:00:00.0 |
8.1011 |
204 |
22 |
161.3075 |
2025-06-22 00:00:00.0 |
9.4414 |
204 |
23 |
168.6327 |
2025-06-23 00:00:00.0 |
7.3252 |
204 |
24 |
173.0904 |
2025-06-24 00:00:00.0 |
4.4577 |
204 |
25 |
178.5091 |
2025-06-25 00:00:00.0 |
5.4187 |
204 |
26 |
184.6887 |
2025-06-26 00:00:00.0 |
6.1796 |
204 |
27 |
191.4827 |
2025-06-27 00:00:00.0 |
6.7940 |
204 |
28 |
199.6508 |
2025-06-28 00:00:00.0 |
8.1681 |
204 |
29 |
207.1715 |
2025-06-29 00:00:00.0 |
7.5207 |
204 |
30 |
216.5128 |
2025-06-30 00:00:00.0 |
9.3413 |
204 |
31 |
225.1367 |
2025-07-01 00:00:00.0 |
8.6239 |
204 |
32 |
233.3387 |
2025-07-02 00:00:00.0 |
8.2020 |
204 |
33 |
241.4107 |
2025-07-03 00:00:00.0 |
8.0720 |
204 |
34 |
248.1012 |
2025-07-04 00:00:00.0 |
6.6905 |
204 |
35 |
255.7468 |
2025-07-05 00:00:00.0 |
7.6456 |
204 |
36 |
264.7409 |
2025-07-06 00:00:00.0 |
8.9941 |
204 |
37 |
271.8593 |
2025-07-07 00:00:00.0 |
7.1184 |
204 |
38 |
277.8178 |
2025-07-08 00:00:00.0 |
5.9585 |
204 |
39 |
285.4411 |
2025-07-09 00:00:00.0 |
7.6233 |
204 |
40 |
293.3382 |
2025-07-10 00:00:00.0 |
7.8971 |
204 |
41 |
301.7086 |
2025-07-11 00:00:00.0 |
8.3704 |
204 |
42 |
310.5248 |
2025-07-12 00:00:00.0 |
8.8162 |
204 |
43 |
318.5752 |
2025-07-13 00:00:00.0 |
8.0504 |
204 |
44 |
327.6038 |
2025-07-14 00:00:00.0 |
9.0286 |
204 |
45 |
336.1541 |
2025-07-15 00:00:00.0 |
8.5503 |
204 |
46 |
343.3985 |
2025-07-16 00:00:00.0 |
7.2444 |
204 |
47 |
350.0954 |
2025-07-17 00:00:00.0 |
6.6969 |
204 |
48 |
356.3130 |
2025-07-18 00:00:00.0 |
6.2176 |
204 |
49 |
363.2604 |
2025-07-19 00:00:00.0 |
6.9474 |
204 |
50 |
370.3241 |
2025-07-20 00:00:00.0 |
7.0637 |
204 |
51 |
378.8767 |
2025-07-21 00:00:00.0 |
8.5526 |
204 |
52 |
387.4719 |
2025-07-22 00:00:00.0 |
8.5952 |
204 |
53 |
396.7057 |
2025-07-23 00:00:00.0 |
9.2338 |
204 |
54 |
406.1246 |
2025-07-24 00:00:00.0 |
9.4189 |
204 |
55 |
415.3906 |
2025-07-25 00:00:00.0 |
9.2660 |
204 |
56 |
422.8954 |
2025-07-26 00:00:00.0 |
7.5048 |
204 |
57 |
430.9790 |
2025-07-27 00:00:00.0 |
8.0836 |
204 |
58 |
440.0548 |
2025-07-28 00:00:00.0 |
9.0758 |
204 |
59 |
448.5457 |
2025-07-29 00:00:00.0 |
8.4909 |
204 |
60 |
456.5932 |
2025-07-30 00:00:00.0 |
8.0475 |
204 |
61 |
463.5742 |
2025-07-31 00:00:00.0 |
6.9810 |
204 |
62 |
471.0519 |
2025-08-01 00:00:00.0 |
7.4777 |
204 |
63 |
478.5427 |
2025-08-02 00:00:00.0 |
7.4908 |
204 |
64 |
487.2126 |
2025-08-03 00:00:00.0 |
8.6699 |
204 |
65 |
495.2360 |
2025-08-04 00:00:00.0 |
8.0234 |
204 |
66 |
503.6745 |
2025-08-05 00:00:00.0 |
8.4385 |
204 |
67 |
512.5468 |
2025-08-06 00:00:00.0 |
8.8723 |
204 |
68 |
521.4947 |
2025-08-07 00:00:00.0 |
8.9479 |
204 |
69 |
529.8855 |
2025-08-08 00:00:00.0 |
8.3908 |
204 |
70 |
539.5693 |
2025-08-09 00:00:00.0 |
9.6838 |
204 |
71 |
548.4398 |
2025-08-10 00:00:00.0 |
8.8705 |
204 |
72 |
557.5180 |
2025-08-11 00:00:00.0 |
9.0782 |
204 |
73 |
566.8407 |
2025-08-12 00:00:00.0 |
9.3227 |
204 |
74 |
574.0862 |
2025-08-13 00:00:00.0 |
7.2455 |
204 |
75 |
581.1024 |
2025-08-14 00:00:00.0 |
7.0162 |
204 |
76 |
589.8378 |
2025-08-15 00:00:00.0 |
8.7354 |
204 |
77 |
597.4515 |
2025-08-16 00:00:00.0 |
7.6137 |
204 |
78 |
604.6468 |
2025-08-17 00:00:00.0 |
7.1953 |
204 |
79 |
611.9001 |
2025-08-18 00:00:00.0 |
7.2533 |
204 |
80 |
621.3831 |
2025-08-19 00:00:00.0 |
9.4830 |
204 |
81 |
630.3628 |
2025-08-20 00:00:00.0 |
8.9797 |
204 |
82 |
638.1219 |
2025-08-21 00:00:00.0 |
7.7591 |
204 |
83 |
646.8717 |
2025-08-22 00:00:00.0 |
8.7498 |
204 |
84 |
654.3999 |
2025-08-23 00:00:00.0 |
7.5282 |
204 |
85 |
661.5042 |
2025-08-24 00:00:00.0 |
7.1043 |
204 |
86 |
667.5845 |
2025-08-25 00:00:00.0 |
6.0803 |
204 |
87 |
673.3660 |
2025-08-26 00:00:00.0 |
5.7815 |
204 |
88 |
681.4540 |
2025-08-27 00:00:00.0 |
8.0880 |
204 |
89 |
690.0068 |
2025-08-28 00:00:00.0 |
8.5528 |
204 |
90 |
697.8418 |
2025-08-29 00:00:00.0 |
7.8350 |
204 |
91 |
705.1239 |
2025-08-30 00:00:00.0 |
7.2821 |
204 |
92 |
712.0851 |
2025-08-31 00:00:00.0 |
6.9612 |
204 |
93 |
719.7053 |
2025-09-01 00:00:00.0 |
7.6202 |
204 |
94 |
728.0602 |
2025-09-02 00:00:00.0 |
8.3549 |
204 |
95 |
733.5879 |
2025-09-03 00:00:00.0 |
5.5277 |
204 |
96 |
735.5193 |
2025-09-04 00:00:00.0 |
1.9314 |
204 |
97 |
735.7244 |
2025-09-05 00:00:00.0 |
0.2051 |
204 |
98 |
739.2796 |
2025-09-06 00:00:00.0 |
3.5552 |
204 |
99 |
741.7658 |
2025-09-07 00:00:00.0 |
2.4862 |
204 |
100 |
745.7642 |
2025-09-08 00:00:00.0 |
3.9984 |
204 |
101 |
752.7367 |
2025-09-09 00:00:00.0 |
6.9725 |
204 |
102 |
760.1732 |
2025-09-10 00:00:00.0 |
7.4365 |
204 |
103 |
766.4770 |
2025-09-11 00:00:00.0 |
6.3038 |
204 |
104 |
773.3518 |
2025-09-12 00:00:00.0 |
6.8748 |
204 |
105 |
782.6314 |
2025-09-13 00:00:00.0 |
9.2796 |
204 |
106 |
791.6547 |
2025-09-14 00:00:00.0 |
9.0233 |
204 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '204') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-14'}
ORDER BY ddate ASC |