query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.2260 |
2025-06-01 00:00:00.0 |
7.2260 |
524 |
2 |
14.1060 |
2025-06-02 00:00:00.0 |
6.8800 |
524 |
3 |
22.6594 |
2025-06-03 00:00:00.0 |
8.5534 |
524 |
4 |
30.7148 |
2025-06-04 00:00:00.0 |
8.0554 |
524 |
5 |
37.9958 |
2025-06-05 00:00:00.0 |
7.2810 |
524 |
6 |
43.3968 |
2025-06-06 00:00:00.0 |
5.4010 |
524 |
7 |
50.8240 |
2025-06-07 00:00:00.0 |
7.4272 |
524 |
8 |
59.1433 |
2025-06-08 00:00:00.0 |
8.3193 |
524 |
9 |
64.3413 |
2025-06-09 00:00:00.0 |
5.1980 |
524 |
10 |
69.7559 |
2025-06-10 00:00:00.0 |
5.4146 |
524 |
11 |
77.1029 |
2025-06-11 00:00:00.0 |
7.3470 |
524 |
12 |
83.8719 |
2025-06-12 00:00:00.0 |
6.7690 |
524 |
13 |
90.7574 |
2025-06-13 00:00:00.0 |
6.8855 |
524 |
14 |
98.1099 |
2025-06-14 00:00:00.0 |
7.3525 |
524 |
15 |
105.0115 |
2025-06-15 00:00:00.0 |
6.9016 |
524 |
16 |
112.5788 |
2025-06-16 00:00:00.0 |
7.5673 |
524 |
17 |
121.7752 |
2025-06-17 00:00:00.0 |
9.1964 |
524 |
18 |
130.2865 |
2025-06-18 00:00:00.0 |
8.5113 |
524 |
19 |
138.4052 |
2025-06-19 00:00:00.0 |
8.1187 |
524 |
20 |
146.7938 |
2025-06-20 00:00:00.0 |
8.3886 |
524 |
21 |
154.7888 |
2025-06-21 00:00:00.0 |
7.9950 |
524 |
22 |
163.7944 |
2025-06-22 00:00:00.0 |
9.0056 |
524 |
23 |
172.6762 |
2025-06-23 00:00:00.0 |
8.8818 |
524 |
24 |
178.5218 |
2025-06-24 00:00:00.0 |
5.8456 |
524 |
25 |
184.5054 |
2025-06-25 00:00:00.0 |
5.9836 |
524 |
26 |
192.3194 |
2025-06-26 00:00:00.0 |
7.8140 |
524 |
27 |
200.8394 |
2025-06-27 00:00:00.0 |
8.5200 |
524 |
28 |
208.3979 |
2025-06-28 00:00:00.0 |
7.5585 |
524 |
29 |
215.8380 |
2025-06-29 00:00:00.0 |
7.4401 |
524 |
30 |
224.6761 |
2025-06-30 00:00:00.0 |
8.8381 |
524 |
31 |
233.3965 |
2025-07-01 00:00:00.0 |
8.7204 |
524 |
32 |
241.4657 |
2025-07-02 00:00:00.0 |
8.0692 |
524 |
33 |
250.1383 |
2025-07-03 00:00:00.0 |
8.6726 |
524 |
34 |
257.0990 |
2025-07-04 00:00:00.0 |
6.9607 |
524 |
35 |
264.1127 |
2025-07-05 00:00:00.0 |
7.0137 |
524 |
36 |
272.6691 |
2025-07-06 00:00:00.0 |
8.5564 |
524 |
37 |
280.0463 |
2025-07-07 00:00:00.0 |
7.3772 |
524 |
38 |
288.0124 |
2025-07-08 00:00:00.0 |
7.9661 |
524 |
39 |
295.5854 |
2025-07-09 00:00:00.0 |
7.5730 |
524 |
40 |
303.3220 |
2025-07-10 00:00:00.0 |
7.7366 |
524 |
41 |
310.2591 |
2025-07-11 00:00:00.0 |
6.9371 |
524 |
42 |
319.4609 |
2025-07-12 00:00:00.0 |
9.2018 |
524 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '524') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-12'}
ORDER BY ddate ASC |