query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
47.5386 |
2024-06-06 00:00:00.0 |
7.3736 |
201 |
2 |
54.2196 |
2024-06-07 00:00:00.0 |
6.6810 |
201 |
3 |
60.8650 |
2024-06-08 00:00:00.0 |
6.6454 |
201 |
4 |
64.8055 |
2024-06-09 00:00:00.0 |
3.9405 |
201 |
5 |
70.0476 |
2024-06-10 00:00:00.0 |
5.2421 |
201 |
6 |
78.6215 |
2024-06-11 00:00:00.0 |
8.5739 |
201 |
7 |
86.7713 |
2024-06-12 00:00:00.0 |
8.1498 |
201 |
8 |
94.6014 |
2024-06-13 00:00:00.0 |
7.8301 |
201 |
9 |
102.5682 |
2024-06-14 00:00:00.0 |
7.9668 |
201 |
10 |
110.7712 |
2024-06-15 00:00:00.0 |
8.2030 |
201 |
11 |
119.8047 |
2024-06-16 00:00:00.0 |
9.0335 |
201 |
12 |
125.3808 |
2024-06-17 00:00:00.0 |
5.5761 |
201 |
13 |
130.9647 |
2024-06-18 00:00:00.0 |
5.5839 |
201 |
14 |
136.8298 |
2024-06-19 00:00:00.0 |
5.8651 |
201 |
15 |
145.1221 |
2024-06-20 00:00:00.0 |
8.2923 |
201 |
16 |
153.4385 |
2024-06-21 00:00:00.0 |
8.3164 |
201 |
17 |
162.2021 |
2024-06-22 00:00:00.0 |
8.7636 |
201 |
18 |
170.5660 |
2024-06-23 00:00:00.0 |
8.3639 |
201 |
19 |
179.5463 |
2024-06-24 00:00:00.0 |
8.9803 |
201 |
20 |
188.2877 |
2024-06-25 00:00:00.0 |
8.7414 |
201 |
21 |
195.5267 |
2024-06-26 00:00:00.0 |
7.2390 |
201 |
22 |
202.5309 |
2024-06-27 00:00:00.0 |
7.0042 |
201 |
23 |
208.6043 |
2024-06-28 00:00:00.0 |
6.0734 |
201 |
24 |
213.6981 |
2024-06-29 00:00:00.0 |
5.0938 |
201 |
25 |
219.8436 |
2024-06-30 00:00:00.0 |
6.1455 |
201 |
26 |
228.5724 |
2024-07-01 00:00:00.0 |
8.7288 |
201 |
27 |
237.6541 |
2024-07-02 00:00:00.0 |
9.0817 |
201 |
28 |
246.3390 |
2024-07-03 00:00:00.0 |
8.6849 |
201 |
29 |
254.7257 |
2024-07-04 00:00:00.0 |
8.3867 |
201 |
30 |
262.9195 |
2024-07-05 00:00:00.0 |
8.1938 |
201 |
31 |
271.7427 |
2024-07-06 00:00:00.0 |
8.8232 |
201 |
32 |
280.4821 |
2024-07-07 00:00:00.0 |
8.7394 |
201 |
33 |
289.2750 |
2024-07-08 00:00:00.0 |
8.7929 |
201 |
34 |
297.7735 |
2024-07-09 00:00:00.0 |
8.4985 |
201 |
35 |
306.0875 |
2024-07-10 00:00:00.0 |
8.3140 |
201 |
36 |
314.3821 |
2024-07-11 00:00:00.0 |
8.2946 |
201 |
37 |
321.6987 |
2024-07-12 00:00:00.0 |
7.3166 |
201 |
38 |
330.5858 |
2024-07-13 00:00:00.0 |
8.8871 |
201 |
39 |
339.1100 |
2024-07-14 00:00:00.0 |
8.5242 |
201 |
40 |
347.5949 |
2024-07-15 00:00:00.0 |
8.4849 |
201 |
41 |
355.2845 |
2024-07-16 00:00:00.0 |
7.6896 |
201 |
42 |
361.8094 |
2024-07-17 00:00:00.0 |
6.5249 |
201 |
43 |
369.9254 |
2024-07-18 00:00:00.0 |
8.1160 |
201 |
44 |
378.1812 |
2024-07-19 00:00:00.0 |
8.2558 |
201 |
45 |
386.8960 |
2024-07-20 00:00:00.0 |
8.7148 |
201 |
46 |
395.6205 |
2024-07-21 00:00:00.0 |
8.7245 |
201 |
47 |
405.0104 |
2024-07-22 00:00:00.0 |
9.3899 |
201 |
48 |
414.3457 |
2024-07-23 00:00:00.0 |
9.3353 |
201 |
49 |
423.2953 |
2024-07-24 00:00:00.0 |
8.9496 |
201 |
50 |
431.6361 |
2024-07-25 00:00:00.0 |
8.3408 |
201 |
51 |
440.9235 |
2024-07-26 00:00:00.0 |
9.2874 |
201 |
52 |
448.9291 |
2024-07-27 00:00:00.0 |
8.0056 |
201 |
53 |
457.3624 |
2024-07-28 00:00:00.0 |
8.4333 |
201 |
54 |
466.0039 |
2024-07-29 00:00:00.0 |
8.6415 |
201 |
55 |
474.0541 |
2024-07-30 00:00:00.0 |
8.0502 |
201 |
56 |
482.8922 |
2024-07-31 00:00:00.0 |
8.8381 |
201 |
57 |
490.2193 |
2024-08-01 00:00:00.0 |
7.3271 |
201 |
58 |
498.0858 |
2024-08-02 00:00:00.0 |
7.8665 |
201 |
59 |
506.0061 |
2024-08-03 00:00:00.0 |
7.9203 |
201 |
60 |
511.2548 |
2024-08-04 00:00:00.0 |
5.2487 |
201 |
61 |
518.6180 |
2024-08-05 00:00:00.0 |
7.3632 |
201 |
62 |
525.8501 |
2024-08-06 00:00:00.0 |
7.2321 |
201 |
63 |
532.4814 |
2024-08-07 00:00:00.0 |
6.6313 |
201 |
64 |
538.3859 |
2024-08-08 00:00:00.0 |
5.9045 |
201 |
65 |
545.0218 |
2024-08-09 00:00:00.0 |
6.6359 |
201 |
66 |
551.6815 |
2024-08-10 00:00:00.0 |
6.6597 |
201 |
67 |
558.7999 |
2024-08-11 00:00:00.0 |
7.1184 |
201 |
68 |
566.0280 |
2024-08-12 00:00:00.0 |
7.2281 |
201 |
69 |
574.6880 |
2024-08-13 00:00:00.0 |
8.6600 |
201 |
70 |
584.4015 |
2024-08-14 00:00:00.0 |
9.7135 |
201 |
71 |
593.8905 |
2024-08-15 00:00:00.0 |
9.4890 |
201 |
72 |
603.0239 |
2024-08-16 00:00:00.0 |
9.1334 |
201 |
73 |
611.3508 |
2024-08-17 00:00:00.0 |
8.3269 |
201 |
74 |
619.7817 |
2024-08-18 00:00:00.0 |
8.4309 |
201 |
75 |
627.9668 |
2024-08-19 00:00:00.0 |
8.1851 |
201 |
76 |
636.2668 |
2024-08-20 00:00:00.0 |
8.3000 |
201 |
77 |
645.1483 |
2024-08-21 00:00:00.0 |
8.8815 |
201 |
78 |
654.3634 |
2024-08-22 00:00:00.0 |
9.2151 |
201 |
79 |
663.6321 |
2024-08-23 00:00:00.0 |
9.2687 |
201 |
80 |
671.6537 |
2024-08-24 00:00:00.0 |
8.0216 |
201 |
81 |
679.8437 |
2024-08-25 00:00:00.0 |
8.1900 |
201 |
82 |
686.9222 |
2024-08-26 00:00:00.0 |
7.0785 |
201 |
83 |
692.5657 |
2024-08-27 00:00:00.0 |
5.6435 |
201 |
84 |
699.0201 |
2024-08-28 00:00:00.0 |
6.4544 |
201 |
85 |
707.5352 |
2024-08-29 00:00:00.0 |
8.5151 |
201 |
86 |
716.0339 |
2024-08-30 00:00:00.0 |
8.4987 |
201 |
87 |
723.9484 |
2024-08-31 00:00:00.0 |
7.9145 |
201 |
88 |
730.4348 |
2024-09-01 00:00:00.0 |
6.4864 |
201 |
89 |
738.1655 |
2024-09-02 00:00:00.0 |
7.7307 |
201 |
90 |
745.5754 |
2024-09-03 00:00:00.0 |
7.4099 |
201 |
91 |
754.1970 |
2024-09-04 00:00:00.0 |
8.6216 |
201 |
92 |
760.2942 |
2024-09-05 00:00:00.0 |
6.0972 |
201 |
93 |
765.4244 |
2024-09-06 00:00:00.0 |
5.1302 |
201 |
94 |
771.8056 |
2024-09-07 00:00:00.0 |
6.3812 |
201 |
95 |
778.3330 |
2024-09-08 00:00:00.0 |
6.5274 |
201 |
96 |
785.8307 |
2024-09-09 00:00:00.0 |
7.4977 |
201 |
97 |
793.9613 |
2024-09-10 00:00:00.0 |
8.1306 |
201 |
98 |
799.3237 |
2024-09-11 00:00:00.0 |
5.3624 |
201 |
99 |
807.1809 |
2024-09-12 00:00:00.0 |
7.8572 |
201 |
100 |
816.7212 |
2024-09-13 00:00:00.0 |
9.5403 |
201 |
101 |
825.0360 |
2024-09-14 00:00:00.0 |
8.3148 |
201 |
102 |
833.1985 |
2024-09-15 00:00:00.0 |
8.1625 |
201 |
103 |
841.7342 |
2024-09-16 00:00:00.0 |
8.5357 |
201 |
104 |
851.0212 |
2024-09-17 00:00:00.0 |
9.2870 |
201 |
105 |
860.2428 |
2024-09-18 00:00:00.0 |
9.2216 |
201 |
106 |
869.3807 |
2024-09-19 00:00:00.0 |
9.1379 |
201 |
107 |
877.1892 |
2024-09-20 00:00:00.0 |
7.8085 |
201 |
108 |
882.6451 |
2024-09-21 00:00:00.0 |
5.4559 |
201 |
109 |
886.8684 |
2024-09-22 00:00:00.0 |
4.2233 |
201 |
110 |
894.5724 |
2024-09-23 00:00:00.0 |
7.7040 |
201 |
111 |
902.3453 |
2024-09-24 00:00:00.0 |
7.7729 |
201 |
112 |
910.1792 |
2024-09-25 00:00:00.0 |
7.8339 |
201 |
113 |
917.4184 |
2024-09-26 00:00:00.0 |
7.2392 |
201 |
114 |
924.0165 |
2024-09-27 00:00:00.0 |
6.5981 |
201 |
115 |
931.1896 |
2024-09-28 00:00:00.0 |
7.1731 |
201 |
116 |
938.1722 |
2024-09-29 00:00:00.0 |
6.9826 |
201 |
117 |
945.4952 |
2024-09-30 00:00:00.0 |
7.3230 |
201 |
118 |
948.5577 |
2024-10-01 00:00:00.0 |
3.0625 |
201 |
119 |
952.3724 |
2024-10-02 00:00:00.0 |
3.8147 |
201 |
120 |
953.2491 |
2024-10-03 00:00:00.0 |
0.8767 |
201 |
121 |
956.5637 |
2024-10-04 00:00:00.0 |
3.3146 |
201 |
122 |
960.9124 |
2024-10-05 00:00:00.0 |
4.3487 |
201 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '201') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-05'}
ORDER BY ddate ASC |