| 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 |
| 109 |
795.5104 |
2025-09-17 00:00:00.0 |
8.8482 |
550 |
| 110 |
802.6329 |
2025-09-18 00:00:00.0 |
7.1225 |
550 |
| 111 |
808.1796 |
2025-09-19 00:00:00.0 |
5.5467 |
550 |
| 112 |
815.2839 |
2025-09-20 00:00:00.0 |
7.1043 |
550 |
| 113 |
822.9353 |
2025-09-21 00:00:00.0 |
7.6514 |
550 |
| 114 |
829.7798 |
2025-09-22 00:00:00.0 |
6.8445 |
550 |
| 115 |
836.8347 |
2025-09-23 00:00:00.0 |
7.0549 |
550 |
| 116 |
844.9428 |
2025-09-24 00:00:00.0 |
8.1081 |
550 |
| 117 |
850.9839 |
2025-09-25 00:00:00.0 |
6.0411 |
550 |
| 118 |
856.6525 |
2025-09-26 00:00:00.0 |
5.6686 |
550 |
| 119 |
862.6866 |
2025-09-27 00:00:00.0 |
6.0341 |
550 |
| 120 |
867.6414 |
2025-09-28 00:00:00.0 |
4.9548 |
550 |
| 121 |
873.5432 |
2025-09-29 00:00:00.0 |
5.9018 |
550 |
| 122 |
881.8955 |
2025-09-30 00:00:00.0 |
8.3523 |
550 |
| 123 |
889.2786 |
2025-10-01 00:00:00.0 |
7.3831 |
550 |
| 124 |
897.6796 |
2025-10-02 00:00:00.0 |
8.4010 |
550 |
| 125 |
903.6885 |
2025-10-03 00:00:00.0 |
6.0089 |
550 |
| 126 |
911.9163 |
2025-10-04 00:00:00.0 |
8.2278 |
550 |
| 127 |
919.4526 |
2025-10-05 00:00:00.0 |
7.5363 |
550 |
| 128 |
921.2531 |
2025-10-06 00:00:00.0 |
1.8005 |
550 |
| 129 |
921.9275 |
2025-10-07 00:00:00.0 |
0.6744 |
550 |
| 130 |
922.4473 |
2025-10-08 00:00:00.0 |
0.5198 |
550 |
| 131 |
926.9568 |
2025-10-09 00:00:00.0 |
4.5095 |
550 |
| 132 |
931.1973 |
2025-10-10 00:00:00.0 |
4.2405 |
550 |
| 133 |
934.0637 |
2025-10-11 00:00:00.0 |
2.8664 |
550 |
| 134 |
939.7562 |
2025-10-12 00:00:00.0 |
5.6925 |
550 |
| 135 |
942.3628 |
2025-10-13 00:00:00.0 |
2.6066 |
550 |
| 136 |
942.3628 |
2025-10-14 00:00:00.0 |
0.0000 |
550 |
| 137 |
942.3806 |
2025-10-15 00:00:00.0 |
0.0178 |
550 |
| 138 |
943.0057 |
2025-10-16 00:00:00.0 |
0.6251 |
550 |
| 139 |
945.7335 |
2025-10-17 00:00:00.0 |
2.7278 |
550 |
| 140 |
946.5295 |
2025-10-18 00:00:00.0 |
0.7960 |
550 |
| 141 |
947.1686 |
2025-10-19 00:00:00.0 |
0.6391 |
550 |
| 142 |
948.4502 |
2025-10-20 00:00:00.0 |
1.2816 |
550 |
| 143 |
948.7196 |
2025-10-21 00:00:00.0 |
0.2694 |
550 |
| 144 |
948.7196 |
2025-10-22 00:00:00.0 |
0.0000 |
550 |
| 145 |
949.8119 |
2025-10-23 00:00:00.0 |
1.0923 |
550 |
| 146 |
950.6751 |
2025-10-24 00:00:00.0 |
0.8632 |
550 |
| 147 |
951.9873 |
2025-10-25 00:00:00.0 |
1.3122 |
550 |
| 148 |
956.2588 |
2025-10-26 00:00:00.0 |
4.2715 |
550 |
| 149 |
961.0283 |
2025-10-27 00:00:00.0 |
4.7695 |
550 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '550') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-27'}
ORDER BY ddate ASC |