| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
8.3225 |
2026-06-01 00:00:00.0 |
8.3225 |
548 |
| 2 |
16.3880 |
2026-06-02 00:00:00.0 |
8.0655 |
548 |
| 3 |
24.2770 |
2026-06-03 00:00:00.0 |
7.8890 |
548 |
| 4 |
33.0242 |
2026-06-04 00:00:00.0 |
8.7472 |
548 |
| 5 |
40.4707 |
2026-06-05 00:00:00.0 |
7.4465 |
548 |
| 6 |
48.3942 |
2026-06-06 00:00:00.0 |
7.9235 |
548 |
| 7 |
55.8253 |
2026-06-07 00:00:00.0 |
7.4311 |
548 |
| 8 |
63.4433 |
2026-06-08 00:00:00.0 |
7.6180 |
548 |
| 9 |
71.6280 |
2026-06-09 00:00:00.0 |
8.1847 |
548 |
| 10 |
79.0410 |
2026-06-10 00:00:00.0 |
7.4130 |
548 |
| 11 |
88.1821 |
2026-06-11 00:00:00.0 |
9.1411 |
548 |
| 12 |
96.1801 |
2026-06-12 00:00:00.0 |
7.9980 |
548 |
| 13 |
102.4710 |
2026-06-13 00:00:00.0 |
6.2909 |
548 |
| 14 |
109.0671 |
2026-06-14 00:00:00.0 |
6.5961 |
548 |
| 15 |
114.8535 |
2026-06-15 00:00:00.0 |
5.7864 |
548 |
| 16 |
121.6889 |
2026-06-16 00:00:00.0 |
6.8354 |
548 |
| 17 |
126.2043 |
2026-06-17 00:00:00.0 |
4.5154 |
548 |
| 18 |
132.1782 |
2026-06-18 00:00:00.0 |
5.9739 |
548 |
| 19 |
139.1375 |
2026-06-19 00:00:00.0 |
6.9593 |
548 |
| 20 |
145.6413 |
2026-06-20 00:00:00.0 |
6.5038 |
548 |
| 21 |
150.9529 |
2026-06-21 00:00:00.0 |
5.3116 |
548 |
| 22 |
156.8383 |
2026-06-22 00:00:00.0 |
5.8854 |
548 |
| 23 |
164.1528 |
2026-06-23 00:00:00.0 |
7.3145 |
548 |
| 24 |
171.5232 |
2026-06-24 00:00:00.0 |
7.3704 |
548 |
| 25 |
179.7455 |
2026-06-25 00:00:00.0 |
8.2223 |
548 |
| 26 |
186.9471 |
2026-06-26 00:00:00.0 |
7.2016 |
548 |
| 27 |
195.5700 |
2026-06-27 00:00:00.0 |
8.6229 |
548 |
| 28 |
204.6601 |
2026-06-28 00:00:00.0 |
9.0901 |
548 |
| 29 |
213.9094 |
2026-06-29 00:00:00.0 |
9.2493 |
548 |
| 30 |
223.1112 |
2026-06-30 00:00:00.0 |
9.2018 |
548 |
| 31 |
232.3729 |
2026-07-01 00:00:00.0 |
9.2617 |
548 |
| 32 |
241.4921 |
2026-07-02 00:00:00.0 |
9.1192 |
548 |
| 33 |
249.6942 |
2026-07-03 00:00:00.0 |
8.2021 |
548 |
| 34 |
258.5349 |
2026-07-04 00:00:00.0 |
8.8407 |
548 |
| 35 |
267.2067 |
2026-07-05 00:00:00.0 |
8.6718 |
548 |
| 36 |
274.6315 |
2026-07-06 00:00:00.0 |
7.4248 |
548 |
| 37 |
283.6007 |
2026-07-07 00:00:00.0 |
8.9692 |
548 |
| 38 |
291.6928 |
2026-07-08 00:00:00.0 |
8.0921 |
548 |
| 39 |
300.1574 |
2026-07-09 00:00:00.0 |
8.4646 |
548 |
| 40 |
309.1070 |
2026-07-10 00:00:00.0 |
8.9496 |
548 |
| 41 |
317.9173 |
2026-07-11 00:00:00.0 |
8.8103 |
548 |
| 42 |
324.9021 |
2026-07-12 00:00:00.0 |
6.9848 |
548 |
| 43 |
329.8590 |
2026-07-13 00:00:00.0 |
4.9569 |
548 |
| 44 |
336.3908 |
2026-07-14 00:00:00.0 |
6.5318 |
548 |
| 45 |
345.4803 |
2026-07-15 00:00:00.0 |
9.0895 |
548 |
| 46 |
354.8597 |
2026-07-16 00:00:00.0 |
9.3794 |
548 |
| 47 |
364.2249 |
2026-07-17 00:00:00.0 |
9.3652 |
548 |
| 48 |
373.0300 |
2026-07-18 00:00:00.0 |
8.8051 |
548 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '548') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-07-18'}
ORDER BY ddate ASC |
