| 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 |
| 107 |
831.3667 |
2025-09-15 00:00:00.0 |
9.2350 |
244 |
| 108 |
840.8434 |
2025-09-16 00:00:00.0 |
9.4767 |
244 |
| 109 |
849.7130 |
2025-09-17 00:00:00.0 |
8.8696 |
244 |
| 110 |
858.2732 |
2025-09-18 00:00:00.0 |
8.5602 |
244 |
| 111 |
866.7252 |
2025-09-19 00:00:00.0 |
8.4520 |
244 |
| 112 |
875.0958 |
2025-09-20 00:00:00.0 |
8.3706 |
244 |
| 113 |
883.3402 |
2025-09-21 00:00:00.0 |
8.2444 |
244 |
| 114 |
892.0781 |
2025-09-22 00:00:00.0 |
8.7379 |
244 |
| 115 |
899.7956 |
2025-09-23 00:00:00.0 |
7.7175 |
244 |
| 116 |
908.3869 |
2025-09-24 00:00:00.0 |
8.5913 |
244 |
| 117 |
915.3202 |
2025-09-25 00:00:00.0 |
6.9333 |
244 |
| 118 |
921.1224 |
2025-09-26 00:00:00.0 |
5.8022 |
244 |
| 119 |
927.1135 |
2025-09-27 00:00:00.0 |
5.9911 |
244 |
| 120 |
933.3752 |
2025-09-28 00:00:00.0 |
6.2617 |
244 |
| 121 |
940.1349 |
2025-09-29 00:00:00.0 |
6.7597 |
244 |
| 122 |
947.9743 |
2025-09-30 00:00:00.0 |
7.8394 |
244 |
| 123 |
955.7840 |
2025-10-01 00:00:00.0 |
7.8097 |
244 |
| 124 |
964.3983 |
2025-10-02 00:00:00.0 |
8.6143 |
244 |
| 125 |
972.3896 |
2025-10-03 00:00:00.0 |
7.9913 |
244 |
| 126 |
980.3935 |
2025-10-04 00:00:00.0 |
8.0039 |
244 |
| 127 |
989.2263 |
2025-10-05 00:00:00.0 |
8.8328 |
244 |
| 128 |
992.6094 |
2025-10-06 00:00:00.0 |
3.3831 |
244 |
| 129 |
994.0752 |
2025-10-07 00:00:00.0 |
1.4658 |
244 |
| 130 |
994.5950 |
2025-10-08 00:00:00.0 |
0.5198 |
244 |
| 131 |
997.7189 |
2025-10-09 00:00:00.0 |
3.1239 |
244 |
| 132 |
1004.0294 |
2025-10-10 00:00:00.0 |
6.3105 |
244 |
| 133 |
1007.5667 |
2025-10-11 00:00:00.0 |
3.5373 |
244 |
| 134 |
1012.1967 |
2025-10-12 00:00:00.0 |
4.6300 |
244 |
| 135 |
1017.0283 |
2025-10-13 00:00:00.0 |
4.8316 |
244 |
| 136 |
1017.4053 |
2025-10-14 00:00:00.0 |
0.3770 |
244 |
| 137 |
1017.4053 |
2025-10-15 00:00:00.0 |
0.0000 |
244 |
| 138 |
1018.3439 |
2025-10-16 00:00:00.0 |
0.9386 |
244 |
| 139 |
1022.2878 |
2025-10-17 00:00:00.0 |
3.9439 |
244 |
| 140 |
1026.7139 |
2025-10-18 00:00:00.0 |
4.4261 |
244 |
| 141 |
1028.6370 |
2025-10-19 00:00:00.0 |
1.9231 |
244 |
| 142 |
1030.5669 |
2025-10-20 00:00:00.0 |
1.9299 |
244 |
| 143 |
1031.1164 |
2025-10-21 00:00:00.0 |
0.5495 |
244 |
| 144 |
1031.1164 |
2025-10-22 00:00:00.0 |
0.0000 |
244 |
| 145 |
1031.1164 |
2025-10-23 00:00:00.0 |
0.0000 |
244 |
| 146 |
1031.3699 |
2025-10-24 00:00:00.0 |
0.2535 |
244 |
|
| CACHED |
false |
| EXECUTIONTIME |
16 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '244') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-24'}
ORDER BY ddate ASC |