query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
49.4371 |
2024-06-06 00:00:00.0 |
5.7123 |
223 |
2 |
56.6083 |
2024-06-07 00:00:00.0 |
7.1712 |
223 |
3 |
63.7742 |
2024-06-08 00:00:00.0 |
7.1659 |
223 |
4 |
69.6655 |
2024-06-09 00:00:00.0 |
5.8913 |
223 |
5 |
74.7083 |
2024-06-10 00:00:00.0 |
5.0428 |
223 |
6 |
83.3529 |
2024-06-11 00:00:00.0 |
8.6446 |
223 |
7 |
91.1508 |
2024-06-12 00:00:00.0 |
7.7979 |
223 |
8 |
99.6785 |
2024-06-13 00:00:00.0 |
8.5277 |
223 |
9 |
106.7398 |
2024-06-14 00:00:00.0 |
7.0613 |
223 |
10 |
115.1532 |
2024-06-15 00:00:00.0 |
8.4134 |
223 |
11 |
124.7434 |
2024-06-16 00:00:00.0 |
9.5902 |
223 |
12 |
132.2225 |
2024-06-17 00:00:00.0 |
7.4791 |
223 |
13 |
139.1962 |
2024-06-18 00:00:00.0 |
6.9737 |
223 |
14 |
146.6806 |
2024-06-19 00:00:00.0 |
7.4844 |
223 |
15 |
155.0747 |
2024-06-20 00:00:00.0 |
8.3941 |
223 |
16 |
163.8063 |
2024-06-21 00:00:00.0 |
8.7316 |
223 |
17 |
172.7513 |
2024-06-22 00:00:00.0 |
8.9450 |
223 |
18 |
181.8253 |
2024-06-23 00:00:00.0 |
9.0740 |
223 |
19 |
189.5095 |
2024-06-24 00:00:00.0 |
7.6842 |
223 |
20 |
198.8896 |
2024-06-25 00:00:00.0 |
9.3801 |
223 |
21 |
206.9793 |
2024-06-26 00:00:00.0 |
8.0897 |
223 |
22 |
213.7116 |
2024-06-27 00:00:00.0 |
6.7323 |
223 |
23 |
220.6321 |
2024-06-28 00:00:00.0 |
6.9205 |
223 |
24 |
227.6358 |
2024-06-29 00:00:00.0 |
7.0037 |
223 |
25 |
233.9033 |
2024-06-30 00:00:00.0 |
6.2675 |
223 |
26 |
242.4958 |
2024-07-01 00:00:00.0 |
8.5925 |
223 |
27 |
251.9756 |
2024-07-02 00:00:00.0 |
9.4798 |
223 |
28 |
261.3564 |
2024-07-03 00:00:00.0 |
9.3808 |
223 |
29 |
270.0197 |
2024-07-04 00:00:00.0 |
8.6633 |
223 |
30 |
279.0314 |
2024-07-05 00:00:00.0 |
9.0117 |
223 |
31 |
287.9307 |
2024-07-06 00:00:00.0 |
8.8993 |
223 |
32 |
296.6724 |
2024-07-07 00:00:00.0 |
8.7417 |
223 |
33 |
305.2854 |
2024-07-08 00:00:00.0 |
8.6130 |
223 |
34 |
313.5071 |
2024-07-09 00:00:00.0 |
8.2217 |
223 |
35 |
321.7932 |
2024-07-10 00:00:00.0 |
8.2861 |
223 |
36 |
329.1817 |
2024-07-11 00:00:00.0 |
7.3885 |
223 |
37 |
336.0020 |
2024-07-12 00:00:00.0 |
6.8203 |
223 |
38 |
344.0402 |
2024-07-13 00:00:00.0 |
8.0382 |
223 |
39 |
352.9716 |
2024-07-14 00:00:00.0 |
8.9314 |
223 |
40 |
362.3311 |
2024-07-15 00:00:00.0 |
9.3595 |
223 |
41 |
370.5590 |
2024-07-16 00:00:00.0 |
8.2279 |
223 |
42 |
377.9038 |
2024-07-17 00:00:00.0 |
7.3448 |
223 |
43 |
385.9479 |
2024-07-18 00:00:00.0 |
8.0441 |
223 |
44 |
394.4673 |
2024-07-19 00:00:00.0 |
8.5194 |
223 |
45 |
402.4123 |
2024-07-20 00:00:00.0 |
7.9450 |
223 |
46 |
410.8753 |
2024-07-21 00:00:00.0 |
8.4630 |
223 |
47 |
420.1246 |
2024-07-22 00:00:00.0 |
9.2493 |
223 |
48 |
429.6820 |
2024-07-23 00:00:00.0 |
9.5574 |
223 |
49 |
438.4289 |
2024-07-24 00:00:00.0 |
8.7469 |
223 |
50 |
447.0327 |
2024-07-25 00:00:00.0 |
8.6038 |
223 |
51 |
453.3823 |
2024-07-26 00:00:00.0 |
6.3496 |
223 |
52 |
461.5191 |
2024-07-27 00:00:00.0 |
8.1368 |
223 |
53 |
470.9708 |
2024-07-28 00:00:00.0 |
9.4517 |
223 |
54 |
479.3943 |
2024-07-29 00:00:00.0 |
8.4235 |
223 |
55 |
486.8397 |
2024-07-30 00:00:00.0 |
7.4454 |
223 |
56 |
494.4833 |
2024-07-31 00:00:00.0 |
7.6436 |
223 |
57 |
501.6512 |
2024-08-01 00:00:00.0 |
7.1679 |
223 |
58 |
509.9796 |
2024-08-02 00:00:00.0 |
8.3284 |
223 |
59 |
518.9145 |
2024-08-03 00:00:00.0 |
8.9349 |
223 |
60 |
526.3840 |
2024-08-04 00:00:00.0 |
7.4695 |
223 |
61 |
534.7639 |
2024-08-05 00:00:00.0 |
8.3799 |
223 |
62 |
541.3072 |
2024-08-06 00:00:00.0 |
6.5433 |
223 |
63 |
549.8016 |
2024-08-07 00:00:00.0 |
8.4944 |
223 |
64 |
556.5444 |
2024-08-08 00:00:00.0 |
6.7428 |
223 |
65 |
563.8669 |
2024-08-09 00:00:00.0 |
7.3225 |
223 |
66 |
571.4328 |
2024-08-10 00:00:00.0 |
7.5659 |
223 |
67 |
579.9196 |
2024-08-11 00:00:00.0 |
8.4868 |
223 |
68 |
587.4401 |
2024-08-12 00:00:00.0 |
7.5205 |
223 |
69 |
595.5984 |
2024-08-13 00:00:00.0 |
8.1583 |
223 |
70 |
604.7414 |
2024-08-14 00:00:00.0 |
9.1430 |
223 |
71 |
614.5707 |
2024-08-15 00:00:00.0 |
9.8293 |
223 |
72 |
624.0526 |
2024-08-16 00:00:00.0 |
9.4819 |
223 |
73 |
633.0481 |
2024-08-17 00:00:00.0 |
8.9955 |
223 |
74 |
641.0977 |
2024-08-18 00:00:00.0 |
8.0496 |
223 |
75 |
649.5224 |
2024-08-19 00:00:00.0 |
8.4247 |
223 |
76 |
657.8807 |
2024-08-20 00:00:00.0 |
8.3583 |
223 |
77 |
666.9093 |
2024-08-21 00:00:00.0 |
9.0286 |
223 |
78 |
676.4373 |
2024-08-22 00:00:00.0 |
9.5280 |
223 |
79 |
684.4562 |
2024-08-23 00:00:00.0 |
8.0189 |
223 |
80 |
692.0578 |
2024-08-24 00:00:00.0 |
7.6016 |
223 |
81 |
698.4354 |
2024-08-25 00:00:00.0 |
6.3776 |
223 |
82 |
707.6099 |
2024-08-26 00:00:00.0 |
9.1745 |
223 |
83 |
714.7381 |
2024-08-27 00:00:00.0 |
7.1282 |
223 |
84 |
721.8687 |
2024-08-28 00:00:00.0 |
7.1306 |
223 |
85 |
731.0690 |
2024-08-29 00:00:00.0 |
9.2003 |
223 |
86 |
739.8269 |
2024-08-30 00:00:00.0 |
8.7579 |
223 |
87 |
748.4061 |
2024-08-31 00:00:00.0 |
8.5792 |
223 |
88 |
755.7202 |
2024-09-01 00:00:00.0 |
7.3141 |
223 |
89 |
764.1219 |
2024-09-02 00:00:00.0 |
8.4017 |
223 |
90 |
772.4428 |
2024-09-03 00:00:00.0 |
8.3209 |
223 |
91 |
781.9410 |
2024-09-04 00:00:00.0 |
9.4982 |
223 |
92 |
788.3103 |
2024-09-05 00:00:00.0 |
6.3693 |
223 |
93 |
794.3190 |
2024-09-06 00:00:00.0 |
6.0087 |
223 |
94 |
801.3242 |
2024-09-07 00:00:00.0 |
7.0052 |
223 |
95 |
809.9387 |
2024-09-08 00:00:00.0 |
8.6145 |
223 |
96 |
817.8922 |
2024-09-09 00:00:00.0 |
7.9535 |
223 |
97 |
827.4429 |
2024-09-10 00:00:00.0 |
9.5507 |
223 |
98 |
835.6552 |
2024-09-11 00:00:00.0 |
8.2123 |
223 |
99 |
843.2466 |
2024-09-12 00:00:00.0 |
7.5914 |
223 |
100 |
851.7435 |
2024-09-13 00:00:00.0 |
8.4969 |
223 |
101 |
860.8242 |
2024-09-14 00:00:00.0 |
9.0807 |
223 |
102 |
868.8590 |
2024-09-15 00:00:00.0 |
8.0348 |
223 |
103 |
877.5603 |
2024-09-16 00:00:00.0 |
8.7013 |
223 |
104 |
887.0220 |
2024-09-17 00:00:00.0 |
9.4617 |
223 |
105 |
896.0828 |
2024-09-18 00:00:00.0 |
9.0608 |
223 |
106 |
905.8693 |
2024-09-19 00:00:00.0 |
9.7865 |
223 |
107 |
914.9967 |
2024-09-20 00:00:00.0 |
9.1274 |
223 |
108 |
922.6206 |
2024-09-21 00:00:00.0 |
7.6239 |
223 |
109 |
928.3385 |
2024-09-22 00:00:00.0 |
5.7179 |
223 |
110 |
936.3341 |
2024-09-23 00:00:00.0 |
7.9956 |
223 |
111 |
944.0465 |
2024-09-24 00:00:00.0 |
7.7124 |
223 |
112 |
952.7183 |
2024-09-25 00:00:00.0 |
8.6718 |
223 |
113 |
960.9083 |
2024-09-26 00:00:00.0 |
8.1900 |
223 |
114 |
968.7463 |
2024-09-27 00:00:00.0 |
7.8380 |
223 |
115 |
976.1115 |
2024-09-28 00:00:00.0 |
7.3652 |
223 |
116 |
983.7013 |
2024-09-29 00:00:00.0 |
7.5898 |
223 |
117 |
991.2866 |
2024-09-30 00:00:00.0 |
7.5853 |
223 |
118 |
994.7279 |
2024-10-01 00:00:00.0 |
3.4413 |
223 |
119 |
999.5918 |
2024-10-02 00:00:00.0 |
4.8639 |
223 |
120 |
1000.5994 |
2024-10-03 00:00:00.0 |
1.0076 |
223 |
121 |
1003.4445 |
2024-10-04 00:00:00.0 |
2.8451 |
223 |
122 |
1008.7520 |
2024-10-05 00:00:00.0 |
5.3075 |
223 |
123 |
1011.6525 |
2024-10-06 00:00:00.0 |
2.9005 |
223 |
124 |
1015.3249 |
2024-10-07 00:00:00.0 |
3.6724 |
223 |
125 |
1019.0529 |
2024-10-08 00:00:00.0 |
3.7280 |
223 |
126 |
1026.0093 |
2024-10-09 00:00:00.0 |
6.9564 |
223 |
127 |
1033.7942 |
2024-10-10 00:00:00.0 |
7.7849 |
223 |
128 |
1036.3469 |
2024-10-11 00:00:00.0 |
2.5527 |
223 |
129 |
1038.4627 |
2024-10-12 00:00:00.0 |
2.1158 |
223 |
130 |
1039.4062 |
2024-10-13 00:00:00.0 |
0.9435 |
223 |
131 |
1039.4766 |
2024-10-14 00:00:00.0 |
0.0704 |
223 |
132 |
1040.0368 |
2024-10-15 00:00:00.0 |
0.5602 |
223 |
133 |
1043.8054 |
2024-10-16 00:00:00.0 |
3.7686 |
223 |
134 |
1049.9729 |
2024-10-17 00:00:00.0 |
6.1675 |
223 |
135 |
1051.7626 |
2024-10-18 00:00:00.0 |
1.7897 |
223 |
136 |
1053.5090 |
2024-10-19 00:00:00.0 |
1.7464 |
223 |
137 |
1058.9849 |
2024-10-20 00:00:00.0 |
5.4759 |
223 |
138 |
1064.4552 |
2024-10-21 00:00:00.0 |
5.4703 |
223 |
139 |
1068.0851 |
2024-10-22 00:00:00.0 |
3.6299 |
223 |
140 |
1069.4453 |
2024-10-23 00:00:00.0 |
1.3602 |
223 |
141 |
1069.9922 |
2024-10-24 00:00:00.0 |
0.5469 |
223 |
142 |
1070.3840 |
2024-10-25 00:00:00.0 |
0.3918 |
223 |
143 |
1070.8901 |
2024-10-26 00:00:00.0 |
0.5061 |
223 |
144 |
1072.7139 |
2024-10-27 00:00:00.0 |
1.8238 |
223 |
145 |
1075.5781 |
2024-10-28 00:00:00.0 |
2.8642 |
223 |
146 |
1076.0423 |
2024-10-29 00:00:00.0 |
0.4642 |
223 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '223') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'}
ORDER BY ddate ASC |