| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.8272 |
2026-06-01 00:00:00.0 |
7.8272 |
243 |
| 2 |
16.5863 |
2026-06-02 00:00:00.0 |
8.7591 |
243 |
| 3 |
24.7488 |
2026-06-03 00:00:00.0 |
8.1625 |
243 |
| 4 |
34.2989 |
2026-06-04 00:00:00.0 |
9.5501 |
243 |
| 5 |
43.1955 |
2026-06-05 00:00:00.0 |
8.8966 |
243 |
| 6 |
51.0337 |
2026-06-06 00:00:00.0 |
7.8382 |
243 |
| 7 |
58.0782 |
2026-06-07 00:00:00.0 |
7.0445 |
243 |
| 8 |
62.9645 |
2026-06-08 00:00:00.0 |
4.8863 |
243 |
| 9 |
71.5961 |
2026-06-09 00:00:00.0 |
8.6316 |
243 |
| 10 |
78.6710 |
2026-06-10 00:00:00.0 |
7.0749 |
243 |
| 11 |
88.0916 |
2026-06-11 00:00:00.0 |
9.4206 |
243 |
| 12 |
96.7727 |
2026-06-12 00:00:00.0 |
8.6811 |
243 |
| 13 |
103.9009 |
2026-06-13 00:00:00.0 |
7.1282 |
243 |
| 14 |
108.6437 |
2026-06-14 00:00:00.0 |
4.7428 |
243 |
| 15 |
114.6438 |
2026-06-15 00:00:00.0 |
6.0001 |
243 |
| 16 |
121.1450 |
2026-06-16 00:00:00.0 |
6.5012 |
243 |
| 17 |
127.3271 |
2026-06-17 00:00:00.0 |
6.1821 |
243 |
| 18 |
134.9947 |
2026-06-18 00:00:00.0 |
7.6676 |
243 |
| 19 |
140.4786 |
2026-06-19 00:00:00.0 |
5.4839 |
243 |
| 20 |
148.4495 |
2026-06-20 00:00:00.0 |
7.9709 |
243 |
| 21 |
154.9768 |
2026-06-21 00:00:00.0 |
6.5273 |
243 |
| 22 |
160.5407 |
2026-06-22 00:00:00.0 |
5.5639 |
243 |
| 23 |
168.7888 |
2026-06-23 00:00:00.0 |
8.2481 |
243 |
| 24 |
176.8667 |
2026-06-24 00:00:00.0 |
8.0779 |
243 |
| 25 |
185.6933 |
2026-06-25 00:00:00.0 |
8.8266 |
243 |
| 26 |
193.5256 |
2026-06-26 00:00:00.0 |
7.8323 |
243 |
| 27 |
201.7758 |
2026-06-27 00:00:00.0 |
8.2502 |
243 |
| 28 |
211.1227 |
2026-06-28 00:00:00.0 |
9.3469 |
243 |
| 29 |
220.3169 |
2026-06-29 00:00:00.0 |
9.1942 |
243 |
| 30 |
229.4814 |
2026-06-30 00:00:00.0 |
9.1645 |
243 |
| 31 |
238.6661 |
2026-07-01 00:00:00.0 |
9.1847 |
243 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '243') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-07-01'}
ORDER BY ddate ASC |