query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.6130 |
2025-06-01 00:00:00.0 |
7.6130 |
235 |
2 |
13.9843 |
2025-06-02 00:00:00.0 |
6.3713 |
235 |
3 |
22.7257 |
2025-06-03 00:00:00.0 |
8.7414 |
235 |
4 |
31.1314 |
2025-06-04 00:00:00.0 |
8.4057 |
235 |
5 |
38.1720 |
2025-06-05 00:00:00.0 |
7.0406 |
235 |
6 |
44.4522 |
2025-06-06 00:00:00.0 |
6.2802 |
235 |
7 |
52.0692 |
2025-06-07 00:00:00.0 |
7.6170 |
235 |
8 |
60.6709 |
2025-06-08 00:00:00.0 |
8.6017 |
235 |
9 |
65.3946 |
2025-06-09 00:00:00.0 |
4.7237 |
235 |
10 |
70.4727 |
2025-06-10 00:00:00.0 |
5.0781 |
235 |
11 |
77.7622 |
2025-06-11 00:00:00.0 |
7.2895 |
235 |
12 |
84.5722 |
2025-06-12 00:00:00.0 |
6.8100 |
235 |
13 |
91.6065 |
2025-06-13 00:00:00.0 |
7.0343 |
235 |
14 |
98.7356 |
2025-06-14 00:00:00.0 |
7.1291 |
235 |
15 |
106.2117 |
2025-06-15 00:00:00.0 |
7.4761 |
235 |
16 |
114.0488 |
2025-06-16 00:00:00.0 |
7.8371 |
235 |
17 |
123.2806 |
2025-06-17 00:00:00.0 |
9.2318 |
235 |
18 |
132.2849 |
2025-06-18 00:00:00.0 |
9.0043 |
235 |
19 |
141.1147 |
2025-06-19 00:00:00.0 |
8.8298 |
235 |
20 |
149.7628 |
2025-06-20 00:00:00.0 |
8.6481 |
235 |
21 |
157.3094 |
2025-06-21 00:00:00.0 |
7.5466 |
235 |
22 |
166.6577 |
2025-06-22 00:00:00.0 |
9.3483 |
235 |
23 |
174.9974 |
2025-06-23 00:00:00.0 |
8.3397 |
235 |
24 |
181.7018 |
2025-06-24 00:00:00.0 |
6.7044 |
235 |
25 |
187.3990 |
2025-06-25 00:00:00.0 |
5.6972 |
235 |
26 |
195.1321 |
2025-06-26 00:00:00.0 |
7.7331 |
235 |
27 |
203.6945 |
2025-06-27 00:00:00.0 |
8.5624 |
235 |
28 |
211.2961 |
2025-06-28 00:00:00.0 |
7.6016 |
235 |
29 |
218.1896 |
2025-06-29 00:00:00.0 |
6.8935 |
235 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '235') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-29'}
ORDER BY ddate ASC |