query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
47.4785 |
2024-06-06 00:00:00.0 |
5.1213 |
203 |
2 |
53.8969 |
2024-06-07 00:00:00.0 |
6.4184 |
203 |
3 |
60.4037 |
2024-06-08 00:00:00.0 |
6.5068 |
203 |
4 |
65.7750 |
2024-06-09 00:00:00.0 |
5.3713 |
203 |
5 |
71.2710 |
2024-06-10 00:00:00.0 |
5.4960 |
203 |
6 |
80.0721 |
2024-06-11 00:00:00.0 |
8.8011 |
203 |
7 |
87.9191 |
2024-06-12 00:00:00.0 |
7.8470 |
203 |
8 |
95.8736 |
2024-06-13 00:00:00.0 |
7.9545 |
203 |
9 |
103.3881 |
2024-06-14 00:00:00.0 |
7.5145 |
203 |
10 |
111.0711 |
2024-06-15 00:00:00.0 |
7.6830 |
203 |
11 |
119.9054 |
2024-06-16 00:00:00.0 |
8.8343 |
203 |
12 |
127.1550 |
2024-06-17 00:00:00.0 |
7.2496 |
203 |
13 |
134.0872 |
2024-06-18 00:00:00.0 |
6.9322 |
203 |
14 |
141.5515 |
2024-06-19 00:00:00.0 |
7.4643 |
203 |
15 |
149.7504 |
2024-06-20 00:00:00.0 |
8.1989 |
203 |
16 |
158.2491 |
2024-06-21 00:00:00.0 |
8.4987 |
203 |
17 |
166.9276 |
2024-06-22 00:00:00.0 |
8.6785 |
203 |
18 |
175.5451 |
2024-06-23 00:00:00.0 |
8.6175 |
203 |
19 |
184.1626 |
2024-06-24 00:00:00.0 |
8.6175 |
203 |
20 |
193.3644 |
2024-06-25 00:00:00.0 |
9.2018 |
203 |
21 |
200.8532 |
2024-06-26 00:00:00.0 |
7.4888 |
203 |
22 |
207.4466 |
2024-06-27 00:00:00.0 |
6.5934 |
203 |
23 |
214.5481 |
2024-06-28 00:00:00.0 |
7.1015 |
203 |
24 |
221.4078 |
2024-06-29 00:00:00.0 |
6.8597 |
203 |
25 |
227.4709 |
2024-06-30 00:00:00.0 |
6.0631 |
203 |
26 |
236.1993 |
2024-07-01 00:00:00.0 |
8.7284 |
203 |
27 |
245.4924 |
2024-07-02 00:00:00.0 |
9.2931 |
203 |
28 |
254.6436 |
2024-07-03 00:00:00.0 |
9.1512 |
203 |
29 |
263.0895 |
2024-07-04 00:00:00.0 |
8.4459 |
203 |
30 |
271.7790 |
2024-07-05 00:00:00.0 |
8.6895 |
203 |
31 |
280.5439 |
2024-07-06 00:00:00.0 |
8.7649 |
203 |
32 |
289.2454 |
2024-07-07 00:00:00.0 |
8.7015 |
203 |
33 |
297.6306 |
2024-07-08 00:00:00.0 |
8.3852 |
203 |
34 |
305.5228 |
2024-07-09 00:00:00.0 |
7.8922 |
203 |
35 |
313.3149 |
2024-07-10 00:00:00.0 |
7.7921 |
203 |
36 |
320.8700 |
2024-07-11 00:00:00.0 |
7.5551 |
203 |
37 |
328.0403 |
2024-07-12 00:00:00.0 |
7.1703 |
203 |
38 |
335.9144 |
2024-07-13 00:00:00.0 |
7.8741 |
203 |
39 |
344.6346 |
2024-07-14 00:00:00.0 |
8.7202 |
203 |
40 |
353.7331 |
2024-07-15 00:00:00.0 |
9.0985 |
203 |
41 |
361.1067 |
2024-07-16 00:00:00.0 |
7.3736 |
203 |
42 |
367.7831 |
2024-07-17 00:00:00.0 |
6.6764 |
203 |
43 |
375.8947 |
2024-07-18 00:00:00.0 |
8.1116 |
203 |
44 |
384.4252 |
2024-07-19 00:00:00.0 |
8.5305 |
203 |
45 |
392.6143 |
2024-07-20 00:00:00.0 |
8.1891 |
203 |
46 |
401.0599 |
2024-07-21 00:00:00.0 |
8.4456 |
203 |
47 |
410.2608 |
2024-07-22 00:00:00.0 |
9.2009 |
203 |
48 |
419.6966 |
2024-07-23 00:00:00.0 |
9.4358 |
203 |
49 |
428.6656 |
2024-07-24 00:00:00.0 |
8.9690 |
203 |
50 |
437.0919 |
2024-07-25 00:00:00.0 |
8.4263 |
203 |
51 |
444.1609 |
2024-07-26 00:00:00.0 |
7.0690 |
203 |
52 |
452.6061 |
2024-07-27 00:00:00.0 |
8.4452 |
203 |
53 |
461.7830 |
2024-07-28 00:00:00.0 |
9.1769 |
203 |
54 |
470.1528 |
2024-07-29 00:00:00.0 |
8.3698 |
203 |
55 |
477.6486 |
2024-07-30 00:00:00.0 |
7.4958 |
203 |
56 |
485.8378 |
2024-07-31 00:00:00.0 |
8.1892 |
203 |
57 |
492.8660 |
2024-08-01 00:00:00.0 |
7.0282 |
203 |
58 |
500.7718 |
2024-08-02 00:00:00.0 |
7.9058 |
203 |
59 |
508.7330 |
2024-08-03 00:00:00.0 |
7.9612 |
203 |
60 |
514.7059 |
2024-08-04 00:00:00.0 |
5.9729 |
203 |
61 |
522.6477 |
2024-08-05 00:00:00.0 |
7.9418 |
203 |
62 |
529.0806 |
2024-08-06 00:00:00.0 |
6.4329 |
203 |
63 |
537.1272 |
2024-08-07 00:00:00.0 |
8.0466 |
203 |
64 |
543.2179 |
2024-08-08 00:00:00.0 |
6.0907 |
203 |
65 |
549.8797 |
2024-08-09 00:00:00.0 |
6.6618 |
203 |
66 |
556.2803 |
2024-08-10 00:00:00.0 |
6.4006 |
203 |
67 |
563.3606 |
2024-08-11 00:00:00.0 |
7.0803 |
203 |
68 |
570.3926 |
2024-08-12 00:00:00.0 |
7.0320 |
203 |
69 |
577.9017 |
2024-08-13 00:00:00.0 |
7.5091 |
203 |
70 |
586.9174 |
2024-08-14 00:00:00.0 |
9.0157 |
203 |
71 |
596.6889 |
2024-08-15 00:00:00.0 |
9.7715 |
203 |
72 |
606.0902 |
2024-08-16 00:00:00.0 |
9.4013 |
203 |
73 |
614.6012 |
2024-08-17 00:00:00.0 |
8.5110 |
203 |
74 |
622.1786 |
2024-08-18 00:00:00.0 |
7.5774 |
203 |
75 |
630.2196 |
2024-08-19 00:00:00.0 |
8.0410 |
203 |
76 |
638.1679 |
2024-08-20 00:00:00.0 |
7.9483 |
203 |
77 |
646.9919 |
2024-08-21 00:00:00.0 |
8.8240 |
203 |
78 |
656.3583 |
2024-08-22 00:00:00.0 |
9.3664 |
203 |
79 |
664.0239 |
2024-08-23 00:00:00.0 |
7.6656 |
203 |
80 |
671.3853 |
2024-08-24 00:00:00.0 |
7.3614 |
203 |
81 |
678.1086 |
2024-08-25 00:00:00.0 |
6.7233 |
203 |
82 |
686.2286 |
2024-08-26 00:00:00.0 |
8.1200 |
203 |
83 |
691.7045 |
2024-08-27 00:00:00.0 |
5.4759 |
203 |
84 |
698.3172 |
2024-08-28 00:00:00.0 |
6.6127 |
203 |
85 |
707.2837 |
2024-08-29 00:00:00.0 |
8.9665 |
203 |
86 |
715.5970 |
2024-08-30 00:00:00.0 |
8.3133 |
203 |
87 |
722.9915 |
2024-08-31 00:00:00.0 |
7.3945 |
203 |
88 |
729.0028 |
2024-09-01 00:00:00.0 |
6.0113 |
203 |
89 |
736.8819 |
2024-09-02 00:00:00.0 |
7.8791 |
203 |
90 |
744.5171 |
2024-09-03 00:00:00.0 |
7.6352 |
203 |
91 |
753.9585 |
2024-09-04 00:00:00.0 |
9.4414 |
203 |
92 |
760.2770 |
2024-09-05 00:00:00.0 |
6.3185 |
203 |
93 |
765.1142 |
2024-09-06 00:00:00.0 |
4.8372 |
203 |
94 |
771.3772 |
2024-09-07 00:00:00.0 |
6.2630 |
203 |
95 |
778.5768 |
2024-09-08 00:00:00.0 |
7.1996 |
203 |
96 |
785.9788 |
2024-09-09 00:00:00.0 |
7.4020 |
203 |
97 |
794.8349 |
2024-09-10 00:00:00.0 |
8.8561 |
203 |
98 |
801.9253 |
2024-09-11 00:00:00.0 |
7.0904 |
203 |
99 |
809.4423 |
2024-09-12 00:00:00.0 |
7.5170 |
203 |
100 |
818.2080 |
2024-09-13 00:00:00.0 |
8.7657 |
203 |
101 |
826.9523 |
2024-09-14 00:00:00.0 |
8.7443 |
203 |
102 |
834.6203 |
2024-09-15 00:00:00.0 |
7.6680 |
203 |
103 |
843.5705 |
2024-09-16 00:00:00.0 |
8.9502 |
203 |
104 |
852.9965 |
2024-09-17 00:00:00.0 |
9.4260 |
203 |
105 |
862.1843 |
2024-09-18 00:00:00.0 |
9.1878 |
203 |
106 |
871.9700 |
2024-09-19 00:00:00.0 |
9.7857 |
203 |
107 |
880.9630 |
2024-09-20 00:00:00.0 |
8.9930 |
203 |
108 |
888.2086 |
2024-09-21 00:00:00.0 |
7.2456 |
203 |
109 |
893.2584 |
2024-09-22 00:00:00.0 |
5.0498 |
203 |
110 |
901.4878 |
2024-09-23 00:00:00.0 |
8.2294 |
203 |
111 |
908.8879 |
2024-09-24 00:00:00.0 |
7.4001 |
203 |
112 |
916.5113 |
2024-09-25 00:00:00.0 |
7.6234 |
203 |
113 |
924.3072 |
2024-09-26 00:00:00.0 |
7.7959 |
203 |
114 |
931.5121 |
2024-09-27 00:00:00.0 |
7.2049 |
203 |
115 |
939.1920 |
2024-09-28 00:00:00.0 |
7.6799 |
203 |
116 |
946.1441 |
2024-09-29 00:00:00.0 |
6.9521 |
203 |
117 |
953.5147 |
2024-09-30 00:00:00.0 |
7.3706 |
203 |
118 |
957.0632 |
2024-10-01 00:00:00.0 |
3.5485 |
203 |
119 |
961.7647 |
2024-10-02 00:00:00.0 |
4.7015 |
203 |
120 |
962.9573 |
2024-10-03 00:00:00.0 |
1.1926 |
203 |
121 |
966.0407 |
2024-10-04 00:00:00.0 |
3.0834 |
203 |
122 |
971.5525 |
2024-10-05 00:00:00.0 |
5.5118 |
203 |
123 |
974.0068 |
2024-10-06 00:00:00.0 |
2.4543 |
203 |
124 |
977.1205 |
2024-10-07 00:00:00.0 |
3.1137 |
203 |
125 |
981.6534 |
2024-10-08 00:00:00.0 |
4.5329 |
203 |
126 |
989.0924 |
2024-10-09 00:00:00.0 |
7.4390 |
203 |
127 |
996.7207 |
2024-10-10 00:00:00.0 |
7.6283 |
203 |
128 |
999.5412 |
2024-10-11 00:00:00.0 |
2.8205 |
203 |
129 |
1001.9283 |
2024-10-12 00:00:00.0 |
2.3871 |
203 |
130 |
1002.7283 |
2024-10-13 00:00:00.0 |
0.8000 |
203 |
131 |
1002.8839 |
2024-10-14 00:00:00.0 |
0.1556 |
203 |
132 |
1003.4037 |
2024-10-15 00:00:00.0 |
0.5198 |
203 |
133 |
1007.0715 |
2024-10-16 00:00:00.0 |
3.6678 |
203 |
134 |
1012.5104 |
2024-10-17 00:00:00.0 |
5.4389 |
203 |
135 |
1014.1084 |
2024-10-18 00:00:00.0 |
1.5980 |
203 |
136 |
1015.7624 |
2024-10-19 00:00:00.0 |
1.6540 |
203 |
137 |
1021.3107 |
2024-10-20 00:00:00.0 |
5.5483 |
203 |
138 |
1026.2076 |
2024-10-21 00:00:00.0 |
4.8969 |
203 |
139 |
1029.0827 |
2024-10-22 00:00:00.0 |
2.8751 |
203 |
140 |
1030.8154 |
2024-10-23 00:00:00.0 |
1.7327 |
203 |
141 |
1031.3623 |
2024-10-24 00:00:00.0 |
0.5469 |
203 |
142 |
1031.8123 |
2024-10-25 00:00:00.0 |
0.4500 |
203 |
143 |
1032.3184 |
2024-10-26 00:00:00.0 |
0.5061 |
203 |
144 |
1034.0856 |
2024-10-27 00:00:00.0 |
1.7672 |
203 |
145 |
1037.0313 |
2024-10-28 00:00:00.0 |
2.9457 |
203 |
146 |
1037.5236 |
2024-10-29 00:00:00.0 |
0.4923 |
203 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '203') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'}
ORDER BY ddate ASC |