query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.7961 |
2025-06-01 00:00:00.0 |
7.7961 |
240 |
2 |
14.9634 |
2025-06-02 00:00:00.0 |
7.1673 |
240 |
3 |
22.9624 |
2025-06-03 00:00:00.0 |
7.9990 |
240 |
4 |
29.5717 |
2025-06-04 00:00:00.0 |
6.6093 |
240 |
5 |
35.2558 |
2025-06-05 00:00:00.0 |
5.6841 |
240 |
6 |
40.6872 |
2025-06-06 00:00:00.0 |
5.4314 |
240 |
7 |
47.1365 |
2025-06-07 00:00:00.0 |
6.4493 |
240 |
8 |
55.0509 |
2025-06-08 00:00:00.0 |
7.9144 |
240 |
9 |
59.1208 |
2025-06-09 00:00:00.0 |
4.0699 |
240 |
10 |
65.8521 |
2025-06-10 00:00:00.0 |
6.7313 |
240 |
11 |
73.7241 |
2025-06-11 00:00:00.0 |
7.8720 |
240 |
12 |
79.5335 |
2025-06-12 00:00:00.0 |
5.8094 |
240 |
13 |
85.8495 |
2025-06-13 00:00:00.0 |
6.3160 |
240 |
14 |
92.2290 |
2025-06-14 00:00:00.0 |
6.3795 |
240 |
15 |
99.3332 |
2025-06-15 00:00:00.0 |
7.1042 |
240 |
16 |
107.0092 |
2025-06-16 00:00:00.0 |
7.6760 |
240 |
17 |
116.1878 |
2025-06-17 00:00:00.0 |
9.1786 |
240 |
18 |
124.0880 |
2025-06-18 00:00:00.0 |
7.9002 |
240 |
19 |
132.3687 |
2025-06-19 00:00:00.0 |
8.2807 |
240 |
20 |
140.5629 |
2025-06-20 00:00:00.0 |
8.1942 |
240 |
21 |
148.6547 |
2025-06-21 00:00:00.0 |
8.0918 |
240 |
22 |
158.0220 |
2025-06-22 00:00:00.0 |
9.3673 |
240 |
23 |
165.0819 |
2025-06-23 00:00:00.0 |
7.0599 |
240 |
24 |
169.8513 |
2025-06-24 00:00:00.0 |
4.7694 |
240 |
25 |
175.7182 |
2025-06-25 00:00:00.0 |
5.8669 |
240 |
26 |
182.7281 |
2025-06-26 00:00:00.0 |
7.0099 |
240 |
27 |
191.2422 |
2025-06-27 00:00:00.0 |
8.5141 |
240 |
28 |
199.0340 |
2025-06-28 00:00:00.0 |
7.7918 |
240 |
29 |
206.2808 |
2025-06-29 00:00:00.0 |
7.2468 |
240 |
30 |
215.1968 |
2025-06-30 00:00:00.0 |
8.9160 |
240 |
31 |
223.7928 |
2025-07-01 00:00:00.0 |
8.5960 |
240 |
32 |
231.2930 |
2025-07-02 00:00:00.0 |
7.5002 |
240 |
33 |
239.5038 |
2025-07-03 00:00:00.0 |
8.2108 |
240 |
34 |
246.8857 |
2025-07-04 00:00:00.0 |
7.3819 |
240 |
35 |
253.9256 |
2025-07-05 00:00:00.0 |
7.0399 |
240 |
36 |
261.6471 |
2025-07-06 00:00:00.0 |
7.7215 |
240 |
37 |
267.5069 |
2025-07-07 00:00:00.0 |
5.8598 |
240 |
38 |
273.4957 |
2025-07-08 00:00:00.0 |
5.9888 |
240 |
39 |
280.1073 |
2025-07-09 00:00:00.0 |
6.6116 |
240 |
40 |
287.8155 |
2025-07-10 00:00:00.0 |
7.7082 |
240 |
41 |
295.2987 |
2025-07-11 00:00:00.0 |
7.4832 |
240 |
42 |
304.1942 |
2025-07-12 00:00:00.0 |
8.8955 |
240 |
43 |
312.2543 |
2025-07-13 00:00:00.0 |
8.0601 |
240 |
44 |
320.4646 |
2025-07-14 00:00:00.0 |
8.2103 |
240 |
45 |
329.0838 |
2025-07-15 00:00:00.0 |
8.6192 |
240 |
46 |
335.6971 |
2025-07-16 00:00:00.0 |
6.6133 |
240 |
47 |
341.6292 |
2025-07-17 00:00:00.0 |
5.9321 |
240 |
48 |
347.0921 |
2025-07-18 00:00:00.0 |
5.4629 |
240 |
49 |
354.1963 |
2025-07-19 00:00:00.0 |
7.1042 |
240 |
50 |
360.7511 |
2025-07-20 00:00:00.0 |
6.5548 |
240 |
51 |
369.8628 |
2025-07-21 00:00:00.0 |
9.1117 |
240 |
52 |
378.5856 |
2025-07-22 00:00:00.0 |
8.7228 |
240 |
53 |
387.5380 |
2025-07-23 00:00:00.0 |
8.9524 |
240 |
54 |
396.7370 |
2025-07-24 00:00:00.0 |
9.1990 |
240 |
55 |
405.2069 |
2025-07-25 00:00:00.0 |
8.4699 |
240 |
56 |
412.4224 |
2025-07-26 00:00:00.0 |
7.2155 |
240 |
57 |
420.6808 |
2025-07-27 00:00:00.0 |
8.2584 |
240 |
58 |
429.6329 |
2025-07-28 00:00:00.0 |
8.9521 |
240 |
59 |
437.9789 |
2025-07-29 00:00:00.0 |
8.3460 |
240 |
60 |
445.8758 |
2025-07-30 00:00:00.0 |
7.8969 |
240 |
61 |
453.6293 |
2025-07-31 00:00:00.0 |
7.7535 |
240 |
62 |
460.3326 |
2025-08-01 00:00:00.0 |
6.7033 |
240 |
63 |
467.5287 |
2025-08-02 00:00:00.0 |
7.1961 |
240 |
64 |
475.1339 |
2025-08-03 00:00:00.0 |
7.6052 |
240 |
65 |
483.2951 |
2025-08-04 00:00:00.0 |
8.1612 |
240 |
66 |
491.8565 |
2025-08-05 00:00:00.0 |
8.5614 |
240 |
67 |
501.0613 |
2025-08-06 00:00:00.0 |
9.2048 |
240 |
68 |
509.8668 |
2025-08-07 00:00:00.0 |
8.8055 |
240 |
69 |
517.7866 |
2025-08-08 00:00:00.0 |
7.9198 |
240 |
70 |
527.3802 |
2025-08-09 00:00:00.0 |
9.5936 |
240 |
71 |
535.6454 |
2025-08-10 00:00:00.0 |
8.2652 |
240 |
72 |
544.8551 |
2025-08-11 00:00:00.0 |
9.2097 |
240 |
73 |
553.9370 |
2025-08-12 00:00:00.0 |
9.0819 |
240 |
74 |
561.6649 |
2025-08-13 00:00:00.0 |
7.7279 |
240 |
75 |
568.4233 |
2025-08-14 00:00:00.0 |
6.7584 |
240 |
76 |
577.1474 |
2025-08-15 00:00:00.0 |
8.7241 |
240 |
77 |
584.1526 |
2025-08-16 00:00:00.0 |
7.0052 |
240 |
78 |
592.3182 |
2025-08-17 00:00:00.0 |
8.1656 |
240 |
79 |
600.7269 |
2025-08-18 00:00:00.0 |
8.4087 |
240 |
80 |
609.9879 |
2025-08-19 00:00:00.0 |
9.2610 |
240 |
81 |
618.2728 |
2025-08-20 00:00:00.0 |
8.2849 |
240 |
82 |
625.5208 |
2025-08-21 00:00:00.0 |
7.2480 |
240 |
83 |
633.5621 |
2025-08-22 00:00:00.0 |
8.0413 |
240 |
84 |
640.1160 |
2025-08-23 00:00:00.0 |
6.5539 |
240 |
85 |
647.1956 |
2025-08-24 00:00:00.0 |
7.0796 |
240 |
86 |
652.6961 |
2025-08-25 00:00:00.0 |
5.5005 |
240 |
87 |
658.7175 |
2025-08-26 00:00:00.0 |
6.0214 |
240 |
88 |
665.6295 |
2025-08-27 00:00:00.0 |
6.9120 |
240 |
89 |
673.1280 |
2025-08-28 00:00:00.0 |
7.4985 |
240 |
90 |
680.2015 |
2025-08-29 00:00:00.0 |
7.0735 |
240 |
91 |
687.3222 |
2025-08-30 00:00:00.0 |
7.1207 |
240 |
92 |
694.4251 |
2025-08-31 00:00:00.0 |
7.1029 |
240 |
93 |
701.4982 |
2025-09-01 00:00:00.0 |
7.0731 |
240 |
94 |
709.3735 |
2025-09-02 00:00:00.0 |
7.8753 |
240 |
95 |
713.6514 |
2025-09-03 00:00:00.0 |
4.2779 |
240 |
96 |
715.6061 |
2025-09-04 00:00:00.0 |
1.9547 |
240 |
97 |
716.3076 |
2025-09-05 00:00:00.0 |
0.7015 |
240 |
98 |
719.6932 |
2025-09-06 00:00:00.0 |
3.3856 |
240 |
99 |
722.3100 |
2025-09-07 00:00:00.0 |
2.6168 |
240 |
100 |
726.1561 |
2025-09-08 00:00:00.0 |
3.8461 |
240 |
101 |
732.3098 |
2025-09-09 00:00:00.0 |
6.1537 |
240 |
102 |
738.6109 |
2025-09-10 00:00:00.0 |
6.3011 |
240 |
103 |
745.5120 |
2025-09-11 00:00:00.0 |
6.9011 |
240 |
104 |
754.7978 |
2025-09-12 00:00:00.0 |
9.2858 |
240 |
105 |
764.1369 |
2025-09-13 00:00:00.0 |
9.3391 |
240 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '240') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-13'}
ORDER BY ddate ASC |