query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.5373 |
2025-06-01 00:00:00.0 |
7.5373 |
559 |
2 |
14.7643 |
2025-06-02 00:00:00.0 |
7.2270 |
559 |
3 |
22.6430 |
2025-06-03 00:00:00.0 |
7.8787 |
559 |
4 |
29.2361 |
2025-06-04 00:00:00.0 |
6.5931 |
559 |
5 |
34.6052 |
2025-06-05 00:00:00.0 |
5.3691 |
559 |
6 |
39.9093 |
2025-06-06 00:00:00.0 |
5.3041 |
559 |
7 |
47.4078 |
2025-06-07 00:00:00.0 |
7.4985 |
559 |
8 |
55.7021 |
2025-06-08 00:00:00.0 |
8.2943 |
559 |
9 |
59.6620 |
2025-06-09 00:00:00.0 |
3.9599 |
559 |
10 |
65.8152 |
2025-06-10 00:00:00.0 |
6.1532 |
559 |
11 |
73.8691 |
2025-06-11 00:00:00.0 |
8.0539 |
559 |
12 |
79.9058 |
2025-06-12 00:00:00.0 |
6.0367 |
559 |
13 |
87.4146 |
2025-06-13 00:00:00.0 |
7.5088 |
559 |
14 |
94.4046 |
2025-06-14 00:00:00.0 |
6.9900 |
559 |
15 |
101.7930 |
2025-06-15 00:00:00.0 |
7.3884 |
559 |
16 |
110.5079 |
2025-06-16 00:00:00.0 |
8.7149 |
559 |
17 |
119.8825 |
2025-06-17 00:00:00.0 |
9.3746 |
559 |
18 |
128.0236 |
2025-06-18 00:00:00.0 |
8.1411 |
559 |
19 |
136.0305 |
2025-06-19 00:00:00.0 |
8.0069 |
559 |
20 |
144.5275 |
2025-06-20 00:00:00.0 |
8.4970 |
559 |
21 |
153.0412 |
2025-06-21 00:00:00.0 |
8.5137 |
559 |
22 |
162.7182 |
2025-06-22 00:00:00.0 |
9.6770 |
559 |
23 |
170.7062 |
2025-06-23 00:00:00.0 |
7.9880 |
559 |
24 |
175.3636 |
2025-06-24 00:00:00.0 |
4.6574 |
559 |
25 |
181.4226 |
2025-06-25 00:00:00.0 |
6.0590 |
559 |
26 |
189.0982 |
2025-06-26 00:00:00.0 |
7.6756 |
559 |
27 |
197.5628 |
2025-06-27 00:00:00.0 |
8.4646 |
559 |
28 |
206.0316 |
2025-06-28 00:00:00.0 |
8.4688 |
559 |
29 |
213.5208 |
2025-06-29 00:00:00.0 |
7.4892 |
559 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '559') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-29'}
ORDER BY ddate ASC |