query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.0321 |
2025-06-01 00:00:00.0 |
7.0321 |
244 |
2 |
14.1458 |
2025-06-02 00:00:00.0 |
7.1137 |
244 |
3 |
22.0960 |
2025-06-03 00:00:00.0 |
7.9502 |
244 |
4 |
29.8084 |
2025-06-04 00:00:00.0 |
7.7124 |
244 |
5 |
36.4121 |
2025-06-05 00:00:00.0 |
6.6037 |
244 |
6 |
42.8278 |
2025-06-06 00:00:00.0 |
6.4157 |
244 |
7 |
50.4902 |
2025-06-07 00:00:00.0 |
7.6624 |
244 |
8 |
58.8344 |
2025-06-08 00:00:00.0 |
8.3442 |
244 |
9 |
64.2676 |
2025-06-09 00:00:00.0 |
5.4332 |
244 |
10 |
68.5307 |
2025-06-10 00:00:00.0 |
4.2631 |
244 |
11 |
75.4301 |
2025-06-11 00:00:00.0 |
6.8994 |
244 |
12 |
82.4373 |
2025-06-12 00:00:00.0 |
7.0072 |
244 |
13 |
89.0392 |
2025-06-13 00:00:00.0 |
6.6019 |
244 |
14 |
96.7964 |
2025-06-14 00:00:00.0 |
7.7572 |
244 |
15 |
105.0526 |
2025-06-15 00:00:00.0 |
8.2562 |
244 |
16 |
113.0540 |
2025-06-16 00:00:00.0 |
8.0014 |
244 |
17 |
122.5052 |
2025-06-17 00:00:00.0 |
9.4512 |
244 |
18 |
131.2075 |
2025-06-18 00:00:00.0 |
8.7023 |
244 |
19 |
139.0143 |
2025-06-19 00:00:00.0 |
7.8068 |
244 |
20 |
147.5900 |
2025-06-20 00:00:00.0 |
8.5757 |
244 |
21 |
155.2765 |
2025-06-21 00:00:00.0 |
7.6865 |
244 |
22 |
163.7037 |
2025-06-22 00:00:00.0 |
8.4272 |
244 |
23 |
172.6735 |
2025-06-23 00:00:00.0 |
8.9698 |
244 |
24 |
179.1756 |
2025-06-24 00:00:00.0 |
6.5021 |
244 |
25 |
184.9574 |
2025-06-25 00:00:00.0 |
5.7818 |
244 |
26 |
193.4938 |
2025-06-26 00:00:00.0 |
8.5364 |
244 |
27 |
202.0654 |
2025-06-27 00:00:00.0 |
8.5716 |
244 |
28 |
209.6298 |
2025-06-28 00:00:00.0 |
7.5644 |
244 |
29 |
217.0295 |
2025-06-29 00:00:00.0 |
7.3997 |
244 |
30 |
225.8703 |
2025-06-30 00:00:00.0 |
8.8408 |
244 |
31 |
234.7983 |
2025-07-01 00:00:00.0 |
8.9280 |
244 |
32 |
242.7723 |
2025-07-02 00:00:00.0 |
7.9740 |
244 |
33 |
251.6837 |
2025-07-03 00:00:00.0 |
8.9114 |
244 |
34 |
259.3078 |
2025-07-04 00:00:00.0 |
7.6241 |
244 |
35 |
267.7970 |
2025-07-05 00:00:00.0 |
8.4892 |
244 |
36 |
276.8687 |
2025-07-06 00:00:00.0 |
9.0717 |
244 |
37 |
284.8873 |
2025-07-07 00:00:00.0 |
8.0186 |
244 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '244') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-07'}
ORDER BY ddate ASC |