query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.5057 |
2025-06-01 00:00:00.0 |
7.5057 |
239 |
2 |
14.4863 |
2025-06-02 00:00:00.0 |
6.9806 |
239 |
3 |
22.5441 |
2025-06-03 00:00:00.0 |
8.0578 |
239 |
4 |
29.2770 |
2025-06-04 00:00:00.0 |
6.7329 |
239 |
5 |
35.2156 |
2025-06-05 00:00:00.0 |
5.9386 |
239 |
6 |
40.5860 |
2025-06-06 00:00:00.0 |
5.3704 |
239 |
7 |
47.3877 |
2025-06-07 00:00:00.0 |
6.8017 |
239 |
8 |
55.4696 |
2025-06-08 00:00:00.0 |
8.0819 |
239 |
9 |
59.6948 |
2025-06-09 00:00:00.0 |
4.2252 |
239 |
10 |
66.1797 |
2025-06-10 00:00:00.0 |
6.4849 |
239 |
11 |
73.8554 |
2025-06-11 00:00:00.0 |
7.6757 |
239 |
12 |
79.7571 |
2025-06-12 00:00:00.0 |
5.9017 |
239 |
13 |
86.7612 |
2025-06-13 00:00:00.0 |
7.0041 |
239 |
14 |
93.8932 |
2025-06-14 00:00:00.0 |
7.1320 |
239 |
15 |
101.4585 |
2025-06-15 00:00:00.0 |
7.5653 |
239 |
16 |
109.3038 |
2025-06-16 00:00:00.0 |
7.8453 |
239 |
17 |
118.6674 |
2025-06-17 00:00:00.0 |
9.3636 |
239 |
18 |
127.1933 |
2025-06-18 00:00:00.0 |
8.5259 |
239 |
19 |
135.3268 |
2025-06-19 00:00:00.0 |
8.1335 |
239 |
20 |
143.6209 |
2025-06-20 00:00:00.0 |
8.2941 |
239 |
21 |
152.2318 |
2025-06-21 00:00:00.0 |
8.6109 |
239 |
22 |
161.8551 |
2025-06-22 00:00:00.0 |
9.6233 |
239 |
23 |
169.2925 |
2025-06-23 00:00:00.0 |
7.4374 |
239 |
24 |
173.7807 |
2025-06-24 00:00:00.0 |
4.4882 |
239 |
25 |
179.6786 |
2025-06-25 00:00:00.0 |
5.8979 |
239 |
26 |
187.3119 |
2025-06-26 00:00:00.0 |
7.6333 |
239 |
27 |
195.8914 |
2025-06-27 00:00:00.0 |
8.5795 |
239 |
28 |
203.9148 |
2025-06-28 00:00:00.0 |
8.0234 |
239 |
29 |
211.3061 |
2025-06-29 00:00:00.0 |
7.3913 |
239 |
30 |
220.0111 |
2025-06-30 00:00:00.0 |
8.7050 |
239 |
|
CACHED |
false |
EXECUTIONTIME |
15 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '239') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-30'}
ORDER BY ddate ASC |