query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
6.9610 |
2025-06-01 00:00:00.0 |
6.9610 |
222 |
2 |
13.7532 |
2025-06-02 00:00:00.0 |
6.7922 |
222 |
3 |
22.3803 |
2025-06-03 00:00:00.0 |
8.6271 |
222 |
4 |
29.8862 |
2025-06-04 00:00:00.0 |
7.5059 |
222 |
5 |
37.1540 |
2025-06-05 00:00:00.0 |
7.2678 |
222 |
6 |
43.2352 |
2025-06-06 00:00:00.0 |
6.0812 |
222 |
7 |
49.8127 |
2025-06-07 00:00:00.0 |
6.5775 |
222 |
8 |
58.3240 |
2025-06-08 00:00:00.0 |
8.5113 |
222 |
9 |
63.5651 |
2025-06-09 00:00:00.0 |
5.2411 |
222 |
10 |
67.3750 |
2025-06-10 00:00:00.0 |
3.8099 |
222 |
11 |
74.1142 |
2025-06-11 00:00:00.0 |
6.7392 |
222 |
12 |
81.5085 |
2025-06-12 00:00:00.0 |
7.3943 |
222 |
13 |
88.2519 |
2025-06-13 00:00:00.0 |
6.7434 |
222 |
14 |
95.1018 |
2025-06-14 00:00:00.0 |
6.8499 |
222 |
15 |
101.7628 |
2025-06-15 00:00:00.0 |
6.6610 |
222 |
16 |
108.3403 |
2025-06-16 00:00:00.0 |
6.5775 |
222 |
17 |
117.6333 |
2025-06-17 00:00:00.0 |
9.2930 |
222 |
18 |
125.9173 |
2025-06-18 00:00:00.0 |
8.2840 |
222 |
19 |
134.1653 |
2025-06-19 00:00:00.0 |
8.2480 |
222 |
20 |
142.5395 |
2025-06-20 00:00:00.0 |
8.3742 |
222 |
21 |
150.5769 |
2025-06-21 00:00:00.0 |
8.0374 |
222 |
22 |
159.2040 |
2025-06-22 00:00:00.0 |
8.6271 |
222 |
23 |
167.8682 |
2025-06-23 00:00:00.0 |
8.6642 |
222 |
24 |
174.2487 |
2025-06-24 00:00:00.0 |
6.3805 |
222 |
25 |
179.9485 |
2025-06-25 00:00:00.0 |
5.6998 |
222 |
26 |
188.0446 |
2025-06-26 00:00:00.0 |
8.0961 |
222 |
27 |
196.4283 |
2025-06-27 00:00:00.0 |
8.3837 |
222 |
28 |
204.0300 |
2025-06-28 00:00:00.0 |
7.6017 |
222 |
29 |
211.6064 |
2025-06-29 00:00:00.0 |
7.5764 |
222 |
30 |
220.8575 |
2025-06-30 00:00:00.0 |
9.2511 |
222 |
31 |
229.9565 |
2025-07-01 00:00:00.0 |
9.0990 |
222 |
32 |
238.2804 |
2025-07-02 00:00:00.0 |
8.3239 |
222 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '222') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-02'}
ORDER BY ddate ASC |