| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.5520 |
2026-06-01 00:00:00.0 |
7.5520 |
240 |
| 2 |
16.0122 |
2026-06-02 00:00:00.0 |
8.4602 |
240 |
| 3 |
22.7268 |
2026-06-03 00:00:00.0 |
6.7146 |
240 |
| 4 |
31.5861 |
2026-06-04 00:00:00.0 |
8.8593 |
240 |
| 5 |
40.6119 |
2026-06-05 00:00:00.0 |
9.0258 |
240 |
| 6 |
49.4071 |
2026-06-06 00:00:00.0 |
8.7952 |
240 |
| 7 |
56.1322 |
2026-06-07 00:00:00.0 |
6.7251 |
240 |
| 8 |
62.6738 |
2026-06-08 00:00:00.0 |
6.5416 |
240 |
| 9 |
70.8957 |
2026-06-09 00:00:00.0 |
8.2219 |
240 |
| 10 |
76.6579 |
2026-06-10 00:00:00.0 |
5.7622 |
240 |
| 11 |
85.7579 |
2026-06-11 00:00:00.0 |
9.1000 |
240 |
| 12 |
94.2382 |
2026-06-12 00:00:00.0 |
8.4803 |
240 |
| 13 |
101.6159 |
2026-06-13 00:00:00.0 |
7.3777 |
240 |
| 14 |
106.8085 |
2026-06-14 00:00:00.0 |
5.1926 |
240 |
| 15 |
112.2910 |
2026-06-15 00:00:00.0 |
5.4825 |
240 |
| 16 |
119.2853 |
2026-06-16 00:00:00.0 |
6.9943 |
240 |
| 17 |
124.4900 |
2026-06-17 00:00:00.0 |
5.2047 |
240 |
| 18 |
130.3933 |
2026-06-18 00:00:00.0 |
5.9033 |
240 |
| 19 |
137.8585 |
2026-06-19 00:00:00.0 |
7.4652 |
240 |
| 20 |
145.0196 |
2026-06-20 00:00:00.0 |
7.1611 |
240 |
| 21 |
150.1637 |
2026-06-21 00:00:00.0 |
5.1441 |
240 |
| 22 |
155.5262 |
2026-06-22 00:00:00.0 |
5.3625 |
240 |
| 23 |
162.5102 |
2026-06-23 00:00:00.0 |
6.9840 |
240 |
| 24 |
170.4365 |
2026-06-24 00:00:00.0 |
7.9263 |
240 |
| 25 |
179.0594 |
2026-06-25 00:00:00.0 |
8.6229 |
240 |
| 26 |
185.5328 |
2026-06-26 00:00:00.0 |
6.4734 |
240 |
| 27 |
193.1165 |
2026-06-27 00:00:00.0 |
7.5837 |
240 |
| 28 |
202.5200 |
2026-06-28 00:00:00.0 |
9.4035 |
240 |
| 29 |
211.2002 |
2026-06-29 00:00:00.0 |
8.6802 |
240 |
| 30 |
220.4937 |
2026-06-30 00:00:00.0 |
9.2935 |
240 |
| 31 |
229.7376 |
2026-07-01 00:00:00.0 |
9.2439 |
240 |
| 32 |
238.7752 |
2026-07-02 00:00:00.0 |
9.0376 |
240 |
| 33 |
247.4235 |
2026-07-03 00:00:00.0 |
8.6483 |
240 |
| 34 |
255.8347 |
2026-07-04 00:00:00.0 |
8.4112 |
240 |
| 35 |
263.7416 |
2026-07-05 00:00:00.0 |
7.9069 |
240 |
| 36 |
271.0060 |
2026-07-06 00:00:00.0 |
7.2644 |
240 |
| 37 |
279.9893 |
2026-07-07 00:00:00.0 |
8.9833 |
240 |
| 38 |
288.1644 |
2026-07-08 00:00:00.0 |
8.1751 |
240 |
| 39 |
296.3863 |
2026-07-09 00:00:00.0 |
8.2219 |
240 |
| 40 |
305.0749 |
2026-07-10 00:00:00.0 |
8.6886 |
240 |
| 41 |
313.1660 |
2026-07-11 00:00:00.0 |
8.0911 |
240 |
| 42 |
319.9834 |
2026-07-12 00:00:00.0 |
6.8174 |
240 |
| 43 |
324.7911 |
2026-07-13 00:00:00.0 |
4.8077 |
240 |
| 44 |
329.5989 |
2026-07-14 00:00:00.0 |
4.8078 |
240 |
| 45 |
338.8050 |
2026-07-15 00:00:00.0 |
9.2061 |
240 |
| 46 |
348.1129 |
2026-07-16 00:00:00.0 |
9.3079 |
240 |
| 47 |
356.8561 |
2026-07-17 00:00:00.0 |
8.7432 |
240 |
| 48 |
365.6635 |
2026-07-18 00:00:00.0 |
8.8074 |
240 |
| 49 |
373.1818 |
2026-07-19 00:00:00.0 |
7.5183 |
240 |
| 50 |
380.3715 |
2026-07-20 00:00:00.0 |
7.1897 |
240 |
| 51 |
389.3451 |
2026-07-21 00:00:00.0 |
8.9736 |
240 |
|
| CACHED |
false |
| EXECUTIONTIME |
15 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '240') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-07-21'}
ORDER BY ddate ASC |
