query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
8.1294 |
2025-06-01 00:00:00.0 |
8.1294 |
233 |
2 |
15.5183 |
2025-06-02 00:00:00.0 |
7.3889 |
233 |
3 |
22.3543 |
2025-06-03 00:00:00.0 |
6.8360 |
233 |
4 |
28.0984 |
2025-06-04 00:00:00.0 |
5.7441 |
233 |
5 |
33.6723 |
2025-06-05 00:00:00.0 |
5.5739 |
233 |
6 |
39.7058 |
2025-06-06 00:00:00.0 |
6.0335 |
233 |
7 |
46.3077 |
2025-06-07 00:00:00.0 |
6.6019 |
233 |
8 |
53.2667 |
2025-06-08 00:00:00.0 |
6.9590 |
233 |
9 |
55.8214 |
2025-06-09 00:00:00.0 |
2.5547 |
233 |
10 |
62.0836 |
2025-06-10 00:00:00.0 |
6.2622 |
233 |
11 |
69.3031 |
2025-06-11 00:00:00.0 |
7.2195 |
233 |
12 |
75.6010 |
2025-06-12 00:00:00.0 |
6.2979 |
233 |
13 |
82.1963 |
2025-06-13 00:00:00.0 |
6.5953 |
233 |
14 |
90.1725 |
2025-06-14 00:00:00.0 |
7.9762 |
233 |
15 |
97.4975 |
2025-06-15 00:00:00.0 |
7.3250 |
233 |
16 |
106.0172 |
2025-06-16 00:00:00.0 |
8.5197 |
233 |
17 |
115.2045 |
2025-06-17 00:00:00.0 |
9.1873 |
233 |
18 |
123.4576 |
2025-06-18 00:00:00.0 |
8.2531 |
233 |
19 |
132.1013 |
2025-06-19 00:00:00.0 |
8.6437 |
233 |
20 |
140.3562 |
2025-06-20 00:00:00.0 |
8.2549 |
233 |
21 |
149.3540 |
2025-06-21 00:00:00.0 |
8.9978 |
233 |
22 |
158.2776 |
2025-06-22 00:00:00.0 |
8.9236 |
233 |
23 |
166.1546 |
2025-06-23 00:00:00.0 |
7.8770 |
233 |
24 |
169.6875 |
2025-06-24 00:00:00.0 |
3.5329 |
233 |
25 |
175.4722 |
2025-06-25 00:00:00.0 |
5.7847 |
233 |
26 |
182.4759 |
2025-06-26 00:00:00.0 |
7.0037 |
233 |
27 |
190.7678 |
2025-06-27 00:00:00.0 |
8.2919 |
233 |
28 |
198.8837 |
2025-06-28 00:00:00.0 |
8.1159 |
233 |
29 |
206.8502 |
2025-06-29 00:00:00.0 |
7.9665 |
233 |
30 |
215.5277 |
2025-06-30 00:00:00.0 |
8.6775 |
233 |
31 |
224.4503 |
2025-07-01 00:00:00.0 |
8.9226 |
233 |
32 |
232.6720 |
2025-07-02 00:00:00.0 |
8.2217 |
233 |
33 |
241.5152 |
2025-07-03 00:00:00.0 |
8.8432 |
233 |
34 |
249.0237 |
2025-07-04 00:00:00.0 |
7.5085 |
233 |
35 |
256.7453 |
2025-07-05 00:00:00.0 |
7.7216 |
233 |
36 |
265.0226 |
2025-07-06 00:00:00.0 |
8.2773 |
233 |
37 |
271.9256 |
2025-07-07 00:00:00.0 |
6.9030 |
233 |
38 |
278.5794 |
2025-07-08 00:00:00.0 |
6.6538 |
233 |
39 |
286.3788 |
2025-07-09 00:00:00.0 |
7.7994 |
233 |
40 |
293.8438 |
2025-07-10 00:00:00.0 |
7.4650 |
233 |
41 |
302.5744 |
2025-07-11 00:00:00.0 |
8.7306 |
233 |
42 |
310.8779 |
2025-07-12 00:00:00.0 |
8.3035 |
233 |
43 |
319.0460 |
2025-07-13 00:00:00.0 |
8.1681 |
233 |
44 |
327.8328 |
2025-07-14 00:00:00.0 |
8.7868 |
233 |
45 |
336.6473 |
2025-07-15 00:00:00.0 |
8.8145 |
233 |
46 |
343.3832 |
2025-07-16 00:00:00.0 |
6.7359 |
233 |
47 |
349.9213 |
2025-07-17 00:00:00.0 |
6.5381 |
233 |
48 |
356.3932 |
2025-07-18 00:00:00.0 |
6.4719 |
233 |
49 |
363.9314 |
2025-07-19 00:00:00.0 |
7.5382 |
233 |
50 |
371.5597 |
2025-07-20 00:00:00.0 |
7.6283 |
233 |
51 |
380.1965 |
2025-07-21 00:00:00.0 |
8.6368 |
233 |
52 |
389.0406 |
2025-07-22 00:00:00.0 |
8.8441 |
233 |
53 |
398.3264 |
2025-07-23 00:00:00.0 |
9.2858 |
233 |
54 |
407.5028 |
2025-07-24 00:00:00.0 |
9.1764 |
233 |
55 |
416.2451 |
2025-07-25 00:00:00.0 |
8.7423 |
233 |
56 |
423.8556 |
2025-07-26 00:00:00.0 |
7.6105 |
233 |
57 |
432.3489 |
2025-07-27 00:00:00.0 |
8.4933 |
233 |
58 |
441.5141 |
2025-07-28 00:00:00.0 |
9.1652 |
233 |
59 |
450.5074 |
2025-07-29 00:00:00.0 |
8.9933 |
233 |
60 |
458.9816 |
2025-07-30 00:00:00.0 |
8.4742 |
233 |
61 |
466.4708 |
2025-07-31 00:00:00.0 |
7.4892 |
233 |
62 |
473.7219 |
2025-08-01 00:00:00.0 |
7.2511 |
233 |
63 |
481.3290 |
2025-08-02 00:00:00.0 |
7.6071 |
233 |
64 |
489.5482 |
2025-08-03 00:00:00.0 |
8.2192 |
233 |
65 |
498.4021 |
2025-08-04 00:00:00.0 |
8.8539 |
233 |
66 |
507.5138 |
2025-08-05 00:00:00.0 |
9.1117 |
233 |
67 |
517.2295 |
2025-08-06 00:00:00.0 |
9.7157 |
233 |
68 |
526.4401 |
2025-08-07 00:00:00.0 |
9.2106 |
233 |
69 |
534.7035 |
2025-08-08 00:00:00.0 |
8.2634 |
233 |
70 |
544.3380 |
2025-08-09 00:00:00.0 |
9.6345 |
233 |
71 |
551.8229 |
2025-08-10 00:00:00.0 |
7.4849 |
233 |
72 |
561.0242 |
2025-08-11 00:00:00.0 |
9.2013 |
233 |
73 |
569.7847 |
2025-08-12 00:00:00.0 |
8.7605 |
233 |
74 |
577.2579 |
2025-08-13 00:00:00.0 |
7.4732 |
233 |
75 |
584.5233 |
2025-08-14 00:00:00.0 |
7.2654 |
233 |
76 |
593.5106 |
2025-08-15 00:00:00.0 |
8.9873 |
233 |
77 |
599.7500 |
2025-08-16 00:00:00.0 |
6.2394 |
233 |
78 |
606.8305 |
2025-08-17 00:00:00.0 |
7.0805 |
233 |
79 |
614.6123 |
2025-08-18 00:00:00.0 |
7.7818 |
233 |
80 |
623.8715 |
2025-08-19 00:00:00.0 |
9.2592 |
233 |
81 |
632.5960 |
2025-08-20 00:00:00.0 |
8.7245 |
233 |
82 |
640.9077 |
2025-08-21 00:00:00.0 |
8.3117 |
233 |
83 |
649.7510 |
2025-08-22 00:00:00.0 |
8.8433 |
233 |
84 |
655.2192 |
2025-08-23 00:00:00.0 |
5.4682 |
233 |
85 |
660.9769 |
2025-08-24 00:00:00.0 |
5.7577 |
233 |
86 |
666.2238 |
2025-08-25 00:00:00.0 |
5.2469 |
233 |
87 |
672.2784 |
2025-08-26 00:00:00.0 |
6.0546 |
233 |
88 |
679.2780 |
2025-08-27 00:00:00.0 |
6.9996 |
233 |
89 |
686.6903 |
2025-08-28 00:00:00.0 |
7.4123 |
233 |
90 |
695.0205 |
2025-08-29 00:00:00.0 |
8.3302 |
233 |
91 |
702.5155 |
2025-08-30 00:00:00.0 |
7.4950 |
233 |
92 |
709.9852 |
2025-08-31 00:00:00.0 |
7.4697 |
233 |
93 |
718.3136 |
2025-09-01 00:00:00.0 |
8.3284 |
233 |
94 |
726.7013 |
2025-09-02 00:00:00.0 |
8.3877 |
233 |
95 |
730.9627 |
2025-09-03 00:00:00.0 |
4.2614 |
233 |
96 |
732.5825 |
2025-09-04 00:00:00.0 |
1.6198 |
233 |
97 |
733.7330 |
2025-09-05 00:00:00.0 |
1.1505 |
233 |
98 |
736.0356 |
2025-09-06 00:00:00.0 |
2.3026 |
233 |
99 |
737.8102 |
2025-09-07 00:00:00.0 |
1.7746 |
233 |
100 |
741.9550 |
2025-09-08 00:00:00.0 |
4.1448 |
233 |
101 |
748.2839 |
2025-09-09 00:00:00.0 |
6.3289 |
233 |
102 |
756.1676 |
2025-09-10 00:00:00.0 |
7.8837 |
233 |
103 |
763.7067 |
2025-09-11 00:00:00.0 |
7.5391 |
233 |
104 |
772.2622 |
2025-09-12 00:00:00.0 |
8.5555 |
233 |
105 |
781.1572 |
2025-09-13 00:00:00.0 |
8.8950 |
233 |
106 |
790.7069 |
2025-09-14 00:00:00.0 |
9.5497 |
233 |
107 |
800.2435 |
2025-09-15 00:00:00.0 |
9.5366 |
233 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '233') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-15'}
ORDER BY ddate ASC |