query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.3387 |
2025-06-01 00:00:00.0 |
7.3387 |
230 |
2 |
14.3088 |
2025-06-02 00:00:00.0 |
6.9701 |
230 |
3 |
22.9844 |
2025-06-03 00:00:00.0 |
8.6756 |
230 |
4 |
31.3950 |
2025-06-04 00:00:00.0 |
8.4106 |
230 |
5 |
38.9278 |
2025-06-05 00:00:00.0 |
7.5328 |
230 |
6 |
46.2360 |
2025-06-06 00:00:00.0 |
7.3082 |
230 |
7 |
53.7261 |
2025-06-07 00:00:00.0 |
7.4901 |
230 |
8 |
62.1400 |
2025-06-08 00:00:00.0 |
8.4139 |
230 |
9 |
67.2161 |
2025-06-09 00:00:00.0 |
5.0761 |
230 |
10 |
73.0561 |
2025-06-10 00:00:00.0 |
5.8400 |
230 |
11 |
80.6921 |
2025-06-11 00:00:00.0 |
7.6360 |
230 |
12 |
88.3984 |
2025-06-12 00:00:00.0 |
7.7063 |
230 |
13 |
95.6111 |
2025-06-13 00:00:00.0 |
7.2127 |
230 |
14 |
102.6958 |
2025-06-14 00:00:00.0 |
7.0847 |
230 |
15 |
110.5281 |
2025-06-15 00:00:00.0 |
7.8323 |
230 |
16 |
118.2812 |
2025-06-16 00:00:00.0 |
7.7531 |
230 |
17 |
127.5874 |
2025-06-17 00:00:00.0 |
9.3062 |
230 |
18 |
136.2890 |
2025-06-18 00:00:00.0 |
8.7016 |
230 |
19 |
143.8574 |
2025-06-19 00:00:00.0 |
7.5684 |
230 |
20 |
151.7618 |
2025-06-20 00:00:00.0 |
7.9044 |
230 |
21 |
159.7187 |
2025-06-21 00:00:00.0 |
7.9569 |
230 |
22 |
167.6794 |
2025-06-22 00:00:00.0 |
7.9607 |
230 |
23 |
176.4703 |
2025-06-23 00:00:00.0 |
8.7909 |
230 |
24 |
182.4261 |
2025-06-24 00:00:00.0 |
5.9558 |
230 |
25 |
188.4410 |
2025-06-25 00:00:00.0 |
6.0149 |
230 |
26 |
196.9342 |
2025-06-26 00:00:00.0 |
8.4932 |
230 |
27 |
205.7574 |
2025-06-27 00:00:00.0 |
8.8232 |
230 |
28 |
213.9263 |
2025-06-28 00:00:00.0 |
8.1689 |
230 |
29 |
221.3658 |
2025-06-29 00:00:00.0 |
7.4395 |
230 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '230') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-29'}
ORDER BY ddate ASC |