| 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 |
|
| 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-06-15'}
ORDER BY ddate ASC |