query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.6791 |
2025-06-01 00:00:00.0 |
7.6791 |
237 |
2 |
14.4542 |
2025-06-02 00:00:00.0 |
6.7751 |
237 |
3 |
23.1220 |
2025-06-03 00:00:00.0 |
8.6678 |
237 |
4 |
31.5012 |
2025-06-04 00:00:00.0 |
8.3792 |
237 |
5 |
38.2942 |
2025-06-05 00:00:00.0 |
6.7930 |
237 |
6 |
43.7613 |
2025-06-06 00:00:00.0 |
5.4671 |
237 |
7 |
50.9950 |
2025-06-07 00:00:00.0 |
7.2337 |
237 |
8 |
59.4696 |
2025-06-08 00:00:00.0 |
8.4746 |
237 |
9 |
64.4374 |
2025-06-09 00:00:00.0 |
4.9678 |
237 |
10 |
69.2340 |
2025-06-10 00:00:00.0 |
4.7966 |
237 |
11 |
76.8099 |
2025-06-11 00:00:00.0 |
7.5759 |
237 |
12 |
83.7372 |
2025-06-12 00:00:00.0 |
6.9273 |
237 |
13 |
90.6297 |
2025-06-13 00:00:00.0 |
6.8925 |
237 |
14 |
97.5306 |
2025-06-14 00:00:00.0 |
6.9009 |
237 |
15 |
104.5255 |
2025-06-15 00:00:00.0 |
6.9949 |
237 |
16 |
112.2656 |
2025-06-16 00:00:00.0 |
7.7401 |
237 |
17 |
121.5445 |
2025-06-17 00:00:00.0 |
9.2789 |
237 |
18 |
130.3397 |
2025-06-18 00:00:00.0 |
8.7952 |
237 |
19 |
138.6983 |
2025-06-19 00:00:00.0 |
8.3586 |
237 |
20 |
146.9084 |
2025-06-20 00:00:00.0 |
8.2101 |
237 |
21 |
154.5586 |
2025-06-21 00:00:00.0 |
7.6502 |
237 |
22 |
163.5399 |
2025-06-22 00:00:00.0 |
8.9813 |
237 |
23 |
172.2683 |
2025-06-23 00:00:00.0 |
8.7284 |
237 |
24 |
178.9207 |
2025-06-24 00:00:00.0 |
6.6524 |
237 |
25 |
184.6412 |
2025-06-25 00:00:00.0 |
5.7205 |
237 |
26 |
192.2654 |
2025-06-26 00:00:00.0 |
7.6242 |
237 |
27 |
201.1096 |
2025-06-27 00:00:00.0 |
8.8442 |
237 |
28 |
208.7769 |
2025-06-28 00:00:00.0 |
7.6673 |
237 |
29 |
215.6438 |
2025-06-29 00:00:00.0 |
6.8669 |
237 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '237') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-29'}
ORDER BY ddate ASC |