query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
43.9632 |
2024-06-06 00:00:00.0 |
7.1875 |
558 |
2 |
49.8670 |
2024-06-07 00:00:00.0 |
5.9038 |
558 |
3 |
55.4189 |
2024-06-08 00:00:00.0 |
5.5519 |
558 |
4 |
59.7690 |
2024-06-09 00:00:00.0 |
4.3501 |
558 |
5 |
64.3289 |
2024-06-10 00:00:00.0 |
4.5599 |
558 |
6 |
72.9757 |
2024-06-11 00:00:00.0 |
8.6468 |
558 |
7 |
80.7019 |
2024-06-12 00:00:00.0 |
7.7262 |
558 |
8 |
88.1663 |
2024-06-13 00:00:00.0 |
7.4644 |
558 |
9 |
95.5561 |
2024-06-14 00:00:00.0 |
7.3898 |
558 |
10 |
104.2831 |
2024-06-15 00:00:00.0 |
8.7270 |
558 |
11 |
113.1015 |
2024-06-16 00:00:00.0 |
8.8184 |
558 |
12 |
118.2570 |
2024-06-17 00:00:00.0 |
5.1555 |
558 |
13 |
123.8537 |
2024-06-18 00:00:00.0 |
5.5967 |
558 |
14 |
128.8671 |
2024-06-19 00:00:00.0 |
5.0134 |
558 |
15 |
136.2581 |
2024-06-20 00:00:00.0 |
7.3910 |
558 |
16 |
144.4079 |
2024-06-21 00:00:00.0 |
8.1498 |
558 |
17 |
153.0835 |
2024-06-22 00:00:00.0 |
8.6756 |
558 |
18 |
161.3413 |
2024-06-23 00:00:00.0 |
8.2578 |
558 |
19 |
170.0964 |
2024-06-24 00:00:00.0 |
8.7551 |
558 |
20 |
178.4623 |
2024-06-25 00:00:00.0 |
8.3659 |
558 |
21 |
185.8883 |
2024-06-26 00:00:00.0 |
7.4260 |
558 |
22 |
192.5166 |
2024-06-27 00:00:00.0 |
6.6283 |
558 |
23 |
198.3942 |
2024-06-28 00:00:00.0 |
5.8776 |
558 |
24 |
203.7994 |
2024-06-29 00:00:00.0 |
5.4052 |
558 |
25 |
209.5496 |
2024-06-30 00:00:00.0 |
5.7502 |
558 |
26 |
218.6425 |
2024-07-01 00:00:00.0 |
9.0929 |
558 |
27 |
227.5728 |
2024-07-02 00:00:00.0 |
8.9303 |
558 |
28 |
236.1159 |
2024-07-03 00:00:00.0 |
8.5431 |
558 |
29 |
244.8759 |
2024-07-04 00:00:00.0 |
8.7600 |
558 |
30 |
252.3898 |
2024-07-05 00:00:00.0 |
7.5139 |
558 |
31 |
260.8340 |
2024-07-06 00:00:00.0 |
8.4442 |
558 |
32 |
269.1594 |
2024-07-07 00:00:00.0 |
8.3254 |
558 |
33 |
277.7039 |
2024-07-08 00:00:00.0 |
8.5445 |
558 |
34 |
285.8438 |
2024-07-09 00:00:00.0 |
8.1399 |
558 |
35 |
294.1644 |
2024-07-10 00:00:00.0 |
8.3206 |
558 |
36 |
301.5960 |
2024-07-11 00:00:00.0 |
7.4316 |
558 |
37 |
309.0770 |
2024-07-12 00:00:00.0 |
7.4810 |
558 |
38 |
317.6628 |
2024-07-13 00:00:00.0 |
8.5858 |
558 |
39 |
326.0933 |
2024-07-14 00:00:00.0 |
8.4305 |
558 |
40 |
334.9188 |
2024-07-15 00:00:00.0 |
8.8255 |
558 |
41 |
342.4281 |
2024-07-16 00:00:00.0 |
7.5093 |
558 |
42 |
348.5697 |
2024-07-17 00:00:00.0 |
6.1416 |
558 |
43 |
356.1078 |
2024-07-18 00:00:00.0 |
7.5381 |
558 |
44 |
363.9673 |
2024-07-19 00:00:00.0 |
7.8595 |
558 |
45 |
372.3272 |
2024-07-20 00:00:00.0 |
8.3599 |
558 |
46 |
381.1268 |
2024-07-21 00:00:00.0 |
8.7996 |
558 |
47 |
390.1876 |
2024-07-22 00:00:00.0 |
9.0608 |
558 |
48 |
399.5843 |
2024-07-23 00:00:00.0 |
9.3967 |
558 |
49 |
408.6396 |
2024-07-24 00:00:00.0 |
9.0553 |
558 |
50 |
416.4409 |
2024-07-25 00:00:00.0 |
7.8013 |
558 |
51 |
425.1600 |
2024-07-26 00:00:00.0 |
8.7191 |
558 |
52 |
432.4839 |
2024-07-27 00:00:00.0 |
7.3239 |
558 |
53 |
440.6259 |
2024-07-28 00:00:00.0 |
8.1420 |
558 |
54 |
448.8467 |
2024-07-29 00:00:00.0 |
8.2208 |
558 |
55 |
456.4119 |
2024-07-30 00:00:00.0 |
7.5652 |
558 |
56 |
464.7344 |
2024-07-31 00:00:00.0 |
8.3225 |
558 |
57 |
471.8132 |
2024-08-01 00:00:00.0 |
7.0788 |
558 |
58 |
479.3867 |
2024-08-02 00:00:00.0 |
7.5735 |
558 |
59 |
487.6277 |
2024-08-03 00:00:00.0 |
8.2410 |
558 |
60 |
494.1929 |
2024-08-04 00:00:00.0 |
6.5652 |
558 |
61 |
502.1911 |
2024-08-05 00:00:00.0 |
7.9982 |
558 |
62 |
509.2010 |
2024-08-06 00:00:00.0 |
7.0099 |
558 |
63 |
515.9743 |
2024-08-07 00:00:00.0 |
6.7733 |
558 |
64 |
522.0791 |
2024-08-08 00:00:00.0 |
6.1048 |
558 |
65 |
529.6053 |
2024-08-09 00:00:00.0 |
7.5262 |
558 |
66 |
536.0369 |
2024-08-10 00:00:00.0 |
6.4316 |
558 |
67 |
542.8915 |
2024-08-11 00:00:00.0 |
6.8546 |
558 |
68 |
549.7967 |
2024-08-12 00:00:00.0 |
6.9052 |
558 |
69 |
558.0711 |
2024-08-13 00:00:00.0 |
8.2744 |
558 |
70 |
567.4817 |
2024-08-14 00:00:00.0 |
9.4106 |
558 |
71 |
577.0836 |
2024-08-15 00:00:00.0 |
9.6019 |
558 |
72 |
586.2533 |
2024-08-16 00:00:00.0 |
9.1697 |
558 |
73 |
594.2361 |
2024-08-17 00:00:00.0 |
7.9828 |
558 |
74 |
602.4189 |
2024-08-18 00:00:00.0 |
8.1828 |
558 |
75 |
610.7966 |
2024-08-19 00:00:00.0 |
8.3777 |
558 |
76 |
619.0174 |
2024-08-20 00:00:00.0 |
8.2208 |
558 |
77 |
627.9467 |
2024-08-21 00:00:00.0 |
8.9293 |
558 |
78 |
636.9269 |
2024-08-22 00:00:00.0 |
8.9802 |
558 |
79 |
645.4777 |
2024-08-23 00:00:00.0 |
8.5508 |
558 |
80 |
653.1289 |
2024-08-24 00:00:00.0 |
7.6512 |
558 |
81 |
661.6834 |
2024-08-25 00:00:00.0 |
8.5545 |
558 |
82 |
669.4911 |
2024-08-26 00:00:00.0 |
7.8077 |
558 |
83 |
676.1721 |
2024-08-27 00:00:00.0 |
6.6810 |
558 |
84 |
682.2470 |
2024-08-28 00:00:00.0 |
6.0749 |
558 |
85 |
690.5644 |
2024-08-29 00:00:00.0 |
8.3174 |
558 |
86 |
698.5319 |
2024-08-30 00:00:00.0 |
7.9675 |
558 |
87 |
706.1506 |
2024-08-31 00:00:00.0 |
7.6187 |
558 |
88 |
712.0196 |
2024-09-01 00:00:00.0 |
5.8690 |
558 |
89 |
718.9897 |
2024-09-02 00:00:00.0 |
6.9701 |
558 |
90 |
726.2597 |
2024-09-03 00:00:00.0 |
7.2700 |
558 |
91 |
734.9997 |
2024-09-04 00:00:00.0 |
8.7400 |
558 |
92 |
741.1121 |
2024-09-05 00:00:00.0 |
6.1124 |
558 |
93 |
746.0237 |
2024-09-06 00:00:00.0 |
4.9116 |
558 |
94 |
751.7994 |
2024-09-07 00:00:00.0 |
5.7757 |
558 |
95 |
757.6368 |
2024-09-08 00:00:00.0 |
5.8374 |
558 |
96 |
764.5978 |
2024-09-09 00:00:00.0 |
6.9610 |
558 |
97 |
773.0487 |
2024-09-10 00:00:00.0 |
8.4509 |
558 |
98 |
778.8556 |
2024-09-11 00:00:00.0 |
5.8069 |
558 |
99 |
786.6737 |
2024-09-12 00:00:00.0 |
7.8181 |
558 |
100 |
796.1704 |
2024-09-13 00:00:00.0 |
9.4967 |
558 |
101 |
803.8445 |
2024-09-14 00:00:00.0 |
7.6741 |
558 |
102 |
811.2756 |
2024-09-15 00:00:00.0 |
7.4311 |
558 |
103 |
818.9516 |
2024-09-16 00:00:00.0 |
7.6760 |
558 |
104 |
827.6908 |
2024-09-17 00:00:00.0 |
8.7392 |
558 |
105 |
836.6799 |
2024-09-18 00:00:00.0 |
8.9891 |
558 |
106 |
845.1767 |
2024-09-19 00:00:00.0 |
8.4968 |
558 |
107 |
852.5390 |
2024-09-20 00:00:00.0 |
7.3623 |
558 |
108 |
857.5388 |
2024-09-21 00:00:00.0 |
4.9998 |
558 |
109 |
861.6500 |
2024-09-22 00:00:00.0 |
4.1112 |
558 |
110 |
868.7873 |
2024-09-23 00:00:00.0 |
7.1373 |
558 |
111 |
875.6705 |
2024-09-24 00:00:00.0 |
6.8832 |
558 |
112 |
882.5289 |
2024-09-25 00:00:00.0 |
6.8584 |
558 |
113 |
889.7071 |
2024-09-26 00:00:00.0 |
7.1782 |
558 |
114 |
895.6143 |
2024-09-27 00:00:00.0 |
5.9072 |
558 |
115 |
902.2489 |
2024-09-28 00:00:00.0 |
6.6346 |
558 |
116 |
908.4320 |
2024-09-29 00:00:00.0 |
6.1831 |
558 |
117 |
915.2693 |
2024-09-30 00:00:00.0 |
6.8373 |
558 |
118 |
918.7046 |
2024-10-01 00:00:00.0 |
3.4353 |
558 |
119 |
921.4323 |
2024-10-02 00:00:00.0 |
2.7277 |
558 |
120 |
922.2111 |
2024-10-03 00:00:00.0 |
0.7788 |
558 |
121 |
925.4810 |
2024-10-04 00:00:00.0 |
3.2699 |
558 |
122 |
929.3739 |
2024-10-05 00:00:00.0 |
3.8929 |
558 |
123 |
932.3499 |
2024-10-06 00:00:00.0 |
2.9760 |
558 |
124 |
935.7616 |
2024-10-07 00:00:00.0 |
3.4117 |
558 |
125 |
941.5695 |
2024-10-08 00:00:00.0 |
5.8079 |
558 |
126 |
947.0372 |
2024-10-09 00:00:00.0 |
5.4677 |
558 |
127 |
952.2208 |
2024-10-10 00:00:00.0 |
5.1836 |
558 |
128 |
954.4807 |
2024-10-11 00:00:00.0 |
2.2599 |
558 |
129 |
957.2980 |
2024-10-12 00:00:00.0 |
2.8173 |
558 |
130 |
958.1480 |
2024-10-13 00:00:00.0 |
0.8500 |
558 |
131 |
958.4331 |
2024-10-14 00:00:00.0 |
0.2851 |
558 |
|
CACHED |
false |
EXECUTIONTIME |
15 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '558') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-14'}
ORDER BY ddate ASC |