query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
8.1151 |
2025-06-01 00:00:00.0 |
8.1151 |
201 |
2 |
15.2250 |
2025-06-02 00:00:00.0 |
7.1099 |
201 |
3 |
23.3147 |
2025-06-03 00:00:00.0 |
8.0897 |
201 |
4 |
30.8409 |
2025-06-04 00:00:00.0 |
7.5262 |
201 |
5 |
37.4861 |
2025-06-05 00:00:00.0 |
6.6452 |
201 |
6 |
42.6111 |
2025-06-06 00:00:00.0 |
5.1250 |
201 |
7 |
50.2681 |
2025-06-07 00:00:00.0 |
7.6570 |
201 |
8 |
58.3602 |
2025-06-08 00:00:00.0 |
8.0921 |
201 |
9 |
61.6385 |
2025-06-09 00:00:00.0 |
3.2783 |
201 |
10 |
67.0209 |
2025-06-10 00:00:00.0 |
5.3824 |
201 |
11 |
74.4658 |
2025-06-11 00:00:00.0 |
7.4449 |
201 |
12 |
80.4829 |
2025-06-12 00:00:00.0 |
6.0171 |
201 |
13 |
88.1439 |
2025-06-13 00:00:00.0 |
7.6610 |
201 |
14 |
94.3590 |
2025-06-14 00:00:00.0 |
6.2151 |
201 |
15 |
100.8139 |
2025-06-15 00:00:00.0 |
6.4549 |
201 |
16 |
109.2080 |
2025-06-16 00:00:00.0 |
8.3941 |
201 |
17 |
118.2825 |
2025-06-17 00:00:00.0 |
9.0745 |
201 |
18 |
126.5011 |
2025-06-18 00:00:00.0 |
8.2186 |
201 |
19 |
134.8442 |
2025-06-19 00:00:00.0 |
8.3431 |
201 |
20 |
143.3337 |
2025-06-20 00:00:00.0 |
8.4895 |
201 |
21 |
151.5859 |
2025-06-21 00:00:00.0 |
8.2522 |
201 |
22 |
161.1643 |
2025-06-22 00:00:00.0 |
9.5784 |
201 |
23 |
168.6736 |
2025-06-23 00:00:00.0 |
7.5093 |
201 |
24 |
172.0129 |
2025-06-24 00:00:00.0 |
3.3393 |
201 |
25 |
175.3522 |
2025-06-25 00:00:00.0 |
3.3393 |
201 |
26 |
182.3685 |
2025-06-26 00:00:00.0 |
7.0163 |
201 |
27 |
190.7261 |
2025-06-27 00:00:00.0 |
8.3576 |
201 |
28 |
198.6575 |
2025-06-28 00:00:00.0 |
7.9314 |
201 |
29 |
206.2105 |
2025-06-29 00:00:00.0 |
7.5530 |
201 |
30 |
215.7087 |
2025-06-30 00:00:00.0 |
9.4982 |
201 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '201') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-30'}
ORDER BY ddate ASC |