| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.2737 |
2026-06-01 00:00:00.0 |
7.2737 |
235 |
| 2 |
15.8082 |
2026-06-02 00:00:00.0 |
8.5345 |
235 |
| 3 |
22.8737 |
2026-06-03 00:00:00.0 |
7.0655 |
235 |
| 4 |
32.3158 |
2026-06-04 00:00:00.0 |
9.4421 |
235 |
| 5 |
41.0106 |
2026-06-05 00:00:00.0 |
8.6948 |
235 |
| 6 |
49.5212 |
2026-06-06 00:00:00.0 |
8.5106 |
235 |
| 7 |
56.2548 |
2026-06-07 00:00:00.0 |
6.7336 |
235 |
| 8 |
61.3714 |
2026-06-08 00:00:00.0 |
5.1166 |
235 |
| 9 |
70.2790 |
2026-06-09 00:00:00.0 |
8.9076 |
235 |
| 10 |
77.0495 |
2026-06-10 00:00:00.0 |
6.7705 |
235 |
| 11 |
86.3958 |
2026-06-11 00:00:00.0 |
9.3463 |
235 |
| 12 |
95.2710 |
2026-06-12 00:00:00.0 |
8.8752 |
235 |
| 13 |
102.4930 |
2026-06-13 00:00:00.0 |
7.2220 |
235 |
| 14 |
108.5094 |
2026-06-14 00:00:00.0 |
6.0164 |
235 |
| 15 |
115.0853 |
2026-06-15 00:00:00.0 |
6.5759 |
235 |
| 16 |
122.3537 |
2026-06-16 00:00:00.0 |
7.2684 |
235 |
| 17 |
129.5210 |
2026-06-17 00:00:00.0 |
7.1673 |
235 |
| 18 |
136.3069 |
2026-06-18 00:00:00.0 |
6.7859 |
235 |
| 19 |
142.1774 |
2026-06-19 00:00:00.0 |
5.8705 |
235 |
| 20 |
149.9073 |
2026-06-20 00:00:00.0 |
7.7299 |
235 |
| 21 |
156.3852 |
2026-06-21 00:00:00.0 |
6.4779 |
235 |
| 22 |
161.8733 |
2026-06-22 00:00:00.0 |
5.4881 |
235 |
| 23 |
170.0632 |
2026-06-23 00:00:00.0 |
8.1899 |
235 |
| 24 |
177.9060 |
2026-06-24 00:00:00.0 |
7.8428 |
235 |
| 25 |
186.8223 |
2026-06-25 00:00:00.0 |
8.9163 |
235 |
| 26 |
195.2408 |
2026-06-26 00:00:00.0 |
8.4185 |
235 |
| 27 |
203.6154 |
2026-06-27 00:00:00.0 |
8.3746 |
235 |
| 28 |
212.4898 |
2026-06-28 00:00:00.0 |
8.8744 |
235 |
| 29 |
221.6410 |
2026-06-29 00:00:00.0 |
9.1512 |
235 |
| 30 |
230.8146 |
2026-06-30 00:00:00.0 |
9.1736 |
235 |
| 31 |
240.3109 |
2026-07-01 00:00:00.0 |
9.4963 |
235 |
| 32 |
249.9188 |
2026-07-02 00:00:00.0 |
9.6079 |
235 |
| 33 |
258.5439 |
2026-07-03 00:00:00.0 |
8.6251 |
235 |
| 34 |
267.2707 |
2026-07-04 00:00:00.0 |
8.7268 |
235 |
| 35 |
275.3148 |
2026-07-05 00:00:00.0 |
8.0441 |
235 |
| 36 |
282.8768 |
2026-07-06 00:00:00.0 |
7.5620 |
235 |
| 37 |
292.0446 |
2026-07-07 00:00:00.0 |
9.1678 |
235 |
| 38 |
301.2058 |
2026-07-08 00:00:00.0 |
9.1612 |
235 |
| 39 |
309.7586 |
2026-07-09 00:00:00.0 |
8.5528 |
235 |
| 40 |
318.4971 |
2026-07-10 00:00:00.0 |
8.7385 |
235 |
| 41 |
326.4372 |
2026-07-11 00:00:00.0 |
7.9401 |
235 |
| 42 |
333.2022 |
2026-07-12 00:00:00.0 |
6.7650 |
235 |
| 43 |
337.6304 |
2026-07-13 00:00:00.0 |
4.4282 |
235 |
| 44 |
342.7635 |
2026-07-14 00:00:00.0 |
5.1331 |
235 |
| 45 |
351.4935 |
2026-07-15 00:00:00.0 |
8.7300 |
235 |
| 46 |
361.2607 |
2026-07-16 00:00:00.0 |
9.7672 |
235 |
| 47 |
370.6602 |
2026-07-17 00:00:00.0 |
9.3995 |
235 |
| 48 |
379.6698 |
2026-07-18 00:00:00.0 |
9.0096 |
235 |
| 49 |
386.4134 |
2026-07-19 00:00:00.0 |
6.7436 |
235 |
| 50 |
393.6027 |
2026-07-20 00:00:00.0 |
7.1893 |
235 |
| 51 |
402.8933 |
2026-07-21 00:00:00.0 |
9.2906 |
235 |
| 52 |
411.6403 |
2026-07-22 00:00:00.0 |
8.7470 |
235 |
| 53 |
420.0348 |
2026-07-23 00:00:00.0 |
8.3945 |
235 |
| 54 |
428.4830 |
2026-07-24 00:00:00.0 |
8.4482 |
235 |
| 55 |
436.0844 |
2026-07-25 00:00:00.0 |
7.6014 |
235 |
| 56 |
444.6577 |
2026-07-26 00:00:00.0 |
8.5733 |
235 |
| 57 |
453.1309 |
2026-07-27 00:00:00.0 |
8.4732 |
235 |
| 58 |
461.8457 |
2026-07-28 00:00:00.0 |
8.7148 |
235 |
| 59 |
469.2060 |
2026-07-29 00:00:00.0 |
7.3603 |
235 |
| 60 |
475.8198 |
2026-07-30 00:00:00.0 |
6.6138 |
235 |
| 61 |
484.7838 |
2026-07-31 00:00:00.0 |
8.9640 |
235 |
| 62 |
493.8907 |
2026-08-01 00:00:00.0 |
9.1069 |
235 |
| 63 |
502.9821 |
2026-08-02 00:00:00.0 |
9.0914 |
235 |
| 64 |
510.2647 |
2026-08-03 00:00:00.0 |
7.2826 |
235 |
| 65 |
519.2356 |
2026-08-04 00:00:00.0 |
8.9709 |
235 |
| 66 |
526.8226 |
2026-08-05 00:00:00.0 |
7.5870 |
235 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '235') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-08-05'}
ORDER BY ddate ASC |
