query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
40.9508 |
2024-06-06 00:00:00.0 |
5.4541 |
548 |
2 |
46.6369 |
2024-06-07 00:00:00.0 |
5.6861 |
548 |
3 |
51.8814 |
2024-06-08 00:00:00.0 |
5.2445 |
548 |
4 |
55.7394 |
2024-06-09 00:00:00.0 |
3.8580 |
548 |
5 |
60.7617 |
2024-06-10 00:00:00.0 |
5.0223 |
548 |
6 |
69.1854 |
2024-06-11 00:00:00.0 |
8.4237 |
548 |
7 |
76.5269 |
2024-06-12 00:00:00.0 |
7.3415 |
548 |
8 |
83.0943 |
2024-06-13 00:00:00.0 |
6.5674 |
548 |
9 |
90.5752 |
2024-06-14 00:00:00.0 |
7.4809 |
548 |
10 |
99.3814 |
2024-06-15 00:00:00.0 |
8.8062 |
548 |
11 |
107.2925 |
2024-06-16 00:00:00.0 |
7.9111 |
548 |
12 |
112.1241 |
2024-06-17 00:00:00.0 |
4.8316 |
548 |
13 |
117.9385 |
2024-06-18 00:00:00.0 |
5.8144 |
548 |
14 |
122.6344 |
2024-06-19 00:00:00.0 |
4.6959 |
548 |
15 |
130.0066 |
2024-06-20 00:00:00.0 |
7.3722 |
548 |
16 |
138.6995 |
2024-06-21 00:00:00.0 |
8.6929 |
548 |
17 |
147.3616 |
2024-06-22 00:00:00.0 |
8.6621 |
548 |
18 |
154.9387 |
2024-06-23 00:00:00.0 |
7.5771 |
548 |
19 |
163.8566 |
2024-06-24 00:00:00.0 |
8.9179 |
548 |
20 |
172.0222 |
2024-06-25 00:00:00.0 |
8.1656 |
548 |
21 |
178.6060 |
2024-06-26 00:00:00.0 |
6.5838 |
548 |
22 |
185.1898 |
2024-06-27 00:00:00.0 |
6.5838 |
548 |
23 |
190.8471 |
2024-06-28 00:00:00.0 |
5.6573 |
548 |
24 |
195.9058 |
2024-06-29 00:00:00.0 |
5.0587 |
548 |
25 |
201.2438 |
2024-06-30 00:00:00.0 |
5.3380 |
548 |
26 |
210.6037 |
2024-07-01 00:00:00.0 |
9.3599 |
548 |
27 |
219.5910 |
2024-07-02 00:00:00.0 |
8.9873 |
548 |
28 |
227.7250 |
2024-07-03 00:00:00.0 |
8.1340 |
548 |
29 |
236.1462 |
2024-07-04 00:00:00.0 |
8.4212 |
548 |
30 |
244.1213 |
2024-07-05 00:00:00.0 |
7.9751 |
548 |
31 |
252.2514 |
2024-07-06 00:00:00.0 |
8.1301 |
548 |
32 |
260.7624 |
2024-07-07 00:00:00.0 |
8.5110 |
548 |
33 |
269.2687 |
2024-07-08 00:00:00.0 |
8.5063 |
548 |
34 |
277.3578 |
2024-07-09 00:00:00.0 |
8.0891 |
548 |
35 |
285.6862 |
2024-07-10 00:00:00.0 |
8.3284 |
548 |
36 |
293.2754 |
2024-07-11 00:00:00.0 |
7.5892 |
548 |
37 |
301.1787 |
2024-07-12 00:00:00.0 |
7.9033 |
548 |
38 |
309.9865 |
2024-07-13 00:00:00.0 |
8.8078 |
548 |
39 |
317.8703 |
2024-07-14 00:00:00.0 |
7.8838 |
548 |
40 |
326.4393 |
2024-07-15 00:00:00.0 |
8.5690 |
548 |
41 |
334.1142 |
2024-07-16 00:00:00.0 |
7.6749 |
548 |
42 |
340.0464 |
2024-07-17 00:00:00.0 |
5.9322 |
548 |
43 |
346.6181 |
2024-07-18 00:00:00.0 |
6.5717 |
548 |
44 |
354.4681 |
2024-07-19 00:00:00.0 |
7.8500 |
548 |
45 |
362.4728 |
2024-07-20 00:00:00.0 |
8.0047 |
548 |
46 |
371.0811 |
2024-07-21 00:00:00.0 |
8.6083 |
548 |
47 |
379.9754 |
2024-07-22 00:00:00.0 |
8.8943 |
548 |
48 |
389.3932 |
2024-07-23 00:00:00.0 |
9.4178 |
548 |
49 |
398.6425 |
2024-07-24 00:00:00.0 |
9.2493 |
548 |
50 |
406.5087 |
2024-07-25 00:00:00.0 |
7.8662 |
548 |
51 |
415.2978 |
2024-07-26 00:00:00.0 |
8.7891 |
548 |
52 |
422.6236 |
2024-07-27 00:00:00.0 |
7.3258 |
548 |
53 |
431.1960 |
2024-07-28 00:00:00.0 |
8.5724 |
548 |
54 |
439.4302 |
2024-07-29 00:00:00.0 |
8.2342 |
548 |
55 |
446.2738 |
2024-07-30 00:00:00.0 |
6.8436 |
548 |
56 |
454.4887 |
2024-07-31 00:00:00.0 |
8.2149 |
548 |
57 |
461.6117 |
2024-08-01 00:00:00.0 |
7.1230 |
548 |
58 |
469.3674 |
2024-08-02 00:00:00.0 |
7.7557 |
548 |
59 |
477.9849 |
2024-08-03 00:00:00.0 |
8.6175 |
548 |
60 |
485.1193 |
2024-08-04 00:00:00.0 |
7.1344 |
548 |
61 |
493.0905 |
2024-08-05 00:00:00.0 |
7.9712 |
548 |
62 |
499.4773 |
2024-08-06 00:00:00.0 |
6.3868 |
548 |
63 |
505.8491 |
2024-08-07 00:00:00.0 |
6.3718 |
548 |
64 |
511.7769 |
2024-08-08 00:00:00.0 |
5.9278 |
548 |
65 |
518.9552 |
2024-08-09 00:00:00.0 |
7.1783 |
548 |
66 |
524.9966 |
2024-08-10 00:00:00.0 |
6.0414 |
548 |
67 |
531.3598 |
2024-08-11 00:00:00.0 |
6.3632 |
548 |
68 |
537.6774 |
2024-08-12 00:00:00.0 |
6.3176 |
548 |
69 |
546.2733 |
2024-08-13 00:00:00.0 |
8.5959 |
548 |
70 |
555.6734 |
2024-08-14 00:00:00.0 |
9.4001 |
548 |
71 |
564.8790 |
2024-08-15 00:00:00.0 |
9.2056 |
548 |
72 |
573.8087 |
2024-08-16 00:00:00.0 |
8.9297 |
548 |
73 |
581.5381 |
2024-08-17 00:00:00.0 |
7.7294 |
548 |
74 |
589.9272 |
2024-08-18 00:00:00.0 |
8.3891 |
548 |
75 |
598.3743 |
2024-08-19 00:00:00.0 |
8.4471 |
548 |
76 |
606.8544 |
2024-08-20 00:00:00.0 |
8.4801 |
548 |
77 |
614.6148 |
2024-08-21 00:00:00.0 |
7.7604 |
548 |
78 |
623.4441 |
2024-08-22 00:00:00.0 |
8.8293 |
548 |
79 |
631.7576 |
2024-08-23 00:00:00.0 |
8.3135 |
548 |
80 |
640.0350 |
2024-08-24 00:00:00.0 |
8.2774 |
548 |
81 |
648.9921 |
2024-08-25 00:00:00.0 |
8.9571 |
548 |
82 |
655.9703 |
2024-08-26 00:00:00.0 |
6.9782 |
548 |
83 |
663.6621 |
2024-08-27 00:00:00.0 |
7.6918 |
548 |
84 |
670.6496 |
2024-08-28 00:00:00.0 |
6.9875 |
548 |
85 |
677.8732 |
2024-08-29 00:00:00.0 |
7.2236 |
548 |
86 |
685.4779 |
2024-08-30 00:00:00.0 |
7.6047 |
548 |
87 |
691.7454 |
2024-08-31 00:00:00.0 |
6.2675 |
548 |
88 |
697.7302 |
2024-09-01 00:00:00.0 |
5.9848 |
548 |
89 |
704.9245 |
2024-09-02 00:00:00.0 |
7.1943 |
548 |
90 |
712.7053 |
2024-09-03 00:00:00.0 |
7.7808 |
548 |
91 |
720.2622 |
2024-09-04 00:00:00.0 |
7.5569 |
548 |
92 |
726.5519 |
2024-09-05 00:00:00.0 |
6.2897 |
548 |
93 |
732.0478 |
2024-09-06 00:00:00.0 |
5.4959 |
548 |
94 |
737.8051 |
2024-09-07 00:00:00.0 |
5.7573 |
548 |
95 |
743.4811 |
2024-09-08 00:00:00.0 |
5.6760 |
548 |
96 |
749.2826 |
2024-09-09 00:00:00.0 |
5.8015 |
548 |
97 |
757.0075 |
2024-09-10 00:00:00.0 |
7.7249 |
548 |
98 |
763.5859 |
2024-09-11 00:00:00.0 |
6.5784 |
548 |
99 |
772.0955 |
2024-09-12 00:00:00.0 |
8.5096 |
548 |
100 |
781.3445 |
2024-09-13 00:00:00.0 |
9.2490 |
548 |
101 |
788.9483 |
2024-09-14 00:00:00.0 |
7.6038 |
548 |
102 |
796.1537 |
2024-09-15 00:00:00.0 |
7.2054 |
548 |
103 |
803.7293 |
2024-09-16 00:00:00.0 |
7.5756 |
548 |
104 |
812.4821 |
2024-09-17 00:00:00.0 |
8.7528 |
548 |
105 |
821.8379 |
2024-09-18 00:00:00.0 |
9.3558 |
548 |
106 |
829.8957 |
2024-09-19 00:00:00.0 |
8.0578 |
548 |
107 |
836.1092 |
2024-09-20 00:00:00.0 |
6.2135 |
548 |
108 |
840.1655 |
2024-09-21 00:00:00.0 |
4.0563 |
548 |
109 |
844.5928 |
2024-09-22 00:00:00.0 |
4.4273 |
548 |
110 |
851.2816 |
2024-09-23 00:00:00.0 |
6.6888 |
548 |
111 |
857.9988 |
2024-09-24 00:00:00.0 |
6.7172 |
548 |
112 |
863.8292 |
2024-09-25 00:00:00.0 |
5.8304 |
548 |
113 |
871.7317 |
2024-09-26 00:00:00.0 |
7.9025 |
548 |
114 |
876.6634 |
2024-09-27 00:00:00.0 |
4.9317 |
548 |
115 |
883.1524 |
2024-09-28 00:00:00.0 |
6.4890 |
548 |
116 |
889.8249 |
2024-09-29 00:00:00.0 |
6.6725 |
548 |
117 |
895.5461 |
2024-09-30 00:00:00.0 |
5.7212 |
548 |
118 |
898.6844 |
2024-10-01 00:00:00.0 |
3.1383 |
548 |
119 |
900.9892 |
2024-10-02 00:00:00.0 |
2.3048 |
548 |
120 |
901.6915 |
2024-10-03 00:00:00.0 |
0.7023 |
548 |
121 |
904.7323 |
2024-10-04 00:00:00.0 |
3.0408 |
548 |
122 |
907.6072 |
2024-10-05 00:00:00.0 |
2.8749 |
548 |
123 |
910.6170 |
2024-10-06 00:00:00.0 |
3.0098 |
548 |
124 |
914.2251 |
2024-10-07 00:00:00.0 |
3.6081 |
548 |
125 |
920.0070 |
2024-10-08 00:00:00.0 |
5.7819 |
548 |
126 |
925.8411 |
2024-10-09 00:00:00.0 |
5.8341 |
548 |
127 |
929.9705 |
2024-10-10 00:00:00.0 |
4.1294 |
548 |
128 |
932.3874 |
2024-10-11 00:00:00.0 |
2.4169 |
548 |
129 |
934.8545 |
2024-10-12 00:00:00.0 |
2.4671 |
548 |
130 |
935.4668 |
2024-10-13 00:00:00.0 |
0.6123 |
548 |
131 |
935.7362 |
2024-10-14 00:00:00.0 |
0.2694 |
548 |
132 |
936.4464 |
2024-10-15 00:00:00.0 |
0.7102 |
548 |
133 |
940.0264 |
2024-10-16 00:00:00.0 |
3.5800 |
548 |
134 |
943.3443 |
2024-10-17 00:00:00.0 |
3.3179 |
548 |
135 |
944.0427 |
2024-10-18 00:00:00.0 |
0.6984 |
548 |
136 |
946.3215 |
2024-10-19 00:00:00.0 |
2.2788 |
548 |
137 |
950.9545 |
2024-10-20 00:00:00.0 |
4.6330 |
548 |
138 |
955.9711 |
2024-10-21 00:00:00.0 |
5.0166 |
548 |
139 |
956.4772 |
2024-10-22 00:00:00.0 |
0.5061 |
548 |
140 |
958.1412 |
2024-10-23 00:00:00.0 |
1.6640 |
548 |
141 |
958.7277 |
2024-10-24 00:00:00.0 |
0.5865 |
548 |
142 |
959.1777 |
2024-10-25 00:00:00.0 |
0.4500 |
548 |
143 |
959.7900 |
2024-10-26 00:00:00.0 |
0.6123 |
548 |
144 |
960.3634 |
2024-10-27 00:00:00.0 |
0.5734 |
548 |
145 |
962.6663 |
2024-10-28 00:00:00.0 |
2.3029 |
548 |
146 |
963.1020 |
2024-10-29 00:00:00.0 |
0.4357 |
548 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '548') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'}
ORDER BY ddate ASC |