query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.4602 |
2025-06-01 00:00:00.0 |
7.4602 |
212 |
2 |
14.0871 |
2025-06-02 00:00:00.0 |
6.6269 |
212 |
3 |
22.7142 |
2025-06-03 00:00:00.0 |
8.6271 |
212 |
4 |
30.6452 |
2025-06-04 00:00:00.0 |
7.9310 |
212 |
5 |
37.7356 |
2025-06-05 00:00:00.0 |
7.0904 |
212 |
6 |
43.8165 |
2025-06-06 00:00:00.0 |
6.0809 |
212 |
7 |
51.0078 |
2025-06-07 00:00:00.0 |
7.1913 |
212 |
8 |
59.5437 |
2025-06-08 00:00:00.0 |
8.5359 |
212 |
9 |
64.2808 |
2025-06-09 00:00:00.0 |
4.7371 |
212 |
10 |
69.1543 |
2025-06-10 00:00:00.0 |
4.8735 |
212 |
11 |
76.7096 |
2025-06-11 00:00:00.0 |
7.5553 |
212 |
12 |
83.4899 |
2025-06-12 00:00:00.0 |
6.7803 |
212 |
13 |
90.2333 |
2025-06-13 00:00:00.0 |
6.7434 |
212 |
14 |
97.4048 |
2025-06-14 00:00:00.0 |
7.1715 |
212 |
15 |
104.5773 |
2025-06-15 00:00:00.0 |
7.1725 |
212 |
16 |
112.3777 |
2025-06-16 00:00:00.0 |
7.8004 |
212 |
17 |
121.6003 |
2025-06-17 00:00:00.0 |
9.2226 |
212 |
18 |
126.2447 |
2025-06-18 00:00:00.0 |
4.6444 |
212 |
19 |
133.7652 |
2025-06-19 00:00:00.0 |
7.5205 |
212 |
20 |
142.1122 |
2025-06-20 00:00:00.0 |
8.3470 |
212 |
21 |
150.2174 |
2025-06-21 00:00:00.0 |
8.1052 |
212 |
22 |
159.0874 |
2025-06-22 00:00:00.0 |
8.8700 |
212 |
23 |
167.8473 |
2025-06-23 00:00:00.0 |
8.7599 |
212 |
24 |
173.9353 |
2025-06-24 00:00:00.0 |
6.0880 |
212 |
25 |
179.6740 |
2025-06-25 00:00:00.0 |
5.7387 |
212 |
26 |
187.8849 |
2025-06-26 00:00:00.0 |
8.2109 |
212 |
27 |
196.9648 |
2025-06-27 00:00:00.0 |
9.0799 |
212 |
28 |
204.5572 |
2025-06-28 00:00:00.0 |
7.5924 |
212 |
29 |
211.6524 |
2025-06-29 00:00:00.0 |
7.0952 |
212 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '212') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-29'}
ORDER BY ddate ASC |