| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.4740 |
2026-06-01 00:00:00.0 |
7.4740 |
212 |
| 2 |
16.1698 |
2026-06-02 00:00:00.0 |
8.6958 |
212 |
| 3 |
22.9250 |
2026-06-03 00:00:00.0 |
6.7552 |
212 |
| 4 |
32.2373 |
2026-06-04 00:00:00.0 |
9.3123 |
212 |
| 5 |
41.0122 |
2026-06-05 00:00:00.0 |
8.7749 |
212 |
| 6 |
49.3213 |
2026-06-06 00:00:00.0 |
8.3091 |
212 |
| 7 |
56.3349 |
2026-06-07 00:00:00.0 |
7.0136 |
212 |
| 8 |
61.4515 |
2026-06-08 00:00:00.0 |
5.1166 |
212 |
| 9 |
70.1992 |
2026-06-09 00:00:00.0 |
8.7477 |
212 |
| 10 |
76.3547 |
2026-06-10 00:00:00.0 |
6.1555 |
212 |
| 11 |
85.5993 |
2026-06-11 00:00:00.0 |
9.2446 |
212 |
| 12 |
94.5602 |
2026-06-12 00:00:00.0 |
8.9609 |
212 |
| 13 |
102.5987 |
2026-06-13 00:00:00.0 |
8.0385 |
212 |
| 14 |
108.3433 |
2026-06-14 00:00:00.0 |
5.7446 |
212 |
| 15 |
115.3020 |
2026-06-15 00:00:00.0 |
6.9587 |
212 |
| 16 |
122.4109 |
2026-06-16 00:00:00.0 |
7.1089 |
212 |
| 17 |
128.9615 |
2026-06-17 00:00:00.0 |
6.5506 |
212 |
| 18 |
135.2068 |
2026-06-18 00:00:00.0 |
6.2453 |
212 |
| 19 |
140.9174 |
2026-06-19 00:00:00.0 |
5.7106 |
212 |
| 20 |
149.2666 |
2026-06-20 00:00:00.0 |
8.3492 |
212 |
| 21 |
155.3529 |
2026-06-21 00:00:00.0 |
6.0863 |
212 |
| 22 |
160.6468 |
2026-06-22 00:00:00.0 |
5.2939 |
212 |
| 23 |
167.6520 |
2026-06-23 00:00:00.0 |
7.0052 |
212 |
| 24 |
176.0968 |
2026-06-24 00:00:00.0 |
8.4448 |
212 |
| 25 |
184.9891 |
2026-06-25 00:00:00.0 |
8.8923 |
212 |
| 26 |
193.3212 |
2026-06-26 00:00:00.0 |
8.3321 |
212 |
| 27 |
201.6046 |
2026-06-27 00:00:00.0 |
8.2834 |
212 |
| 28 |
210.8129 |
2026-06-28 00:00:00.0 |
9.2083 |
212 |
| 29 |
219.9480 |
2026-06-29 00:00:00.0 |
9.1351 |
212 |
| 30 |
229.3553 |
2026-06-30 00:00:00.0 |
9.4073 |
212 |
| 31 |
238.6657 |
2026-07-01 00:00:00.0 |
9.3104 |
212 |
| 32 |
248.1975 |
2026-07-02 00:00:00.0 |
9.5318 |
212 |
| 33 |
257.3228 |
2026-07-03 00:00:00.0 |
9.1253 |
212 |
| 34 |
265.7033 |
2026-07-04 00:00:00.0 |
8.3805 |
212 |
| 35 |
274.0061 |
2026-07-05 00:00:00.0 |
8.3028 |
212 |
| 36 |
281.3559 |
2026-07-06 00:00:00.0 |
7.3498 |
212 |
| 37 |
290.1966 |
2026-07-07 00:00:00.0 |
8.8407 |
212 |
| 38 |
299.5374 |
2026-07-08 00:00:00.0 |
9.3408 |
212 |
| 39 |
308.2210 |
2026-07-09 00:00:00.0 |
8.6836 |
212 |
| 40 |
316.5251 |
2026-07-10 00:00:00.0 |
8.3041 |
212 |
| 41 |
324.5968 |
2026-07-11 00:00:00.0 |
8.0717 |
212 |
| 42 |
331.7749 |
2026-07-12 00:00:00.0 |
7.1781 |
212 |
| 43 |
336.3459 |
2026-07-13 00:00:00.0 |
4.5710 |
212 |
| 44 |
340.3012 |
2026-07-14 00:00:00.0 |
3.9553 |
212 |
| 45 |
349.2300 |
2026-07-15 00:00:00.0 |
8.9288 |
212 |
| 46 |
358.9389 |
2026-07-16 00:00:00.0 |
9.7089 |
212 |
| 47 |
368.2677 |
2026-07-17 00:00:00.0 |
9.3288 |
212 |
| 48 |
377.4113 |
2026-07-18 00:00:00.0 |
9.1436 |
212 |
| 49 |
384.9019 |
2026-07-19 00:00:00.0 |
7.4906 |
212 |
| 50 |
392.0458 |
2026-07-20 00:00:00.0 |
7.1439 |
212 |
| 51 |
401.2190 |
2026-07-21 00:00:00.0 |
9.1732 |
212 |
| 52 |
409.8820 |
2026-07-22 00:00:00.0 |
8.6630 |
212 |
| 53 |
417.7758 |
2026-07-23 00:00:00.0 |
7.8938 |
212 |
| 54 |
426.1274 |
2026-07-24 00:00:00.0 |
8.3516 |
212 |
| 55 |
433.6306 |
2026-07-25 00:00:00.0 |
7.5032 |
212 |
| 56 |
442.3857 |
2026-07-26 00:00:00.0 |
8.7551 |
212 |
| 57 |
450.5000 |
2026-07-27 00:00:00.0 |
8.1143 |
212 |
| 58 |
458.9673 |
2026-07-28 00:00:00.0 |
8.4673 |
212 |
| 59 |
466.5293 |
2026-07-29 00:00:00.0 |
7.5620 |
212 |
| 60 |
472.7790 |
2026-07-30 00:00:00.0 |
6.2497 |
212 |
| 61 |
480.9661 |
2026-07-31 00:00:00.0 |
8.1871 |
212 |
| 62 |
489.8373 |
2026-08-01 00:00:00.0 |
8.8712 |
212 |
| 63 |
498.7182 |
2026-08-02 00:00:00.0 |
8.8809 |
212 |
| 64 |
505.9758 |
2026-08-03 00:00:00.0 |
7.2576 |
212 |
| 65 |
515.0612 |
2026-08-04 00:00:00.0 |
9.0854 |
212 |
| 66 |
522.6651 |
2026-08-05 00:00:00.0 |
7.6039 |
212 |
| 67 |
529.7443 |
2026-08-06 00:00:00.0 |
7.0792 |
212 |
| 68 |
537.1540 |
2026-08-07 00:00:00.0 |
7.4097 |
212 |
| 69 |
545.6161 |
2026-08-08 00:00:00.0 |
8.4621 |
212 |
| 70 |
553.2231 |
2026-08-09 00:00:00.0 |
7.6070 |
212 |
| 71 |
561.1196 |
2026-08-10 00:00:00.0 |
7.8965 |
212 |
| 72 |
569.8983 |
2026-08-11 00:00:00.0 |
8.7787 |
212 |
| 73 |
577.2496 |
2026-08-12 00:00:00.0 |
7.3513 |
212 |
| 74 |
585.3397 |
2026-08-13 00:00:00.0 |
8.0901 |
212 |
| 75 |
593.5009 |
2026-08-14 00:00:00.0 |
8.1612 |
212 |
| 76 |
602.8189 |
2026-08-15 00:00:00.0 |
9.3180 |
212 |
| 77 |
612.3864 |
2026-08-16 00:00:00.0 |
9.5675 |
212 |
| 78 |
620.9580 |
2026-08-17 00:00:00.0 |
8.5716 |
212 |
| 79 |
629.1884 |
2026-08-18 00:00:00.0 |
8.2304 |
212 |
| 80 |
636.5257 |
2026-08-19 00:00:00.0 |
7.3373 |
212 |
| 81 |
642.7747 |
2026-08-20 00:00:00.0 |
6.2490 |
212 |
| 82 |
650.9245 |
2026-08-21 00:00:00.0 |
8.1498 |
212 |
| 83 |
659.2263 |
2026-08-22 00:00:00.0 |
8.3018 |
212 |
| 84 |
667.0571 |
2026-08-23 00:00:00.0 |
7.8308 |
212 |
| 85 |
673.4905 |
2026-08-24 00:00:00.0 |
6.4334 |
212 |
| 86 |
681.8800 |
2026-08-25 00:00:00.0 |
8.3895 |
212 |
| 87 |
691.4689 |
2026-08-26 00:00:00.0 |
9.5889 |
212 |
| 88 |
700.1214 |
2026-08-27 00:00:00.0 |
8.6525 |
212 |
| 89 |
708.1587 |
2026-08-28 00:00:00.0 |
8.0373 |
212 |
| 90 |
715.4229 |
2026-08-29 00:00:00.0 |
7.2642 |
212 |
| 91 |
723.7078 |
2026-08-30 00:00:00.0 |
8.2849 |
212 |
| 92 |
732.2196 |
2026-08-31 00:00:00.0 |
8.5118 |
212 |
| 93 |
741.3091 |
2026-09-01 00:00:00.0 |
9.0895 |
212 |
| 94 |
750.2812 |
2026-09-02 00:00:00.0 |
8.9721 |
212 |
| 95 |
758.6398 |
2026-09-03 00:00:00.0 |
8.3586 |
212 |
| 96 |
766.9156 |
2026-09-04 00:00:00.0 |
8.2758 |
212 |
| 97 |
775.6809 |
2026-09-05 00:00:00.0 |
8.7653 |
212 |
| 98 |
784.8680 |
2026-09-06 00:00:00.0 |
9.1871 |
212 |
| 99 |
793.4672 |
2026-09-07 00:00:00.0 |
8.5992 |
212 |
| 100 |
803.2983 |
2026-09-08 00:00:00.0 |
9.8311 |
212 |
| 101 |
812.8471 |
2026-09-09 00:00:00.0 |
9.5488 |
212 |
| 102 |
820.8122 |
2026-09-10 00:00:00.0 |
7.9651 |
212 |
| 103 |
827.6761 |
2026-09-11 00:00:00.0 |
6.8639 |
212 |
| 104 |
836.4009 |
2026-09-12 00:00:00.0 |
8.7248 |
212 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '212') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-09-12'}
ORDER BY ddate ASC |
