query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
8.0563 |
2025-06-01 00:00:00.0 |
8.0563 |
550 |
2 |
15.3782 |
2025-06-02 00:00:00.0 |
7.3219 |
550 |
3 |
21.9507 |
2025-06-03 00:00:00.0 |
6.5725 |
550 |
4 |
27.4388 |
2025-06-04 00:00:00.0 |
5.4881 |
550 |
5 |
32.4538 |
2025-06-05 00:00:00.0 |
5.0150 |
550 |
6 |
37.4875 |
2025-06-06 00:00:00.0 |
5.0337 |
550 |
7 |
44.2946 |
2025-06-07 00:00:00.0 |
6.8071 |
550 |
8 |
51.1047 |
2025-06-08 00:00:00.0 |
6.8101 |
550 |
9 |
54.0606 |
2025-06-09 00:00:00.0 |
2.9559 |
550 |
10 |
60.4318 |
2025-06-10 00:00:00.0 |
6.3712 |
550 |
11 |
68.1294 |
2025-06-11 00:00:00.0 |
7.6976 |
550 |
12 |
73.9388 |
2025-06-12 00:00:00.0 |
5.8094 |
550 |
13 |
80.2286 |
2025-06-13 00:00:00.0 |
6.2898 |
550 |
14 |
88.5126 |
2025-06-14 00:00:00.0 |
8.2840 |
550 |
15 |
95.9661 |
2025-06-15 00:00:00.0 |
7.4535 |
550 |
16 |
104.6341 |
2025-06-16 00:00:00.0 |
8.6680 |
550 |
17 |
113.5690 |
2025-06-17 00:00:00.0 |
8.9349 |
550 |
18 |
121.1633 |
2025-06-18 00:00:00.0 |
7.5943 |
550 |
19 |
129.4855 |
2025-06-19 00:00:00.0 |
8.3222 |
550 |
20 |
137.7367 |
2025-06-20 00:00:00.0 |
8.2512 |
550 |
21 |
146.6176 |
2025-06-21 00:00:00.0 |
8.8809 |
550 |
22 |
155.7437 |
2025-06-22 00:00:00.0 |
9.1261 |
550 |
23 |
163.4895 |
2025-06-23 00:00:00.0 |
7.7458 |
550 |
24 |
167.2836 |
2025-06-24 00:00:00.0 |
3.7941 |
550 |
25 |
173.5504 |
2025-06-25 00:00:00.0 |
6.2668 |
550 |
26 |
180.6065 |
2025-06-26 00:00:00.0 |
7.0561 |
550 |
27 |
188.9593 |
2025-06-27 00:00:00.0 |
8.3528 |
550 |
28 |
196.9273 |
2025-06-28 00:00:00.0 |
7.9680 |
550 |
29 |
205.1240 |
2025-06-29 00:00:00.0 |
8.1967 |
550 |
30 |
213.1426 |
2025-06-30 00:00:00.0 |
8.0186 |
550 |
31 |
222.0779 |
2025-07-01 00:00:00.0 |
8.9353 |
550 |
32 |
229.7887 |
2025-07-02 00:00:00.0 |
7.7108 |
550 |
33 |
238.3451 |
2025-07-03 00:00:00.0 |
8.5564 |
550 |
34 |
245.6327 |
2025-07-04 00:00:00.0 |
7.2876 |
550 |
35 |
253.4046 |
2025-07-05 00:00:00.0 |
7.7719 |
550 |
36 |
261.1539 |
2025-07-06 00:00:00.0 |
7.7493 |
550 |
37 |
268.0629 |
2025-07-07 00:00:00.0 |
6.9090 |
550 |
38 |
274.9473 |
2025-07-08 00:00:00.0 |
6.8844 |
550 |
39 |
281.5610 |
2025-07-09 00:00:00.0 |
6.6137 |
550 |
40 |
288.8530 |
2025-07-10 00:00:00.0 |
7.2920 |
550 |
41 |
297.5021 |
2025-07-11 00:00:00.0 |
8.6491 |
550 |
42 |
305.2341 |
2025-07-12 00:00:00.0 |
7.7320 |
550 |
43 |
311.6383 |
2025-07-13 00:00:00.0 |
6.4042 |
550 |
44 |
319.7647 |
2025-07-14 00:00:00.0 |
8.1264 |
550 |
45 |
327.8997 |
2025-07-15 00:00:00.0 |
8.1350 |
550 |
46 |
334.2960 |
2025-07-16 00:00:00.0 |
6.3963 |
550 |
47 |
340.5354 |
2025-07-17 00:00:00.0 |
6.2394 |
550 |
48 |
340.5354 |
2025-07-18 00:00:00.0 |
0.0000 |
550 |
49 |
347.6617 |
2025-07-19 00:00:00.0 |
7.1263 |
550 |
50 |
354.8966 |
2025-07-20 00:00:00.0 |
7.2349 |
550 |
51 |
363.8736 |
2025-07-21 00:00:00.0 |
8.9770 |
550 |
52 |
372.6088 |
2025-07-22 00:00:00.0 |
8.7352 |
550 |
53 |
381.8777 |
2025-07-23 00:00:00.0 |
9.2689 |
550 |
54 |
391.1721 |
2025-07-24 00:00:00.0 |
9.2944 |
550 |
55 |
399.0133 |
2025-07-25 00:00:00.0 |
7.8412 |
550 |
56 |
406.3882 |
2025-07-26 00:00:00.0 |
7.3749 |
550 |
57 |
414.8009 |
2025-07-27 00:00:00.0 |
8.4127 |
550 |
58 |
423.7750 |
2025-07-28 00:00:00.0 |
8.9741 |
550 |
59 |
432.4063 |
2025-07-29 00:00:00.0 |
8.6313 |
550 |
60 |
440.2626 |
2025-07-30 00:00:00.0 |
7.8563 |
550 |
61 |
447.3654 |
2025-07-31 00:00:00.0 |
7.1028 |
550 |
62 |
453.6989 |
2025-08-01 00:00:00.0 |
6.3335 |
550 |
63 |
461.4315 |
2025-08-02 00:00:00.0 |
7.7326 |
550 |
64 |
469.5035 |
2025-08-03 00:00:00.0 |
8.0720 |
550 |
65 |
478.4213 |
2025-08-04 00:00:00.0 |
8.9178 |
550 |
66 |
487.6881 |
2025-08-05 00:00:00.0 |
9.2668 |
550 |
67 |
497.3186 |
2025-08-06 00:00:00.0 |
9.6305 |
550 |
68 |
506.1594 |
2025-08-07 00:00:00.0 |
8.8408 |
550 |
69 |
514.2448 |
2025-08-08 00:00:00.0 |
8.0854 |
550 |
70 |
524.0120 |
2025-08-09 00:00:00.0 |
9.7672 |
550 |
71 |
531.8559 |
2025-08-10 00:00:00.0 |
7.8439 |
550 |
72 |
540.9894 |
2025-08-11 00:00:00.0 |
9.1335 |
550 |
73 |
549.5764 |
2025-08-12 00:00:00.0 |
8.5870 |
550 |
74 |
557.4097 |
2025-08-13 00:00:00.0 |
7.8333 |
550 |
75 |
565.3300 |
2025-08-14 00:00:00.0 |
7.9203 |
550 |
76 |
573.9598 |
2025-08-15 00:00:00.0 |
8.6298 |
550 |
77 |
579.7764 |
2025-08-16 00:00:00.0 |
5.8166 |
550 |
78 |
587.2489 |
2025-08-17 00:00:00.0 |
7.4725 |
550 |
79 |
596.0437 |
2025-08-18 00:00:00.0 |
8.7948 |
550 |
80 |
605.2315 |
2025-08-19 00:00:00.0 |
9.1878 |
550 |
81 |
613.8296 |
2025-08-20 00:00:00.0 |
8.5981 |
550 |
82 |
621.4340 |
2025-08-21 00:00:00.0 |
7.6044 |
550 |
83 |
629.8063 |
2025-08-22 00:00:00.0 |
8.3723 |
550 |
84 |
634.9899 |
2025-08-23 00:00:00.0 |
5.1836 |
550 |
85 |
640.3072 |
2025-08-24 00:00:00.0 |
5.3173 |
550 |
86 |
645.3242 |
2025-08-25 00:00:00.0 |
5.0170 |
550 |
87 |
651.0679 |
2025-08-26 00:00:00.0 |
5.7437 |
550 |
88 |
656.9866 |
2025-08-27 00:00:00.0 |
5.9187 |
550 |
89 |
663.5553 |
2025-08-28 00:00:00.0 |
6.5687 |
550 |
90 |
671.7582 |
2025-08-29 00:00:00.0 |
8.2029 |
550 |
91 |
679.3694 |
2025-08-30 00:00:00.0 |
7.6112 |
550 |
92 |
686.6928 |
2025-08-31 00:00:00.0 |
7.3234 |
550 |
93 |
694.5447 |
2025-09-01 00:00:00.0 |
7.8519 |
550 |
94 |
702.7712 |
2025-09-02 00:00:00.0 |
8.2265 |
550 |
95 |
706.9628 |
2025-09-03 00:00:00.0 |
4.1916 |
550 |
96 |
708.7655 |
2025-09-04 00:00:00.0 |
1.8027 |
550 |
97 |
710.2103 |
2025-09-05 00:00:00.0 |
1.4448 |
550 |
98 |
712.4390 |
2025-09-06 00:00:00.0 |
2.2287 |
550 |
99 |
714.4706 |
2025-09-07 00:00:00.0 |
2.0316 |
550 |
100 |
718.4119 |
2025-09-08 00:00:00.0 |
3.9413 |
550 |
101 |
724.6324 |
2025-09-09 00:00:00.0 |
6.2205 |
550 |
102 |
732.2717 |
2025-09-10 00:00:00.0 |
7.6393 |
550 |
103 |
739.9986 |
2025-09-11 00:00:00.0 |
7.7269 |
550 |
104 |
748.9036 |
2025-09-12 00:00:00.0 |
8.9050 |
550 |
105 |
757.9964 |
2025-09-13 00:00:00.0 |
9.0928 |
550 |
106 |
767.5264 |
2025-09-14 00:00:00.0 |
9.5300 |
550 |
107 |
777.1521 |
2025-09-15 00:00:00.0 |
9.6257 |
550 |
108 |
786.6622 |
2025-09-16 00:00:00.0 |
9.5101 |
550 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '550') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'}
ORDER BY ddate ASC |