query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.0321 |
2025-06-01 00:00:00.0 |
7.0321 |
244 |
2 |
14.1458 |
2025-06-02 00:00:00.0 |
7.1137 |
244 |
3 |
22.0960 |
2025-06-03 00:00:00.0 |
7.9502 |
244 |
4 |
29.8084 |
2025-06-04 00:00:00.0 |
7.7124 |
244 |
5 |
36.4121 |
2025-06-05 00:00:00.0 |
6.6037 |
244 |
6 |
42.8278 |
2025-06-06 00:00:00.0 |
6.4157 |
244 |
7 |
50.4902 |
2025-06-07 00:00:00.0 |
7.6624 |
244 |
8 |
58.8344 |
2025-06-08 00:00:00.0 |
8.3442 |
244 |
9 |
64.2676 |
2025-06-09 00:00:00.0 |
5.4332 |
244 |
10 |
68.5307 |
2025-06-10 00:00:00.0 |
4.2631 |
244 |
11 |
75.4301 |
2025-06-11 00:00:00.0 |
6.8994 |
244 |
12 |
82.4373 |
2025-06-12 00:00:00.0 |
7.0072 |
244 |
13 |
89.0392 |
2025-06-13 00:00:00.0 |
6.6019 |
244 |
14 |
96.7964 |
2025-06-14 00:00:00.0 |
7.7572 |
244 |
15 |
105.0526 |
2025-06-15 00:00:00.0 |
8.2562 |
244 |
16 |
113.0540 |
2025-06-16 00:00:00.0 |
8.0014 |
244 |
17 |
122.5052 |
2025-06-17 00:00:00.0 |
9.4512 |
244 |
18 |
131.2075 |
2025-06-18 00:00:00.0 |
8.7023 |
244 |
19 |
139.0143 |
2025-06-19 00:00:00.0 |
7.8068 |
244 |
20 |
147.5900 |
2025-06-20 00:00:00.0 |
8.5757 |
244 |
21 |
155.2765 |
2025-06-21 00:00:00.0 |
7.6865 |
244 |
22 |
163.7037 |
2025-06-22 00:00:00.0 |
8.4272 |
244 |
23 |
172.6735 |
2025-06-23 00:00:00.0 |
8.9698 |
244 |
24 |
179.1756 |
2025-06-24 00:00:00.0 |
6.5021 |
244 |
25 |
184.9574 |
2025-06-25 00:00:00.0 |
5.7818 |
244 |
26 |
193.4938 |
2025-06-26 00:00:00.0 |
8.5364 |
244 |
27 |
202.0654 |
2025-06-27 00:00:00.0 |
8.5716 |
244 |
28 |
209.6298 |
2025-06-28 00:00:00.0 |
7.5644 |
244 |
29 |
217.0295 |
2025-06-29 00:00:00.0 |
7.3997 |
244 |
30 |
225.8703 |
2025-06-30 00:00:00.0 |
8.8408 |
244 |
31 |
234.7983 |
2025-07-01 00:00:00.0 |
8.9280 |
244 |
32 |
242.7723 |
2025-07-02 00:00:00.0 |
7.9740 |
244 |
33 |
251.6837 |
2025-07-03 00:00:00.0 |
8.9114 |
244 |
34 |
259.3078 |
2025-07-04 00:00:00.0 |
7.6241 |
244 |
35 |
267.7970 |
2025-07-05 00:00:00.0 |
8.4892 |
244 |
36 |
276.8687 |
2025-07-06 00:00:00.0 |
9.0717 |
244 |
37 |
284.8873 |
2025-07-07 00:00:00.0 |
8.0186 |
244 |
38 |
293.4523 |
2025-07-08 00:00:00.0 |
8.5650 |
244 |
39 |
301.6858 |
2025-07-09 00:00:00.0 |
8.2335 |
244 |
40 |
310.1384 |
2025-07-10 00:00:00.0 |
8.4526 |
244 |
41 |
317.2575 |
2025-07-11 00:00:00.0 |
7.1191 |
244 |
42 |
326.6989 |
2025-07-12 00:00:00.0 |
9.4414 |
244 |
43 |
335.4996 |
2025-07-13 00:00:00.0 |
8.8007 |
244 |
44 |
344.2370 |
2025-07-14 00:00:00.0 |
8.7374 |
244 |
45 |
353.7069 |
2025-07-15 00:00:00.0 |
9.4699 |
244 |
46 |
361.4053 |
2025-07-16 00:00:00.0 |
7.6984 |
244 |
47 |
367.5263 |
2025-07-17 00:00:00.0 |
6.1210 |
244 |
48 |
373.4004 |
2025-07-18 00:00:00.0 |
5.8741 |
244 |
49 |
381.7280 |
2025-07-19 00:00:00.0 |
8.3276 |
244 |
50 |
388.7595 |
2025-07-20 00:00:00.0 |
7.0315 |
244 |
51 |
397.5289 |
2025-07-21 00:00:00.0 |
8.7694 |
244 |
52 |
406.6698 |
2025-07-22 00:00:00.0 |
9.1409 |
244 |
53 |
416.2909 |
2025-07-23 00:00:00.0 |
9.6211 |
244 |
54 |
425.6243 |
2025-07-24 00:00:00.0 |
9.3334 |
244 |
55 |
434.4231 |
2025-07-25 00:00:00.0 |
8.7988 |
244 |
56 |
442.3937 |
2025-07-26 00:00:00.0 |
7.9706 |
244 |
57 |
449.9789 |
2025-07-27 00:00:00.0 |
7.5852 |
244 |
58 |
459.3858 |
2025-07-28 00:00:00.0 |
9.4069 |
244 |
59 |
468.4433 |
2025-07-29 00:00:00.0 |
9.0575 |
244 |
60 |
477.2468 |
2025-07-30 00:00:00.0 |
8.8035 |
244 |
61 |
485.0014 |
2025-07-31 00:00:00.0 |
7.7546 |
244 |
62 |
491.4772 |
2025-08-01 00:00:00.0 |
6.4758 |
244 |
63 |
499.0276 |
2025-08-02 00:00:00.0 |
7.5504 |
244 |
64 |
507.5723 |
2025-08-03 00:00:00.0 |
8.5447 |
244 |
65 |
515.8856 |
2025-08-04 00:00:00.0 |
8.3133 |
244 |
66 |
525.5685 |
2025-08-05 00:00:00.0 |
9.6829 |
244 |
67 |
534.6288 |
2025-08-06 00:00:00.0 |
9.0603 |
244 |
68 |
542.8193 |
2025-08-07 00:00:00.0 |
8.1905 |
244 |
69 |
550.3918 |
2025-08-08 00:00:00.0 |
7.5725 |
244 |
70 |
559.7305 |
2025-08-09 00:00:00.0 |
9.3387 |
244 |
71 |
568.8274 |
2025-08-10 00:00:00.0 |
9.0969 |
244 |
72 |
578.0213 |
2025-08-11 00:00:00.0 |
9.1939 |
244 |
73 |
587.0952 |
2025-08-12 00:00:00.0 |
9.0739 |
244 |
74 |
595.7881 |
2025-08-13 00:00:00.0 |
8.6929 |
244 |
75 |
602.5981 |
2025-08-14 00:00:00.0 |
6.8100 |
244 |
76 |
610.8615 |
2025-08-15 00:00:00.0 |
8.2634 |
244 |
77 |
619.1179 |
2025-08-16 00:00:00.0 |
8.2564 |
244 |
78 |
627.8028 |
2025-08-17 00:00:00.0 |
8.6849 |
244 |
79 |
636.4135 |
2025-08-18 00:00:00.0 |
8.6107 |
244 |
80 |
646.0433 |
2025-08-19 00:00:00.0 |
9.6298 |
244 |
81 |
655.1423 |
2025-08-20 00:00:00.0 |
9.0990 |
244 |
82 |
663.6231 |
2025-08-21 00:00:00.0 |
8.4808 |
244 |
83 |
672.2138 |
2025-08-22 00:00:00.0 |
8.5907 |
244 |
84 |
679.7376 |
2025-08-23 00:00:00.0 |
7.5238 |
244 |
85 |
687.8514 |
2025-08-24 00:00:00.0 |
8.1138 |
244 |
86 |
694.0830 |
2025-08-25 00:00:00.0 |
6.2316 |
244 |
87 |
700.0595 |
2025-08-26 00:00:00.0 |
5.9765 |
244 |
88 |
707.6911 |
2025-08-27 00:00:00.0 |
7.6316 |
244 |
89 |
715.3705 |
2025-08-28 00:00:00.0 |
7.6794 |
244 |
90 |
722.8613 |
2025-08-29 00:00:00.0 |
7.4908 |
244 |
91 |
730.4756 |
2025-08-30 00:00:00.0 |
7.6143 |
244 |
92 |
737.8647 |
2025-08-31 00:00:00.0 |
7.3891 |
244 |
93 |
745.7909 |
2025-09-01 00:00:00.0 |
7.9262 |
244 |
94 |
754.2717 |
2025-09-02 00:00:00.0 |
8.4808 |
244 |
95 |
760.5311 |
2025-09-03 00:00:00.0 |
6.2594 |
244 |
96 |
763.9531 |
2025-09-04 00:00:00.0 |
3.4220 |
244 |
97 |
764.2847 |
2025-09-05 00:00:00.0 |
0.3316 |
244 |
98 |
768.8670 |
2025-09-06 00:00:00.0 |
4.5823 |
244 |
99 |
772.0605 |
2025-09-07 00:00:00.0 |
3.1935 |
244 |
100 |
775.5460 |
2025-09-08 00:00:00.0 |
3.4855 |
244 |
101 |
781.9456 |
2025-09-09 00:00:00.0 |
6.3996 |
244 |
102 |
788.8986 |
2025-09-10 00:00:00.0 |
6.9530 |
244 |
103 |
795.4818 |
2025-09-11 00:00:00.0 |
6.5832 |
244 |
104 |
803.8731 |
2025-09-12 00:00:00.0 |
8.3913 |
244 |
105 |
813.1330 |
2025-09-13 00:00:00.0 |
9.2599 |
244 |
106 |
822.1317 |
2025-09-14 00:00:00.0 |
8.9987 |
244 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '244') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-14'}
ORDER BY ddate ASC |