query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.9778 |
2025-06-01 00:00:00.0 |
7.9778 |
548 |
2 |
14.8140 |
2025-06-02 00:00:00.0 |
6.8362 |
548 |
3 |
22.4187 |
2025-06-03 00:00:00.0 |
7.6047 |
548 |
4 |
28.0754 |
2025-06-04 00:00:00.0 |
5.6567 |
548 |
5 |
33.6393 |
2025-06-05 00:00:00.0 |
5.5639 |
548 |
6 |
38.7854 |
2025-06-06 00:00:00.0 |
5.1461 |
548 |
7 |
44.4762 |
2025-06-07 00:00:00.0 |
5.6908 |
548 |
8 |
51.1570 |
2025-06-08 00:00:00.0 |
6.6808 |
548 |
9 |
54.0525 |
2025-06-09 00:00:00.0 |
2.8955 |
548 |
10 |
60.6320 |
2025-06-10 00:00:00.0 |
6.5795 |
548 |
11 |
67.2405 |
2025-06-11 00:00:00.0 |
6.6085 |
548 |
12 |
72.9539 |
2025-06-12 00:00:00.0 |
5.7134 |
548 |
13 |
78.9270 |
2025-06-13 00:00:00.0 |
5.9731 |
548 |
14 |
86.8638 |
2025-06-14 00:00:00.0 |
7.9368 |
548 |
15 |
94.0804 |
2025-06-15 00:00:00.0 |
7.2166 |
548 |
16 |
102.2794 |
2025-06-16 00:00:00.0 |
8.1990 |
548 |
17 |
111.3891 |
2025-06-17 00:00:00.0 |
9.1097 |
548 |
18 |
119.6425 |
2025-06-18 00:00:00.0 |
8.2534 |
548 |
19 |
127.7624 |
2025-06-19 00:00:00.0 |
8.1199 |
548 |
20 |
135.7588 |
2025-06-20 00:00:00.0 |
7.9964 |
548 |
21 |
144.4242 |
2025-06-21 00:00:00.0 |
8.6654 |
548 |
22 |
153.4505 |
2025-06-22 00:00:00.0 |
9.0263 |
548 |
23 |
160.6942 |
2025-06-23 00:00:00.0 |
7.2437 |
548 |
24 |
164.1630 |
2025-06-24 00:00:00.0 |
3.4688 |
548 |
25 |
170.0974 |
2025-06-25 00:00:00.0 |
5.9344 |
548 |
26 |
177.0255 |
2025-06-26 00:00:00.0 |
6.9281 |
548 |
27 |
185.3082 |
2025-06-27 00:00:00.0 |
8.2827 |
548 |
28 |
193.4540 |
2025-06-28 00:00:00.0 |
8.1458 |
548 |
29 |
201.8215 |
2025-06-29 00:00:00.0 |
8.3675 |
548 |
30 |
210.3270 |
2025-06-30 00:00:00.0 |
8.5055 |
548 |
31 |
219.0285 |
2025-07-01 00:00:00.0 |
8.7015 |
548 |
32 |
227.0200 |
2025-07-02 00:00:00.0 |
7.9915 |
548 |
|
CACHED |
false |
EXECUTIONTIME |
15 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '548') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-02'}
ORDER BY ddate ASC |