P-Days Maps have ended for the season and will begin again on June 1st.
query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
9.1423 |
2017-05-15 00:00:00.0 |
9.1423 |
223 |
2 |
15.1913 |
2017-05-16 00:00:00.0 |
6.0490 |
223 |
3 |
17.2194 |
2017-05-17 00:00:00.0 |
2.0281 |
223 |
4 |
17.5031 |
2017-05-18 00:00:00.0 |
0.2837 |
223 |
5 |
21.7704 |
2017-05-19 00:00:00.0 |
4.2673 |
223 |
6 |
26.7699 |
2017-05-20 00:00:00.0 |
4.9995 |
223 |
7 |
27.6087 |
2017-05-21 00:00:00.0 |
0.8388 |
223 |
8 |
30.0148 |
2017-05-22 00:00:00.0 |
2.4061 |
223 |
9 |
37.1449 |
2017-05-23 00:00:00.0 |
7.1301 |
223 |
10 |
45.2464 |
2017-05-24 00:00:00.0 |
8.1015 |
223 |
11 |
53.1566 |
2017-05-25 00:00:00.0 |
7.9102 |
223 |
12 |
61.9811 |
2017-05-26 00:00:00.0 |
8.8245 |
223 |
13 |
70.6015 |
2017-05-27 00:00:00.0 |
8.6204 |
223 |
14 |
75.4995 |
2017-05-28 00:00:00.0 |
4.8980 |
223 |
15 |
77.0092 |
2017-05-29 00:00:00.0 |
1.5097 |
223 |
16 |
82.2087 |
2017-05-30 00:00:00.0 |
5.1995 |
223 |
17 |
90.4327 |
2017-05-31 00:00:00.0 |
8.2240 |
223 |
18 |
98.9204 |
2017-06-01 00:00:00.0 |
8.4877 |
223 |
19 |
107.6562 |
2017-06-02 00:00:00.0 |
8.7358 |
223 |
20 |
117.2994 |
2017-06-03 00:00:00.0 |
9.6432 |
223 |
21 |
127.1520 |
2017-06-04 00:00:00.0 |
9.8526 |
223 |
22 |
137.1508 |
2017-06-05 00:00:00.0 |
9.9988 |
223 |
23 |
146.7508 |
2017-06-06 00:00:00.0 |
9.6000 |
223 |
24 |
156.6360 |
2017-06-07 00:00:00.0 |
9.8852 |
223 |
25 |
166.6176 |
2017-06-08 00:00:00.0 |
9.9816 |
223 |
26 |
176.5176 |
2017-06-09 00:00:00.0 |
9.9000 |
223 |
27 |
186.4176 |
2017-06-10 00:00:00.0 |
9.9000 |
223 |
28 |
196.3763 |
2017-06-11 00:00:00.0 |
9.9587 |
223 |
29 |
205.6396 |
2017-06-12 00:00:00.0 |
9.2633 |
223 |
30 |
214.6962 |
2017-06-13 00:00:00.0 |
9.0566 |
223 |
31 |
224.3773 |
2017-06-14 00:00:00.0 |
9.6811 |
223 |
32 |
232.9441 |
2017-06-15 00:00:00.0 |
8.5668 |
223 |
33 |
241.3441 |
2017-06-16 00:00:00.0 |
8.4000 |
223 |
34 |
248.5502 |
2017-06-17 00:00:00.0 |
7.2061 |
223 |
35 |
255.8313 |
2017-06-18 00:00:00.0 |
7.2811 |
223 |
36 |
263.6757 |
2017-06-19 00:00:00.0 |
7.8444 |
223 |
37 |
272.5961 |
2017-06-20 00:00:00.0 |
8.9204 |
223 |
38 |
281.1083 |
2017-06-21 00:00:00.0 |
8.5122 |
223 |
39 |
289.7813 |
2017-06-22 00:00:00.0 |
8.6730 |
223 |
40 |
296.5971 |
2017-06-23 00:00:00.0 |
6.8158 |
223 |
41 |
301.1843 |
2017-06-24 00:00:00.0 |
4.5872 |
223 |
42 |
306.7715 |
2017-06-25 00:00:00.0 |
5.5872 |
223 |
43 |
315.2281 |
2017-06-26 00:00:00.0 |
8.4566 |
223 |
44 |
324.9342 |
2017-06-27 00:00:00.0 |
9.7061 |
223 |
45 |
334.3444 |
2017-06-28 00:00:00.0 |
9.4102 |
223 |
46 |
343.9153 |
2017-06-29 00:00:00.0 |
9.5709 |
223 |
47 |
352.7883 |
2017-06-30 00:00:00.0 |
8.8730 |
223 |
48 |
361.4613 |
2017-07-01 00:00:00.0 |
8.6730 |
223 |
49 |
370.2858 |
2017-07-02 00:00:00.0 |
8.8245 |
223 |
50 |
380.1710 |
2017-07-03 00:00:00.0 |
9.8852 |
223 |
51 |
389.6266 |
2017-07-04 00:00:00.0 |
9.4556 |
223 |
52 |
399.1809 |
2017-07-05 00:00:00.0 |
9.5543 |
223 |
53 |
409.1611 |
2017-07-06 00:00:00.0 |
9.9802 |
223 |
54 |
418.9769 |
2017-07-07 00:00:00.0 |
9.8158 |
223 |
55 |
428.9749 |
2017-07-08 00:00:00.0 |
9.9980 |
223 |
56 |
438.9729 |
2017-07-09 00:00:00.0 |
9.9980 |
223 |
57 |
448.9683 |
2017-07-10 00:00:00.0 |
9.9954 |
223 |
58 |
458.8030 |
2017-07-11 00:00:00.0 |
9.8347 |
223 |
59 |
467.5275 |
2017-07-12 00:00:00.0 |
8.7245 |
223 |
60 |
476.6698 |
2017-07-13 00:00:00.0 |
9.1423 |
223 |
61 |
486.5392 |
2017-07-14 00:00:00.0 |
9.8694 |
223 |
62 |
496.4979 |
2017-07-15 00:00:00.0 |
9.9587 |
223 |
63 |
506.4117 |
2017-07-16 00:00:00.0 |
9.9138 |
223 |
64 |
515.9660 |
2017-07-17 00:00:00.0 |
9.5543 |
223 |
65 |
525.6961 |
2017-07-18 00:00:00.0 |
9.7301 |
223 |
66 |
535.0349 |
2017-07-19 00:00:00.0 |
9.3388 |
223 |
67 |
544.8507 |
2017-07-20 00:00:00.0 |
9.8158 |
223 |
68 |
554.7772 |
2017-07-21 00:00:00.0 |
9.9265 |
223 |
69 |
564.3772 |
2017-07-22 00:00:00.0 |
9.6000 |
223 |
70 |
574.3155 |
2017-07-23 00:00:00.0 |
9.9383 |
223 |
71 |
584.1920 |
2017-07-24 00:00:00.0 |
9.8765 |
223 |
72 |
594.1871 |
2017-07-25 00:00:00.0 |
9.9951 |
223 |
73 |
604.1871 |
2017-07-26 00:00:00.0 |
10.0000 |
223 |
74 |
614.0377 |
2017-07-27 00:00:00.0 |
9.8506 |
223 |
75 |
623.6377 |
2017-07-28 00:00:00.0 |
9.6000 |
223 |
76 |
631.8550 |
2017-07-29 00:00:00.0 |
8.2173 |
223 |
77 |
640.2550 |
2017-07-30 00:00:00.0 |
8.4000 |
223 |
78 |
648.4723 |
2017-07-31 00:00:00.0 |
8.2173 |
223 |
79 |
658.4213 |
2017-08-01 00:00:00.0 |
9.9490 |
223 |
80 |
667.0943 |
2017-08-02 00:00:00.0 |
8.6730 |
223 |
81 |
676.3958 |
2017-08-03 00:00:00.0 |
9.3015 |
223 |
82 |
685.5381 |
2017-08-04 00:00:00.0 |
9.1423 |
223 |
83 |
694.7621 |
2017-08-05 00:00:00.0 |
9.2240 |
223 |
84 |
704.2718 |
2017-08-06 00:00:00.0 |
9.5097 |
223 |
85 |
714.1718 |
2017-08-07 00:00:00.0 |
9.9000 |
223 |
86 |
723.9876 |
2017-08-08 00:00:00.0 |
9.8158 |
223 |
87 |
733.2891 |
2017-08-09 00:00:00.0 |
9.3015 |
223 |
88 |
742.9952 |
2017-08-10 00:00:00.0 |
9.7061 |
223 |
89 |
752.5360 |
2017-08-11 00:00:00.0 |
9.5408 |
223 |
90 |
762.3110 |
2017-08-12 00:00:00.0 |
9.7750 |
223 |
91 |
772.1962 |
2017-08-13 00:00:00.0 |
9.8852 |
223 |
92 |
782.1635 |
2017-08-14 00:00:00.0 |
9.9673 |
223 |
93 |
792.0900 |
2017-08-15 00:00:00.0 |
9.9265 |
223 |
94 |
801.8431 |
2017-08-16 00:00:00.0 |
9.7531 |
223 |
95 |
811.6181 |
2017-08-17 00:00:00.0 |
9.7750 |
223 |
96 |
821.4875 |
2017-08-18 00:00:00.0 |
9.8694 |
223 |
97 |
831.4566 |
2017-08-19 00:00:00.0 |
9.9691 |
223 |
98 |
841.4484 |
2017-08-20 00:00:00.0 |
9.9918 |
223 |
99 |
849.5499 |
2017-08-21 00:00:00.0 |
8.1015 |
223 |
100 |
857.5249 |
2017-08-22 00:00:00.0 |
7.9750 |
223 |
101 |
862.2167 |
2017-08-23 00:00:00.0 |
4.6918 |
223 |
102 |
868.7019 |
2017-08-24 00:00:00.0 |
6.4852 |
223 |
103 |
878.2116 |
2017-08-25 00:00:00.0 |
9.5097 |
223 |
104 |
887.4356 |
2017-08-26 00:00:00.0 |
9.2240 |
223 |
105 |
897.3943 |
2017-08-27 00:00:00.0 |
9.9587 |
223 |
106 |
907.2449 |
2017-08-28 00:00:00.0 |
9.8506 |
223 |
107 |
916.8881 |
2017-08-29 00:00:00.0 |
9.6432 |
223 |
108 |
925.9881 |
2017-08-30 00:00:00.0 |
9.1000 |
223 |
109 |
935.6432 |
2017-08-31 00:00:00.0 |
9.6551 |
223 |
110 |
945.1208 |
2017-09-01 00:00:00.0 |
9.4776 |
223 |
111 |
954.6917 |
2017-09-02 00:00:00.0 |
9.5709 |
223 |
112 |
964.1693 |
2017-09-03 00:00:00.0 |
9.4776 |
223 |
113 |
971.8790 |
2017-09-04 00:00:00.0 |
7.7097 |
223 |
114 |
978.2790 |
2017-09-05 00:00:00.0 |
6.4000 |
223 |
115 |
983.5770 |
2017-09-06 00:00:00.0 |
5.2980 |
223 |
116 |
992.4015 |
2017-09-07 00:00:00.0 |
8.8245 |
223 |
117 |
999.8296 |
2017-09-08 00:00:00.0 |
7.4281 |
223 |
118 |
1009.2046 |
2017-09-09 00:00:00.0 |
9.3750 |
223 |
119 |
1019.0268 |
2017-09-10 00:00:00.0 |
9.8222 |
223 |
120 |
1028.9941 |
2017-09-11 00:00:00.0 |
9.9673 |
223 |
121 |
1038.2225 |
2017-09-12 00:00:00.0 |
9.2284 |
223 |
122 |
1047.6669 |
2017-09-13 00:00:00.0 |
9.4444 |
223 |
123 |
1054.8730 |
2017-09-14 00:00:00.0 |
7.2061 |
223 |
124 |
1059.0317 |
2017-09-15 00:00:00.0 |
4.1587 |
223 |
125 |
1061.0598 |
2017-09-16 00:00:00.0 |
2.0281 |
223 |
126 |
1064.6598 |
2017-09-17 00:00:00.0 |
3.6000 |
223 |
127 |
1071.7129 |
2017-09-18 00:00:00.0 |
7.0531 |
223 |
128 |
1080.4879 |
2017-09-19 00:00:00.0 |
8.7750 |
223 |
129 |
1089.4547 |
2017-09-20 00:00:00.0 |
8.9668 |
223 |
130 |
1098.8649 |
2017-09-21 00:00:00.0 |
9.4102 |
223 |
131 |
1106.7751 |
2017-09-22 00:00:00.0 |
7.9102 |
223 |
132 |
1112.5501 |
2017-09-23 00:00:00.0 |
5.7750 |
223 |
133 |
1116.7088 |
2017-09-24 00:00:00.0 |
4.1587 |
223 |
134 |
1119.7246 |
2017-09-25 00:00:00.0 |
3.0158 |
223 |
135 |
1122.2547 |
2017-09-26 00:00:00.0 |
2.5301 |
223 |
136 |
1127.1527 |
2017-09-27 00:00:00.0 |
4.8980 |
223 |
137 |
1131.3114 |
2017-09-28 00:00:00.0 |
4.1587 |
223 |
138 |
1133.8415 |
2017-09-29 00:00:00.0 |
2.5301 |
223 |
139 |
1141.2696 |
2017-09-30 00:00:00.0 |
7.4281 |
223 |
140 |
1149.2446 |
2017-10-01 00:00:00.0 |
7.9750 |
223 |
141 |
1156.5257 |
2017-10-02 00:00:00.0 |
7.2811 |
223 |
142 |
1158.2966 |
2017-10-03 00:00:00.0 |
1.7709 |
223 |
143 |
1160.9497 |
2017-10-04 00:00:00.0 |
2.6531 |
223 |
144 |
1160.9497 |
2017-10-05 00:00:00.0 |
0.0000 |
223 |
145 |
1164.7762 |
2017-10-06 00:00:00.0 |
3.8265 |
223 |
146 |
1171.3456 |
2017-10-07 00:00:00.0 |
6.5694 |
223 |
147 |
1174.3614 |
2017-10-08 00:00:00.0 |
3.0158 |
223 |
148 |
1174.3614 |
2017-10-09 00:00:00.0 |
0.0000 |
223 |
149 |
1175.8711 |
2017-10-10 00:00:00.0 |
1.5097 |
223 |
150 |
1179.3563 |
2017-10-11 00:00:00.0 |
3.4852 |
223 |
151 |
1184.3558 |
2017-10-12 00:00:00.0 |
4.9995 |
223 |
152 |
1184.3558 |
2017-10-13 00:00:00.0 |
0.0000 |
223 |
153 |
1184.3558 |
2017-10-14 00:00:00.0 |
0.0000 |
223 |
154 |
1184.3558 |
2017-10-15 00:00:00.0 |
0.0000 |
223 |
155 |
1186.7619 |
2017-10-16 00:00:00.0 |
2.4061 |
223 |
156 |
1193.0757 |
2017-10-17 00:00:00.0 |
6.3138 |
223 |
157 |
1199.9716 |
2017-10-18 00:00:00.0 |
6.8959 |
223 |
158 |
1204.5588 |
2017-10-19 00:00:00.0 |
4.5872 |
223 |
159 |
1213.8976 |
2017-10-20 00:00:00.0 |
9.3388 |
223 |
160 |
1222.8644 |
2017-10-21 00:00:00.0 |
8.9668 |
223 |
161 |
1227.0231 |
2017-10-22 00:00:00.0 |
4.1587 |
223 |
162 |
1227.0231 |
2017-10-23 00:00:00.0 |
0.0000 |
223 |
163 |
1227.0231 |
2017-10-24 00:00:00.0 |
0.0000 |
223 |
164 |
1227.0231 |
2017-10-25 00:00:00.0 |
0.0000 |
223 |
165 |
1227.0231 |
2017-10-26 00:00:00.0 |
0.0000 |
223 |
166 |
1227.0231 |
2017-10-27 00:00:00.0 |
0.0000 |
223 |
167 |
1227.0231 |
2017-10-28 00:00:00.0 |
0.0000 |
223 |
168 |
1227.0231 |
2017-10-29 00:00:00.0 |
0.0000 |
223 |
169 |
1227.0231 |
2017-10-30 00:00:00.0 |
0.0000 |
223 |
170 |
1227.0231 |
2017-10-31 00:00:00.0 |
0.0000 |
223 |
|
CACHED |
false |
EXECUTIONTIME |
2 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '223') AND ddate < '2017-11-01'
ORDER BY ddate ASC |