query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.3387 |
2025-06-01 00:00:00.0 |
7.3387 |
230 |
2 |
14.3088 |
2025-06-02 00:00:00.0 |
6.9701 |
230 |
3 |
22.9844 |
2025-06-03 00:00:00.0 |
8.6756 |
230 |
4 |
31.3950 |
2025-06-04 00:00:00.0 |
8.4106 |
230 |
5 |
38.9278 |
2025-06-05 00:00:00.0 |
7.5328 |
230 |
6 |
46.2360 |
2025-06-06 00:00:00.0 |
7.3082 |
230 |
7 |
53.7261 |
2025-06-07 00:00:00.0 |
7.4901 |
230 |
8 |
62.1400 |
2025-06-08 00:00:00.0 |
8.4139 |
230 |
9 |
67.2161 |
2025-06-09 00:00:00.0 |
5.0761 |
230 |
10 |
73.0561 |
2025-06-10 00:00:00.0 |
5.8400 |
230 |
11 |
80.6921 |
2025-06-11 00:00:00.0 |
7.6360 |
230 |
12 |
88.3984 |
2025-06-12 00:00:00.0 |
7.7063 |
230 |
13 |
95.6111 |
2025-06-13 00:00:00.0 |
7.2127 |
230 |
14 |
102.6958 |
2025-06-14 00:00:00.0 |
7.0847 |
230 |
15 |
110.5281 |
2025-06-15 00:00:00.0 |
7.8323 |
230 |
16 |
118.2812 |
2025-06-16 00:00:00.0 |
7.7531 |
230 |
17 |
127.5874 |
2025-06-17 00:00:00.0 |
9.3062 |
230 |
18 |
136.2890 |
2025-06-18 00:00:00.0 |
8.7016 |
230 |
19 |
143.8574 |
2025-06-19 00:00:00.0 |
7.5684 |
230 |
20 |
151.7618 |
2025-06-20 00:00:00.0 |
7.9044 |
230 |
21 |
159.7187 |
2025-06-21 00:00:00.0 |
7.9569 |
230 |
22 |
167.6794 |
2025-06-22 00:00:00.0 |
7.9607 |
230 |
23 |
176.4703 |
2025-06-23 00:00:00.0 |
8.7909 |
230 |
24 |
182.4261 |
2025-06-24 00:00:00.0 |
5.9558 |
230 |
25 |
188.4410 |
2025-06-25 00:00:00.0 |
6.0149 |
230 |
26 |
196.9342 |
2025-06-26 00:00:00.0 |
8.4932 |
230 |
27 |
205.7574 |
2025-06-27 00:00:00.0 |
8.8232 |
230 |
28 |
213.9263 |
2025-06-28 00:00:00.0 |
8.1689 |
230 |
29 |
221.3658 |
2025-06-29 00:00:00.0 |
7.4395 |
230 |
30 |
230.4650 |
2025-06-30 00:00:00.0 |
9.0992 |
230 |
31 |
239.3885 |
2025-07-01 00:00:00.0 |
8.9235 |
230 |
32 |
246.5900 |
2025-07-02 00:00:00.0 |
7.2015 |
230 |
33 |
254.0792 |
2025-07-03 00:00:00.0 |
7.4892 |
230 |
34 |
261.4812 |
2025-07-04 00:00:00.0 |
7.4020 |
230 |
35 |
267.2023 |
2025-07-05 00:00:00.0 |
5.7211 |
230 |
36 |
276.4108 |
2025-07-06 00:00:00.0 |
9.2085 |
230 |
37 |
284.5870 |
2025-07-07 00:00:00.0 |
8.1762 |
230 |
38 |
293.0934 |
2025-07-08 00:00:00.0 |
8.5064 |
230 |
39 |
300.4500 |
2025-07-09 00:00:00.0 |
7.3566 |
230 |
40 |
308.7209 |
2025-07-10 00:00:00.0 |
8.2709 |
230 |
41 |
315.4010 |
2025-07-11 00:00:00.0 |
6.6801 |
230 |
42 |
324.6490 |
2025-07-12 00:00:00.0 |
9.2480 |
230 |
43 |
333.3105 |
2025-07-13 00:00:00.0 |
8.6615 |
230 |
44 |
342.1641 |
2025-07-14 00:00:00.0 |
8.8536 |
230 |
45 |
351.5428 |
2025-07-15 00:00:00.0 |
9.3787 |
230 |
46 |
351.5428 |
2025-07-16 00:00:00.0 |
0.0000 |
230 |
47 |
358.8696 |
2025-07-17 00:00:00.0 |
7.3268 |
230 |
48 |
365.1504 |
2025-07-18 00:00:00.0 |
6.2808 |
230 |
49 |
373.5743 |
2025-07-19 00:00:00.0 |
8.4239 |
230 |
50 |
380.8454 |
2025-07-20 00:00:00.0 |
7.2711 |
230 |
51 |
389.4308 |
2025-07-21 00:00:00.0 |
8.5854 |
230 |
52 |
397.8399 |
2025-07-22 00:00:00.0 |
8.4091 |
230 |
53 |
407.4200 |
2025-07-23 00:00:00.0 |
9.5801 |
230 |
54 |
416.2449 |
2025-07-24 00:00:00.0 |
8.8249 |
230 |
55 |
424.9333 |
2025-07-25 00:00:00.0 |
8.6884 |
230 |
56 |
432.5908 |
2025-07-26 00:00:00.0 |
7.6575 |
230 |
57 |
438.9250 |
2025-07-27 00:00:00.0 |
6.3342 |
230 |
58 |
447.9655 |
2025-07-28 00:00:00.0 |
9.0405 |
230 |
59 |
457.1128 |
2025-07-29 00:00:00.0 |
9.1473 |
230 |
60 |
465.7665 |
2025-07-30 00:00:00.0 |
8.6537 |
230 |
61 |
473.6854 |
2025-07-31 00:00:00.0 |
7.9189 |
230 |
62 |
480.2437 |
2025-08-01 00:00:00.0 |
6.5583 |
230 |
63 |
487.3335 |
2025-08-02 00:00:00.0 |
7.0898 |
230 |
64 |
496.1848 |
2025-08-03 00:00:00.0 |
8.8513 |
230 |
65 |
504.7619 |
2025-08-04 00:00:00.0 |
8.5771 |
230 |
66 |
514.2696 |
2025-08-05 00:00:00.0 |
9.5077 |
230 |
67 |
523.4031 |
2025-08-06 00:00:00.0 |
9.1335 |
230 |
68 |
531.5472 |
2025-08-07 00:00:00.0 |
8.1441 |
230 |
69 |
538.3213 |
2025-08-08 00:00:00.0 |
6.7741 |
230 |
70 |
547.6417 |
2025-08-09 00:00:00.0 |
9.3204 |
230 |
71 |
556.7937 |
2025-08-10 00:00:00.0 |
9.1520 |
230 |
72 |
566.1737 |
2025-08-11 00:00:00.0 |
9.3800 |
230 |
73 |
575.5236 |
2025-08-12 00:00:00.0 |
9.3499 |
230 |
74 |
583.7888 |
2025-08-13 00:00:00.0 |
8.2652 |
230 |
75 |
591.1413 |
2025-08-14 00:00:00.0 |
7.3525 |
230 |
76 |
599.1324 |
2025-08-15 00:00:00.0 |
7.9911 |
230 |
77 |
607.7178 |
2025-08-16 00:00:00.0 |
8.5854 |
230 |
78 |
616.3319 |
2025-08-17 00:00:00.0 |
8.6141 |
230 |
79 |
624.6096 |
2025-08-18 00:00:00.0 |
8.2777 |
230 |
80 |
633.6556 |
2025-08-19 00:00:00.0 |
9.0460 |
230 |
81 |
641.5889 |
2025-08-20 00:00:00.0 |
7.9333 |
230 |
82 |
649.6808 |
2025-08-21 00:00:00.0 |
8.0919 |
230 |
83 |
657.8534 |
2025-08-22 00:00:00.0 |
8.1726 |
230 |
84 |
665.4477 |
2025-08-23 00:00:00.0 |
7.5943 |
230 |
85 |
673.6396 |
2025-08-24 00:00:00.0 |
8.1919 |
230 |
86 |
679.4206 |
2025-08-25 00:00:00.0 |
5.7810 |
230 |
87 |
685.6071 |
2025-08-26 00:00:00.0 |
6.1865 |
230 |
88 |
693.5563 |
2025-08-27 00:00:00.0 |
7.9492 |
230 |
89 |
700.6376 |
2025-08-28 00:00:00.0 |
7.0813 |
230 |
90 |
708.1547 |
2025-08-29 00:00:00.0 |
7.5171 |
230 |
91 |
714.6946 |
2025-08-30 00:00:00.0 |
6.5399 |
230 |
92 |
721.9103 |
2025-08-31 00:00:00.0 |
7.2157 |
230 |
93 |
729.5431 |
2025-09-01 00:00:00.0 |
7.6328 |
230 |
94 |
738.0006 |
2025-09-02 00:00:00.0 |
8.4575 |
230 |
95 |
744.3792 |
2025-09-03 00:00:00.0 |
6.3786 |
230 |
96 |
748.1786 |
2025-09-04 00:00:00.0 |
3.7994 |
230 |
97 |
748.4949 |
2025-09-05 00:00:00.0 |
0.3163 |
230 |
98 |
752.8250 |
2025-09-06 00:00:00.0 |
4.3301 |
230 |
99 |
756.9990 |
2025-09-07 00:00:00.0 |
4.1740 |
230 |
100 |
761.2413 |
2025-09-08 00:00:00.0 |
4.2423 |
230 |
101 |
767.4141 |
2025-09-09 00:00:00.0 |
6.1728 |
230 |
102 |
774.1046 |
2025-09-10 00:00:00.0 |
6.6905 |
230 |
103 |
781.0398 |
2025-09-11 00:00:00.0 |
6.9352 |
230 |
104 |
789.1174 |
2025-09-12 00:00:00.0 |
8.0776 |
230 |
105 |
797.3545 |
2025-09-13 00:00:00.0 |
8.2371 |
230 |
106 |
806.7699 |
2025-09-14 00:00:00.0 |
9.4154 |
230 |
107 |
815.4972 |
2025-09-15 00:00:00.0 |
8.7273 |
230 |
108 |
825.2720 |
2025-09-16 00:00:00.0 |
9.7748 |
230 |
|
CACHED |
false |
EXECUTIONTIME |
78 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '230') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'}
ORDER BY ddate ASC |