| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.0931 |
2025-06-01 00:00:00.0 |
7.0931 |
223 |
| 2 |
14.5050 |
2025-06-02 00:00:00.0 |
7.4119 |
223 |
| 3 |
23.1993 |
2025-06-03 00:00:00.0 |
8.6943 |
223 |
| 4 |
31.1085 |
2025-06-04 00:00:00.0 |
7.9092 |
223 |
| 5 |
38.3933 |
2025-06-05 00:00:00.0 |
7.2848 |
223 |
| 6 |
43.7919 |
2025-06-06 00:00:00.0 |
5.3986 |
223 |
| 7 |
51.0014 |
2025-06-07 00:00:00.0 |
7.2095 |
223 |
| 8 |
59.6278 |
2025-06-08 00:00:00.0 |
8.6264 |
223 |
| 9 |
65.1358 |
2025-06-09 00:00:00.0 |
5.5080 |
223 |
| 10 |
69.5431 |
2025-06-10 00:00:00.0 |
4.4073 |
223 |
| 11 |
75.8860 |
2025-06-11 00:00:00.0 |
6.3429 |
223 |
| 12 |
80.8048 |
2025-06-12 00:00:00.0 |
4.9188 |
223 |
| 13 |
88.7164 |
2025-06-13 00:00:00.0 |
7.9116 |
223 |
| 14 |
96.1112 |
2025-06-14 00:00:00.0 |
7.3948 |
223 |
| 15 |
103.7186 |
2025-06-15 00:00:00.0 |
7.6074 |
223 |
| 16 |
111.3946 |
2025-06-16 00:00:00.0 |
7.6760 |
223 |
| 17 |
120.9384 |
2025-06-17 00:00:00.0 |
9.5438 |
223 |
| 18 |
129.6763 |
2025-06-18 00:00:00.0 |
8.7379 |
223 |
| 19 |
137.4488 |
2025-06-19 00:00:00.0 |
7.7725 |
223 |
| 20 |
146.0245 |
2025-06-20 00:00:00.0 |
8.5757 |
223 |
| 21 |
154.0691 |
2025-06-21 00:00:00.0 |
8.0446 |
223 |
| 22 |
162.1000 |
2025-06-22 00:00:00.0 |
8.0309 |
223 |
| 23 |
170.8888 |
2025-06-23 00:00:00.0 |
8.7888 |
223 |
| 24 |
177.9908 |
2025-06-24 00:00:00.0 |
7.1020 |
223 |
| 25 |
183.4285 |
2025-06-25 00:00:00.0 |
5.4377 |
223 |
| 26 |
191.8433 |
2025-06-26 00:00:00.0 |
8.4148 |
223 |
| 27 |
200.6069 |
2025-06-27 00:00:00.0 |
8.7636 |
223 |
| 28 |
208.1855 |
2025-06-28 00:00:00.0 |
7.5786 |
223 |
| 29 |
215.5389 |
2025-06-29 00:00:00.0 |
7.3534 |
223 |
| 30 |
224.5211 |
2025-06-30 00:00:00.0 |
8.9822 |
223 |
| 31 |
233.5223 |
2025-07-01 00:00:00.0 |
9.0012 |
223 |
| 32 |
242.0334 |
2025-07-02 00:00:00.0 |
8.5111 |
223 |
| 33 |
250.2871 |
2025-07-03 00:00:00.0 |
8.2537 |
223 |
| 34 |
257.2342 |
2025-07-04 00:00:00.0 |
6.9471 |
223 |
| 35 |
264.1135 |
2025-07-05 00:00:00.0 |
6.8793 |
223 |
| 36 |
273.0756 |
2025-07-06 00:00:00.0 |
8.9621 |
223 |
| 37 |
281.0468 |
2025-07-07 00:00:00.0 |
7.9712 |
223 |
| 38 |
288.7795 |
2025-07-08 00:00:00.0 |
7.7327 |
223 |
| 39 |
297.0837 |
2025-07-09 00:00:00.0 |
8.3042 |
223 |
| 40 |
304.9955 |
2025-07-10 00:00:00.0 |
7.9118 |
223 |
| 41 |
311.9491 |
2025-07-11 00:00:00.0 |
6.9536 |
223 |
| 42 |
321.5051 |
2025-07-12 00:00:00.0 |
9.5560 |
223 |
| 43 |
330.1551 |
2025-07-13 00:00:00.0 |
8.6500 |
223 |
| 44 |
339.1681 |
2025-07-14 00:00:00.0 |
9.0130 |
223 |
| 45 |
348.4206 |
2025-07-15 00:00:00.0 |
9.2525 |
223 |
| 46 |
356.6928 |
2025-07-16 00:00:00.0 |
8.2722 |
223 |
| 47 |
362.5698 |
2025-07-17 00:00:00.0 |
5.8770 |
223 |
| 48 |
368.2724 |
2025-07-18 00:00:00.0 |
5.7026 |
223 |
| 49 |
376.2140 |
2025-07-19 00:00:00.0 |
7.9416 |
223 |
| 50 |
384.1142 |
2025-07-20 00:00:00.0 |
7.9002 |
223 |
| 51 |
391.8766 |
2025-07-21 00:00:00.0 |
7.7624 |
223 |
| 52 |
400.8085 |
2025-07-22 00:00:00.0 |
8.9319 |
223 |
| 53 |
410.3741 |
2025-07-23 00:00:00.0 |
9.5656 |
223 |
| 54 |
419.5514 |
2025-07-24 00:00:00.0 |
9.1773 |
223 |
| 55 |
428.5579 |
2025-07-25 00:00:00.0 |
9.0065 |
223 |
| 56 |
436.1160 |
2025-07-26 00:00:00.0 |
7.5581 |
223 |
| 57 |
443.6523 |
2025-07-27 00:00:00.0 |
7.5363 |
223 |
| 58 |
453.1737 |
2025-07-28 00:00:00.0 |
9.5214 |
223 |
| 59 |
462.0323 |
2025-07-29 00:00:00.0 |
8.8586 |
223 |
| 60 |
470.3808 |
2025-07-30 00:00:00.0 |
8.3485 |
223 |
| 61 |
476.8537 |
2025-07-31 00:00:00.0 |
6.4729 |
223 |
| 62 |
483.4767 |
2025-08-01 00:00:00.0 |
6.6230 |
223 |
| 63 |
491.3812 |
2025-08-02 00:00:00.0 |
7.9045 |
223 |
| 64 |
500.6121 |
2025-08-03 00:00:00.0 |
9.2309 |
223 |
| 65 |
508.7269 |
2025-08-04 00:00:00.0 |
8.1148 |
223 |
| 66 |
517.6393 |
2025-08-05 00:00:00.0 |
8.9124 |
223 |
| 67 |
526.8709 |
2025-08-06 00:00:00.0 |
9.2316 |
223 |
| 68 |
536.2421 |
2025-08-07 00:00:00.0 |
9.3712 |
223 |
| 69 |
543.9077 |
2025-08-08 00:00:00.0 |
7.6656 |
223 |
| 70 |
553.3337 |
2025-08-09 00:00:00.0 |
9.4260 |
223 |
| 71 |
562.8323 |
2025-08-10 00:00:00.0 |
9.4986 |
223 |
| 72 |
572.1322 |
2025-08-11 00:00:00.0 |
9.2999 |
223 |
| 73 |
581.5528 |
2025-08-12 00:00:00.0 |
9.4206 |
223 |
| 74 |
590.4148 |
2025-08-13 00:00:00.0 |
8.8620 |
223 |
| 75 |
597.0960 |
2025-08-14 00:00:00.0 |
6.6812 |
223 |
| 76 |
605.4740 |
2025-08-15 00:00:00.0 |
8.3780 |
223 |
| 77 |
614.2890 |
2025-08-16 00:00:00.0 |
8.8150 |
223 |
| 78 |
622.5270 |
2025-08-17 00:00:00.0 |
8.2380 |
223 |
| 79 |
630.9867 |
2025-08-18 00:00:00.0 |
8.4597 |
223 |
| 80 |
640.5312 |
2025-08-19 00:00:00.0 |
9.5445 |
223 |
| 81 |
649.5048 |
2025-08-20 00:00:00.0 |
8.9736 |
223 |
| 82 |
658.1040 |
2025-08-21 00:00:00.0 |
8.5992 |
223 |
| 83 |
667.2006 |
2025-08-22 00:00:00.0 |
9.0966 |
223 |
| 84 |
675.5645 |
2025-08-23 00:00:00.0 |
8.3639 |
223 |
| 85 |
683.0815 |
2025-08-24 00:00:00.0 |
7.5170 |
223 |
| 86 |
688.6635 |
2025-08-25 00:00:00.0 |
5.5820 |
223 |
| 87 |
693.2188 |
2025-08-26 00:00:00.0 |
4.5553 |
223 |
| 88 |
701.4081 |
2025-08-27 00:00:00.0 |
8.1893 |
223 |
| 89 |
710.5003 |
2025-08-28 00:00:00.0 |
9.0922 |
223 |
| 90 |
718.2233 |
2025-08-29 00:00:00.0 |
7.7230 |
223 |
| 91 |
726.0546 |
2025-08-30 00:00:00.0 |
7.8313 |
223 |
| 92 |
733.7202 |
2025-08-31 00:00:00.0 |
7.6656 |
223 |
| 93 |
741.8632 |
2025-09-01 00:00:00.0 |
8.1430 |
223 |
| 94 |
750.7867 |
2025-09-02 00:00:00.0 |
8.9235 |
223 |
| 95 |
756.3649 |
2025-09-03 00:00:00.0 |
5.5782 |
223 |
| 96 |
759.3362 |
2025-09-04 00:00:00.0 |
2.9713 |
223 |
| 97 |
759.6213 |
2025-09-05 00:00:00.0 |
0.2851 |
223 |
| 98 |
763.8381 |
2025-09-06 00:00:00.0 |
4.2168 |
223 |
| 99 |
767.3375 |
2025-09-07 00:00:00.0 |
3.4994 |
223 |
| 100 |
770.5564 |
2025-09-08 00:00:00.0 |
3.2189 |
223 |
| 101 |
777.5346 |
2025-09-09 00:00:00.0 |
6.9782 |
223 |
| 102 |
784.2225 |
2025-09-10 00:00:00.0 |
6.6879 |
223 |
| 103 |
791.0891 |
2025-09-11 00:00:00.0 |
6.8666 |
223 |
| 104 |
799.8175 |
2025-09-12 00:00:00.0 |
8.7284 |
223 |
| 105 |
808.9888 |
2025-09-13 00:00:00.0 |
9.1713 |
223 |
| 106 |
818.2744 |
2025-09-14 00:00:00.0 |
9.2856 |
223 |
| 107 |
827.9465 |
2025-09-15 00:00:00.0 |
9.6721 |
223 |
| 108 |
836.6678 |
2025-09-16 00:00:00.0 |
8.7213 |
223 |
| 109 |
845.9504 |
2025-09-17 00:00:00.0 |
9.2826 |
223 |
| 110 |
854.8423 |
2025-09-18 00:00:00.0 |
8.8919 |
223 |
| 111 |
863.1665 |
2025-09-19 00:00:00.0 |
8.3242 |
223 |
| 112 |
871.6814 |
2025-09-20 00:00:00.0 |
8.5149 |
223 |
| 113 |
880.7943 |
2025-09-21 00:00:00.0 |
9.1129 |
223 |
| 114 |
889.4585 |
2025-09-22 00:00:00.0 |
8.6642 |
223 |
| 115 |
897.8040 |
2025-09-23 00:00:00.0 |
8.3455 |
223 |
| 116 |
897.8040 |
2025-09-24 00:00:00.0 |
0.0000 |
223 |
| 117 |
897.8040 |
2025-09-25 00:00:00.0 |
0.0000 |
223 |
| 118 |
897.8040 |
2025-09-26 00:00:00.0 |
0.0000 |
223 |
| 119 |
897.8040 |
2025-09-27 00:00:00.0 |
0.0000 |
223 |
| 120 |
897.8040 |
2025-09-28 00:00:00.0 |
0.0000 |
223 |
| 121 |
897.8040 |
2025-09-29 00:00:00.0 |
0.0000 |
223 |
| 122 |
897.8040 |
2025-09-30 00:00:00.0 |
0.0000 |
223 |
| 123 |
897.8040 |
2025-10-01 00:00:00.0 |
0.0000 |
223 |
| 124 |
897.8040 |
2025-10-02 00:00:00.0 |
0.0000 |
223 |
| 125 |
897.8040 |
2025-10-03 00:00:00.0 |
0.0000 |
223 |
| 126 |
897.8040 |
2025-10-04 00:00:00.0 |
0.0000 |
223 |
| 127 |
897.8040 |
2025-10-05 00:00:00.0 |
0.0000 |
223 |
| 128 |
897.8040 |
2025-10-06 00:00:00.0 |
0.0000 |
223 |
| 129 |
897.8040 |
2025-10-07 00:00:00.0 |
0.0000 |
223 |
| 130 |
898.1958 |
2025-10-08 00:00:00.0 |
0.3918 |
223 |
| 131 |
902.0229 |
2025-10-09 00:00:00.0 |
3.8271 |
223 |
| 132 |
908.0076 |
2025-10-10 00:00:00.0 |
5.9847 |
223 |
| 133 |
911.4814 |
2025-10-11 00:00:00.0 |
3.4738 |
223 |
| 134 |
916.5446 |
2025-10-12 00:00:00.0 |
5.0632 |
223 |
| 135 |
921.8264 |
2025-10-13 00:00:00.0 |
5.2818 |
223 |
| 136 |
922.0639 |
2025-10-14 00:00:00.0 |
0.2375 |
223 |
| 137 |
922.0639 |
2025-10-15 00:00:00.0 |
0.0000 |
223 |
| 138 |
924.3704 |
2025-10-16 00:00:00.0 |
2.3065 |
223 |
| 139 |
928.0224 |
2025-10-17 00:00:00.0 |
3.6520 |
223 |
| 140 |
933.7812 |
2025-10-18 00:00:00.0 |
5.7588 |
223 |
| 141 |
935.0730 |
2025-10-19 00:00:00.0 |
1.2918 |
223 |
| 142 |
936.1757 |
2025-10-20 00:00:00.0 |
1.1027 |
223 |
| 143 |
936.3644 |
2025-10-21 00:00:00.0 |
0.1887 |
223 |
| 144 |
936.3822 |
2025-10-22 00:00:00.0 |
0.0178 |
223 |
| 145 |
936.3822 |
2025-10-23 00:00:00.0 |
0.0000 |
223 |
| 146 |
936.5041 |
2025-10-24 00:00:00.0 |
0.1219 |
223 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '223') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-24'}
ORDER BY ddate ASC |