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 |
30 |
222.3026 |
2025-06-30 00:00:00.0 |
8.7818 |
559 |
31 |
231.1204 |
2025-07-01 00:00:00.0 |
8.8178 |
559 |
32 |
239.0982 |
2025-07-02 00:00:00.0 |
7.9778 |
559 |
33 |
247.8533 |
2025-07-03 00:00:00.0 |
8.7551 |
559 |
34 |
255.2285 |
2025-07-04 00:00:00.0 |
7.3752 |
559 |
35 |
261.9823 |
2025-07-05 00:00:00.0 |
6.7538 |
559 |
36 |
270.8716 |
2025-07-06 00:00:00.0 |
8.8893 |
559 |
37 |
277.5022 |
2025-07-07 00:00:00.0 |
6.6306 |
559 |
38 |
284.5715 |
2025-07-08 00:00:00.0 |
7.0693 |
559 |
39 |
291.3780 |
2025-07-09 00:00:00.0 |
6.8065 |
559 |
40 |
299.7844 |
2025-07-10 00:00:00.0 |
8.4064 |
559 |
41 |
307.3472 |
2025-07-11 00:00:00.0 |
7.5628 |
559 |
42 |
316.4188 |
2025-07-12 00:00:00.0 |
9.0716 |
559 |
43 |
324.1527 |
2025-07-13 00:00:00.0 |
7.7339 |
559 |
44 |
332.4926 |
2025-07-14 00:00:00.0 |
8.3399 |
559 |
45 |
340.9351 |
2025-07-15 00:00:00.0 |
8.4425 |
559 |
46 |
347.9897 |
2025-07-16 00:00:00.0 |
7.0546 |
559 |
47 |
353.6596 |
2025-07-17 00:00:00.0 |
5.6699 |
559 |
48 |
359.3092 |
2025-07-18 00:00:00.0 |
5.6496 |
559 |
49 |
367.3631 |
2025-07-19 00:00:00.0 |
8.0539 |
559 |
50 |
374.3252 |
2025-07-20 00:00:00.0 |
6.9621 |
559 |
51 |
383.2709 |
2025-07-21 00:00:00.0 |
8.9457 |
559 |
52 |
392.0297 |
2025-07-22 00:00:00.0 |
8.7588 |
559 |
53 |
401.1210 |
2025-07-23 00:00:00.0 |
9.0913 |
559 |
54 |
410.5011 |
2025-07-24 00:00:00.0 |
9.3801 |
559 |
55 |
419.7116 |
2025-07-25 00:00:00.0 |
9.2105 |
559 |
56 |
427.2777 |
2025-07-26 00:00:00.0 |
7.5661 |
559 |
57 |
435.2346 |
2025-07-27 00:00:00.0 |
7.9569 |
559 |
58 |
444.4549 |
2025-07-28 00:00:00.0 |
9.2203 |
559 |
59 |
453.3088 |
2025-07-29 00:00:00.0 |
8.8539 |
559 |
60 |
461.7236 |
2025-07-30 00:00:00.0 |
8.4148 |
559 |
61 |
469.4370 |
2025-07-31 00:00:00.0 |
7.7134 |
559 |
62 |
476.7250 |
2025-08-01 00:00:00.0 |
7.2880 |
559 |
63 |
484.6810 |
2025-08-02 00:00:00.0 |
7.9560 |
559 |
64 |
493.6460 |
2025-08-03 00:00:00.0 |
8.9650 |
559 |
65 |
502.0687 |
2025-08-04 00:00:00.0 |
8.4227 |
559 |
66 |
510.7136 |
2025-08-05 00:00:00.0 |
8.6449 |
559 |
67 |
519.8136 |
2025-08-06 00:00:00.0 |
9.1000 |
559 |
68 |
528.6183 |
2025-08-07 00:00:00.0 |
8.8047 |
559 |
69 |
536.9356 |
2025-08-08 00:00:00.0 |
8.3173 |
559 |
70 |
546.4672 |
2025-08-09 00:00:00.0 |
9.5316 |
559 |
71 |
554.8075 |
2025-08-10 00:00:00.0 |
8.3403 |
559 |
72 |
564.0507 |
2025-08-11 00:00:00.0 |
9.2432 |
559 |
73 |
573.4652 |
2025-08-12 00:00:00.0 |
9.4145 |
559 |
74 |
581.3198 |
2025-08-13 00:00:00.0 |
7.8546 |
559 |
75 |
588.5322 |
2025-08-14 00:00:00.0 |
7.2124 |
559 |
76 |
597.1314 |
2025-08-15 00:00:00.0 |
8.5992 |
559 |
77 |
604.5671 |
2025-08-16 00:00:00.0 |
7.4357 |
559 |
78 |
612.1575 |
2025-08-17 00:00:00.0 |
7.5904 |
559 |
79 |
619.9914 |
2025-08-18 00:00:00.0 |
7.8339 |
559 |
80 |
629.5931 |
2025-08-19 00:00:00.0 |
9.6017 |
559 |
81 |
638.6606 |
2025-08-20 00:00:00.0 |
9.0675 |
559 |
82 |
646.0385 |
2025-08-21 00:00:00.0 |
7.3779 |
559 |
83 |
654.5706 |
2025-08-22 00:00:00.0 |
8.5321 |
559 |
84 |
661.2811 |
2025-08-23 00:00:00.0 |
6.7105 |
559 |
85 |
668.7702 |
2025-08-24 00:00:00.0 |
7.4891 |
559 |
86 |
674.2451 |
2025-08-25 00:00:00.0 |
5.4749 |
559 |
87 |
680.0456 |
2025-08-26 00:00:00.0 |
5.8005 |
559 |
88 |
687.1136 |
2025-08-27 00:00:00.0 |
7.0680 |
559 |
89 |
694.7304 |
2025-08-28 00:00:00.0 |
7.6168 |
559 |
90 |
702.1825 |
2025-08-29 00:00:00.0 |
7.4521 |
559 |
91 |
709.6976 |
2025-08-30 00:00:00.0 |
7.5151 |
559 |
92 |
717.0611 |
2025-08-31 00:00:00.0 |
7.3635 |
559 |
93 |
724.5596 |
2025-09-01 00:00:00.0 |
7.4985 |
559 |
94 |
732.5978 |
2025-09-02 00:00:00.0 |
8.0382 |
559 |
95 |
737.4336 |
2025-09-03 00:00:00.0 |
4.8358 |
559 |
96 |
739.8337 |
2025-09-04 00:00:00.0 |
2.4001 |
559 |
97 |
740.1957 |
2025-09-05 00:00:00.0 |
0.3620 |
559 |
98 |
743.5326 |
2025-09-06 00:00:00.0 |
3.3369 |
559 |
99 |
746.7636 |
2025-09-07 00:00:00.0 |
3.2310 |
559 |
100 |
750.5845 |
2025-09-08 00:00:00.0 |
3.8209 |
559 |
101 |
758.2529 |
2025-09-09 00:00:00.0 |
7.6684 |
559 |
102 |
765.0387 |
2025-09-10 00:00:00.0 |
6.7858 |
559 |
103 |
772.2426 |
2025-09-11 00:00:00.0 |
7.2039 |
559 |
104 |
781.5941 |
2025-09-12 00:00:00.0 |
9.3515 |
559 |
105 |
790.7512 |
2025-09-13 00:00:00.0 |
9.1571 |
559 |
106 |
799.9763 |
2025-09-14 00:00:00.0 |
9.2251 |
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-09-14'}
ORDER BY ddate ASC |