query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
8.1294 |
2025-06-01 00:00:00.0 |
8.1294 |
233 |
2 |
15.5183 |
2025-06-02 00:00:00.0 |
7.3889 |
233 |
3 |
22.3543 |
2025-06-03 00:00:00.0 |
6.8360 |
233 |
4 |
28.0984 |
2025-06-04 00:00:00.0 |
5.7441 |
233 |
5 |
33.6723 |
2025-06-05 00:00:00.0 |
5.5739 |
233 |
6 |
39.7058 |
2025-06-06 00:00:00.0 |
6.0335 |
233 |
7 |
46.3077 |
2025-06-07 00:00:00.0 |
6.6019 |
233 |
8 |
53.2667 |
2025-06-08 00:00:00.0 |
6.9590 |
233 |
9 |
55.8214 |
2025-06-09 00:00:00.0 |
2.5547 |
233 |
10 |
62.0836 |
2025-06-10 00:00:00.0 |
6.2622 |
233 |
11 |
69.3031 |
2025-06-11 00:00:00.0 |
7.2195 |
233 |
12 |
75.6010 |
2025-06-12 00:00:00.0 |
6.2979 |
233 |
13 |
82.1963 |
2025-06-13 00:00:00.0 |
6.5953 |
233 |
14 |
90.1725 |
2025-06-14 00:00:00.0 |
7.9762 |
233 |
15 |
97.4975 |
2025-06-15 00:00:00.0 |
7.3250 |
233 |
16 |
106.0172 |
2025-06-16 00:00:00.0 |
8.5197 |
233 |
17 |
115.2045 |
2025-06-17 00:00:00.0 |
9.1873 |
233 |
18 |
123.4576 |
2025-06-18 00:00:00.0 |
8.2531 |
233 |
19 |
132.1013 |
2025-06-19 00:00:00.0 |
8.6437 |
233 |
20 |
140.3562 |
2025-06-20 00:00:00.0 |
8.2549 |
233 |
21 |
149.3540 |
2025-06-21 00:00:00.0 |
8.9978 |
233 |
22 |
158.2776 |
2025-06-22 00:00:00.0 |
8.9236 |
233 |
23 |
166.1546 |
2025-06-23 00:00:00.0 |
7.8770 |
233 |
24 |
169.6875 |
2025-06-24 00:00:00.0 |
3.5329 |
233 |
25 |
175.4722 |
2025-06-25 00:00:00.0 |
5.7847 |
233 |
26 |
182.4759 |
2025-06-26 00:00:00.0 |
7.0037 |
233 |
27 |
190.7678 |
2025-06-27 00:00:00.0 |
8.2919 |
233 |
28 |
198.8837 |
2025-06-28 00:00:00.0 |
8.1159 |
233 |
29 |
206.8502 |
2025-06-29 00:00:00.0 |
7.9665 |
233 |
30 |
215.5277 |
2025-06-30 00:00:00.0 |
8.6775 |
233 |
31 |
224.4503 |
2025-07-01 00:00:00.0 |
8.9226 |
233 |
32 |
232.6720 |
2025-07-02 00:00:00.0 |
8.2217 |
233 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '233') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-02'}
ORDER BY ddate ASC |