| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.3338 |
2026-06-01 00:00:00.0 |
7.3338 |
210 |
| 2 |
15.3551 |
2026-06-02 00:00:00.0 |
8.0213 |
210 |
| 3 |
22.8800 |
2026-06-03 00:00:00.0 |
7.5249 |
210 |
| 4 |
32.4265 |
2026-06-04 00:00:00.0 |
9.5465 |
210 |
| 5 |
41.6438 |
2026-06-05 00:00:00.0 |
9.2173 |
210 |
| 6 |
49.6273 |
2026-06-06 00:00:00.0 |
7.9835 |
210 |
| 7 |
56.6245 |
2026-06-07 00:00:00.0 |
6.9972 |
210 |
| 8 |
61.4030 |
2026-06-08 00:00:00.0 |
4.7785 |
210 |
| 9 |
69.8808 |
2026-06-09 00:00:00.0 |
8.4778 |
210 |
| 10 |
76.9479 |
2026-06-10 00:00:00.0 |
7.0671 |
210 |
| 11 |
86.3261 |
2026-06-11 00:00:00.0 |
9.3782 |
210 |
| 12 |
95.2069 |
2026-06-12 00:00:00.0 |
8.8808 |
210 |
| 13 |
101.1790 |
2026-06-13 00:00:00.0 |
5.9721 |
210 |
| 14 |
105.6348 |
2026-06-14 00:00:00.0 |
4.4558 |
210 |
| 15 |
111.5608 |
2026-06-15 00:00:00.0 |
5.9260 |
210 |
| 16 |
117.9314 |
2026-06-16 00:00:00.0 |
6.3706 |
210 |
| 17 |
125.1039 |
2026-06-17 00:00:00.0 |
7.1725 |
210 |
| 18 |
132.8392 |
2026-06-18 00:00:00.0 |
7.7353 |
210 |
| 19 |
138.9811 |
2026-06-19 00:00:00.0 |
6.1419 |
210 |
| 20 |
147.1052 |
2026-06-20 00:00:00.0 |
8.1241 |
210 |
| 21 |
152.2966 |
2026-06-21 00:00:00.0 |
5.1914 |
210 |
| 22 |
157.7318 |
2026-06-22 00:00:00.0 |
5.4352 |
210 |
| 23 |
165.4452 |
2026-06-23 00:00:00.0 |
7.7134 |
210 |
| 24 |
173.7379 |
2026-06-24 00:00:00.0 |
8.2927 |
210 |
| 25 |
182.3909 |
2026-06-25 00:00:00.0 |
8.6530 |
210 |
| 26 |
190.9922 |
2026-06-26 00:00:00.0 |
8.6013 |
210 |
| 27 |
199.2948 |
2026-06-27 00:00:00.0 |
8.3026 |
210 |
| 28 |
208.3955 |
2026-06-28 00:00:00.0 |
9.1007 |
210 |
| 29 |
217.7071 |
2026-06-29 00:00:00.0 |
9.3116 |
210 |
| 30 |
226.8517 |
2026-06-30 00:00:00.0 |
9.1446 |
210 |
| 31 |
236.1205 |
2026-07-01 00:00:00.0 |
9.2688 |
210 |
| 32 |
245.8210 |
2026-07-02 00:00:00.0 |
9.7005 |
210 |
| 33 |
254.7732 |
2026-07-03 00:00:00.0 |
8.9522 |
210 |
| 34 |
263.8719 |
2026-07-04 00:00:00.0 |
9.0987 |
210 |
| 35 |
272.2184 |
2026-07-05 00:00:00.0 |
8.3465 |
210 |
| 36 |
279.5118 |
2026-07-06 00:00:00.0 |
7.2934 |
210 |
| 37 |
288.4363 |
2026-07-07 00:00:00.0 |
8.9245 |
210 |
| 38 |
297.6195 |
2026-07-08 00:00:00.0 |
9.1832 |
210 |
| 39 |
306.4586 |
2026-07-09 00:00:00.0 |
8.8391 |
210 |
| 40 |
314.7836 |
2026-07-10 00:00:00.0 |
8.3250 |
210 |
| 41 |
323.5545 |
2026-07-11 00:00:00.0 |
8.7709 |
210 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '210') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-07-11'}
ORDER BY ddate ASC |
