query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.0931 |
2025-06-01 00:00:00.0 |
7.0931 |
223 |
2 |
14.5050 |
2025-06-02 00:00:00.0 |
7.4119 |
223 |
3 |
23.1993 |
2025-06-03 00:00:00.0 |
8.6943 |
223 |
4 |
31.1085 |
2025-06-04 00:00:00.0 |
7.9092 |
223 |
5 |
38.3933 |
2025-06-05 00:00:00.0 |
7.2848 |
223 |
6 |
43.7919 |
2025-06-06 00:00:00.0 |
5.3986 |
223 |
7 |
51.0014 |
2025-06-07 00:00:00.0 |
7.2095 |
223 |
8 |
59.6278 |
2025-06-08 00:00:00.0 |
8.6264 |
223 |
9 |
65.1358 |
2025-06-09 00:00:00.0 |
5.5080 |
223 |
10 |
69.5431 |
2025-06-10 00:00:00.0 |
4.4073 |
223 |
11 |
75.8860 |
2025-06-11 00:00:00.0 |
6.3429 |
223 |
12 |
80.8048 |
2025-06-12 00:00:00.0 |
4.9188 |
223 |
13 |
88.7164 |
2025-06-13 00:00:00.0 |
7.9116 |
223 |
14 |
96.1112 |
2025-06-14 00:00:00.0 |
7.3948 |
223 |
15 |
103.7186 |
2025-06-15 00:00:00.0 |
7.6074 |
223 |
16 |
111.3946 |
2025-06-16 00:00:00.0 |
7.6760 |
223 |
17 |
120.9384 |
2025-06-17 00:00:00.0 |
9.5438 |
223 |
18 |
129.6763 |
2025-06-18 00:00:00.0 |
8.7379 |
223 |
19 |
137.4488 |
2025-06-19 00:00:00.0 |
7.7725 |
223 |
20 |
146.0245 |
2025-06-20 00:00:00.0 |
8.5757 |
223 |
21 |
154.0691 |
2025-06-21 00:00:00.0 |
8.0446 |
223 |
22 |
162.1000 |
2025-06-22 00:00:00.0 |
8.0309 |
223 |
23 |
170.8888 |
2025-06-23 00:00:00.0 |
8.7888 |
223 |
24 |
177.9908 |
2025-06-24 00:00:00.0 |
7.1020 |
223 |
25 |
183.4285 |
2025-06-25 00:00:00.0 |
5.4377 |
223 |
26 |
191.8433 |
2025-06-26 00:00:00.0 |
8.4148 |
223 |
27 |
200.6069 |
2025-06-27 00:00:00.0 |
8.7636 |
223 |
28 |
208.1855 |
2025-06-28 00:00:00.0 |
7.5786 |
223 |
29 |
215.5389 |
2025-06-29 00:00:00.0 |
7.3534 |
223 |
30 |
224.5211 |
2025-06-30 00:00:00.0 |
8.9822 |
223 |
31 |
233.5223 |
2025-07-01 00:00:00.0 |
9.0012 |
223 |
32 |
242.0334 |
2025-07-02 00:00:00.0 |
8.5111 |
223 |
33 |
250.2871 |
2025-07-03 00:00:00.0 |
8.2537 |
223 |
34 |
257.2342 |
2025-07-04 00:00:00.0 |
6.9471 |
223 |
35 |
264.1135 |
2025-07-05 00:00:00.0 |
6.8793 |
223 |
36 |
273.0756 |
2025-07-06 00:00:00.0 |
8.9621 |
223 |
37 |
281.0468 |
2025-07-07 00:00:00.0 |
7.9712 |
223 |
38 |
288.7795 |
2025-07-08 00:00:00.0 |
7.7327 |
223 |
39 |
297.0837 |
2025-07-09 00:00:00.0 |
8.3042 |
223 |
40 |
304.9955 |
2025-07-10 00:00:00.0 |
7.9118 |
223 |
41 |
311.9491 |
2025-07-11 00:00:00.0 |
6.9536 |
223 |
42 |
321.5051 |
2025-07-12 00:00:00.0 |
9.5560 |
223 |
43 |
330.1551 |
2025-07-13 00:00:00.0 |
8.6500 |
223 |
44 |
339.1681 |
2025-07-14 00:00:00.0 |
9.0130 |
223 |
45 |
348.4206 |
2025-07-15 00:00:00.0 |
9.2525 |
223 |
46 |
356.6928 |
2025-07-16 00:00:00.0 |
8.2722 |
223 |
47 |
362.5698 |
2025-07-17 00:00:00.0 |
5.8770 |
223 |
48 |
368.2724 |
2025-07-18 00:00:00.0 |
5.7026 |
223 |
49 |
376.2140 |
2025-07-19 00:00:00.0 |
7.9416 |
223 |
50 |
384.1142 |
2025-07-20 00:00:00.0 |
7.9002 |
223 |
51 |
391.8766 |
2025-07-21 00:00:00.0 |
7.7624 |
223 |
52 |
400.8085 |
2025-07-22 00:00:00.0 |
8.9319 |
223 |
53 |
410.3741 |
2025-07-23 00:00:00.0 |
9.5656 |
223 |
54 |
419.5514 |
2025-07-24 00:00:00.0 |
9.1773 |
223 |
55 |
428.5579 |
2025-07-25 00:00:00.0 |
9.0065 |
223 |
56 |
436.1160 |
2025-07-26 00:00:00.0 |
7.5581 |
223 |
57 |
443.6523 |
2025-07-27 00:00:00.0 |
7.5363 |
223 |
58 |
453.1737 |
2025-07-28 00:00:00.0 |
9.5214 |
223 |
59 |
462.0323 |
2025-07-29 00:00:00.0 |
8.8586 |
223 |
60 |
470.3808 |
2025-07-30 00:00:00.0 |
8.3485 |
223 |
61 |
476.8537 |
2025-07-31 00:00:00.0 |
6.4729 |
223 |
62 |
483.4767 |
2025-08-01 00:00:00.0 |
6.6230 |
223 |
63 |
491.3812 |
2025-08-02 00:00:00.0 |
7.9045 |
223 |
64 |
500.6121 |
2025-08-03 00:00:00.0 |
9.2309 |
223 |
65 |
508.7269 |
2025-08-04 00:00:00.0 |
8.1148 |
223 |
66 |
517.6393 |
2025-08-05 00:00:00.0 |
8.9124 |
223 |
67 |
526.8709 |
2025-08-06 00:00:00.0 |
9.2316 |
223 |
68 |
536.2421 |
2025-08-07 00:00:00.0 |
9.3712 |
223 |
69 |
543.9077 |
2025-08-08 00:00:00.0 |
7.6656 |
223 |
70 |
553.3337 |
2025-08-09 00:00:00.0 |
9.4260 |
223 |
71 |
562.8323 |
2025-08-10 00:00:00.0 |
9.4986 |
223 |
72 |
572.1322 |
2025-08-11 00:00:00.0 |
9.2999 |
223 |
73 |
581.5528 |
2025-08-12 00:00:00.0 |
9.4206 |
223 |
74 |
590.4148 |
2025-08-13 00:00:00.0 |
8.8620 |
223 |
75 |
597.0960 |
2025-08-14 00:00:00.0 |
6.6812 |
223 |
76 |
605.4740 |
2025-08-15 00:00:00.0 |
8.3780 |
223 |
77 |
614.2890 |
2025-08-16 00:00:00.0 |
8.8150 |
223 |
78 |
622.5270 |
2025-08-17 00:00:00.0 |
8.2380 |
223 |
79 |
630.9867 |
2025-08-18 00:00:00.0 |
8.4597 |
223 |
80 |
640.5312 |
2025-08-19 00:00:00.0 |
9.5445 |
223 |
81 |
649.5048 |
2025-08-20 00:00:00.0 |
8.9736 |
223 |
82 |
658.1040 |
2025-08-21 00:00:00.0 |
8.5992 |
223 |
83 |
667.2006 |
2025-08-22 00:00:00.0 |
9.0966 |
223 |
84 |
675.5645 |
2025-08-23 00:00:00.0 |
8.3639 |
223 |
85 |
683.0815 |
2025-08-24 00:00:00.0 |
7.5170 |
223 |
86 |
688.6635 |
2025-08-25 00:00:00.0 |
5.5820 |
223 |
87 |
693.2188 |
2025-08-26 00:00:00.0 |
4.5553 |
223 |
88 |
701.4081 |
2025-08-27 00:00:00.0 |
8.1893 |
223 |
89 |
710.5003 |
2025-08-28 00:00:00.0 |
9.0922 |
223 |
90 |
718.2233 |
2025-08-29 00:00:00.0 |
7.7230 |
223 |
91 |
726.0546 |
2025-08-30 00:00:00.0 |
7.8313 |
223 |
92 |
733.7202 |
2025-08-31 00:00:00.0 |
7.6656 |
223 |
93 |
741.8632 |
2025-09-01 00:00:00.0 |
8.1430 |
223 |
94 |
750.7867 |
2025-09-02 00:00:00.0 |
8.9235 |
223 |
95 |
756.3649 |
2025-09-03 00:00:00.0 |
5.5782 |
223 |
96 |
759.3362 |
2025-09-04 00:00:00.0 |
2.9713 |
223 |
97 |
759.6213 |
2025-09-05 00:00:00.0 |
0.2851 |
223 |
98 |
763.8381 |
2025-09-06 00:00:00.0 |
4.2168 |
223 |
99 |
767.3375 |
2025-09-07 00:00:00.0 |
3.4994 |
223 |
100 |
770.5564 |
2025-09-08 00:00:00.0 |
3.2189 |
223 |
101 |
777.5346 |
2025-09-09 00:00:00.0 |
6.9782 |
223 |
102 |
784.2225 |
2025-09-10 00:00:00.0 |
6.6879 |
223 |
103 |
791.0891 |
2025-09-11 00:00:00.0 |
6.8666 |
223 |
104 |
799.8175 |
2025-09-12 00:00:00.0 |
8.7284 |
223 |
105 |
808.9888 |
2025-09-13 00:00:00.0 |
9.1713 |
223 |
106 |
818.2744 |
2025-09-14 00:00:00.0 |
9.2856 |
223 |
107 |
827.9465 |
2025-09-15 00:00:00.0 |
9.6721 |
223 |
108 |
836.6678 |
2025-09-16 00:00:00.0 |
8.7213 |
223 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '223') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'}
ORDER BY ddate ASC |