query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
6.9396 |
2025-06-01 00:00:00.0 |
6.9396 |
243 |
2 |
13.5195 |
2025-06-02 00:00:00.0 |
6.5799 |
243 |
3 |
22.1615 |
2025-06-03 00:00:00.0 |
8.6420 |
243 |
4 |
28.6732 |
2025-06-04 00:00:00.0 |
6.5117 |
243 |
5 |
34.4499 |
2025-06-05 00:00:00.0 |
5.7767 |
243 |
6 |
40.4449 |
2025-06-06 00:00:00.0 |
5.9950 |
243 |
7 |
46.7681 |
2025-06-07 00:00:00.0 |
6.3232 |
243 |
8 |
54.7985 |
2025-06-08 00:00:00.0 |
8.0304 |
243 |
9 |
59.5021 |
2025-06-09 00:00:00.0 |
4.7036 |
243 |
10 |
63.9529 |
2025-06-10 00:00:00.0 |
4.4508 |
243 |
11 |
70.4222 |
2025-06-11 00:00:00.0 |
6.4693 |
243 |
12 |
77.1795 |
2025-06-12 00:00:00.0 |
6.7573 |
243 |
13 |
84.2932 |
2025-06-13 00:00:00.0 |
7.1137 |
243 |
14 |
92.2499 |
2025-06-14 00:00:00.0 |
7.9567 |
243 |
15 |
100.3839 |
2025-06-15 00:00:00.0 |
8.1340 |
243 |
16 |
108.3466 |
2025-06-16 00:00:00.0 |
7.9627 |
243 |
17 |
117.7394 |
2025-06-17 00:00:00.0 |
9.3928 |
243 |
18 |
125.6986 |
2025-06-18 00:00:00.0 |
7.9592 |
243 |
19 |
133.6903 |
2025-06-19 00:00:00.0 |
7.9917 |
243 |
20 |
142.3688 |
2025-06-20 00:00:00.0 |
8.6785 |
243 |
21 |
150.5809 |
2025-06-21 00:00:00.0 |
8.2121 |
243 |
22 |
159.8670 |
2025-06-22 00:00:00.0 |
9.2861 |
243 |
23 |
168.3439 |
2025-06-23 00:00:00.0 |
8.4769 |
243 |
24 |
173.7766 |
2025-06-24 00:00:00.0 |
5.4327 |
243 |
25 |
179.7545 |
2025-06-25 00:00:00.0 |
5.9779 |
243 |
26 |
188.4607 |
2025-06-26 00:00:00.0 |
8.7062 |
243 |
27 |
197.4440 |
2025-06-27 00:00:00.0 |
8.9833 |
243 |
28 |
205.7529 |
2025-06-28 00:00:00.0 |
8.3089 |
243 |
29 |
213.2566 |
2025-06-29 00:00:00.0 |
7.5037 |
243 |
30 |
221.9477 |
2025-06-30 00:00:00.0 |
8.6911 |
243 |
31 |
230.9710 |
2025-07-01 00:00:00.0 |
9.0233 |
243 |
32 |
239.1757 |
2025-07-02 00:00:00.0 |
8.2047 |
243 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '243') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-02'}
ORDER BY ddate ASC |