Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Oakland Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler Kane Brunkild Austin Bagot Elie Kenton Neepawa St. Claude


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 8.3423 2017-05-15 00:00:00.0 8.3423 475
2 14.9117 2017-05-16 00:00:00.0 6.5694 475
3 14.9117 2017-05-17 00:00:00.0 0.0000 475
4 14.9117 2017-05-18 00:00:00.0 0.0000 475
5 17.3178 2017-05-19 00:00:00.0 2.4061 475
6 22.3173 2017-05-20 00:00:00.0 4.9995 475
7 24.2173 2017-05-21 00:00:00.0 1.9000 475
8 28.6989 2017-05-22 00:00:00.0 4.4816 475
9 35.6739 2017-05-23 00:00:00.0 6.9750 475
10 43.3147 2017-05-24 00:00:00.0 7.6408 475
11 50.1305 2017-05-25 00:00:00.0 6.8158 475
12 55.9978 2017-05-26 00:00:00.0 5.8673 475
13 62.6504 2017-05-27 00:00:00.0 6.6526 475
14 68.1422 2017-05-28 00:00:00.0 5.4918 475
15 71.1580 2017-05-29 00:00:00.0 3.0158 475
16 76.4560 2017-05-30 00:00:00.0 5.2980 475
17 84.9682 2017-05-31 00:00:00.0 8.5122 475
18 94.8820 2017-06-01 00:00:00.0 9.9138 475
19 104.5252 2017-06-02 00:00:00.0 9.6432 475
20 114.4742 2017-06-03 00:00:00.0 9.9490 475
21 124.2701 2017-06-04 00:00:00.0 9.7959 475
22 134.2655 2017-06-05 00:00:00.0 9.9954 475
23 144.0614 2017-06-06 00:00:00.0 9.7959 475
24 152.8364 2017-06-07 00:00:00.0 8.7750 475
25 162.6711 2017-06-08 00:00:00.0 9.8347 475
26 171.9726 2017-06-09 00:00:00.0 9.3015 475
27 181.4170 2017-06-10 00:00:00.0 9.4444 475
28 190.7920 2017-06-11 00:00:00.0 9.3750 475
29 199.4650 2017-06-12 00:00:00.0 8.6730 475
30 208.1380 2017-06-13 00:00:00.0 8.6730 475
31 216.4217 2017-06-14 00:00:00.0 8.2837 475
32 224.5850 2017-06-15 00:00:00.0 8.1633 475
33 232.9273 2017-06-16 00:00:00.0 8.3423 475
34 240.4273 2017-06-17 00:00:00.0 7.5000 475
35 247.6334 2017-06-18 00:00:00.0 7.2061 475
36 255.2742 2017-06-19 00:00:00.0 7.6408 475
37 263.1844 2017-06-20 00:00:00.0 7.9102 475
38 272.2410 2017-06-21 00:00:00.0 9.0566 475
39 279.9507 2017-06-22 00:00:00.0 7.7097 475
40 286.0890 2017-06-23 00:00:00.0 6.1383 475
41 289.4584 2017-06-24 00:00:00.0 3.3694 475
42 294.4579 2017-06-25 00:00:00.0 4.9995 475
43 301.6640 2017-06-26 00:00:00.0 7.2061 475
44 311.4798 2017-06-27 00:00:00.0 9.8158 475
45 321.4063 2017-06-28 00:00:00.0 9.9265 475
46 330.5486 2017-06-29 00:00:00.0 9.1423 475
47 338.7726 2017-06-30 00:00:00.0 8.2240 475
48 347.3394 2017-07-01 00:00:00.0 8.5668 475
49 355.5027 2017-07-02 00:00:00.0 8.1633 475
50 365.4843 2017-07-03 00:00:00.0 9.9816 475
51 374.7127 2017-07-04 00:00:00.0 9.2284 475
52 384.6818 2017-07-05 00:00:00.0 9.9691 475
53 394.6201 2017-07-06 00:00:00.0 9.9383 475
54 404.1298 2017-07-07 00:00:00.0 9.5097 475
55 414.1170 2017-07-08 00:00:00.0 9.9872 475
56 424.1150 2017-07-09 00:00:00.0 9.9980 475
57 434.1150 2017-07-10 00:00:00.0 10.0000 475
58 444.1022 2017-07-11 00:00:00.0 9.9872 475
59 452.1410 2017-07-12 00:00:00.0 8.0388 475
60 460.7078 2017-07-13 00:00:00.0 8.5668 475
61 470.6828 2017-07-14 00:00:00.0 9.9750 475
62 480.5354 2017-07-15 00:00:00.0 9.8526 475
63 490.2415 2017-07-16 00:00:00.0 9.7061 475
64 500.1415 2017-07-17 00:00:00.0 9.9000 475
65 509.2415 2017-07-18 00:00:00.0 9.1000 475
66 518.3838 2017-07-19 00:00:00.0 9.1423 475
67 528.1369 2017-07-20 00:00:00.0 9.7531 475
68 538.1119 2017-07-21 00:00:00.0 9.9750 475
69 547.4869 2017-07-22 00:00:00.0 9.3750 475
70 557.2828 2017-07-23 00:00:00.0 9.7959 475
71 567.1593 2017-07-24 00:00:00.0 9.8765 475
72 577.0445 2017-07-25 00:00:00.0 9.8852 475
73 587.0032 2017-07-26 00:00:00.0 9.9587 475
74 596.9848 2017-07-27 00:00:00.0 9.9816 475
75 606.8354 2017-07-28 00:00:00.0 9.8506 475
76 616.8342 2017-07-29 00:00:00.0 9.9988 475
77 626.2898 2017-07-30 00:00:00.0 9.4556 475
78 635.2515 2017-07-31 00:00:00.0 8.9617 475
79 645.0046 2017-08-01 00:00:00.0 9.7531 475
80 651.7393 2017-08-02 00:00:00.0 6.7347 475
81 660.7061 2017-08-03 00:00:00.0 8.9668 475
82 669.7183 2017-08-04 00:00:00.0 9.0122 475
83 678.4428 2017-08-05 00:00:00.0 8.7245 475
84 687.1673 2017-08-06 00:00:00.0 8.7245 475
85 696.8224 2017-08-07 00:00:00.0 9.6551 475
86 706.4224 2017-08-08 00:00:00.0 9.6000 475
87 714.7061 2017-08-09 00:00:00.0 8.2837 475
88 723.9694 2017-08-10 00:00:00.0 9.2633 475
89 732.8898 2017-08-11 00:00:00.0 8.9204 475
90 741.8566 2017-08-12 00:00:00.0 8.9668 475
91 751.0403 2017-08-13 00:00:00.0 9.1837 475
92 760.5179 2017-08-14 00:00:00.0 9.4776 475
93 769.4847 2017-08-15 00:00:00.0 8.9668 475
94 779.0847 2017-08-16 00:00:00.0 9.6000 475
95 788.5623 2017-08-17 00:00:00.0 9.4776 475
96 798.4317 2017-08-18 00:00:00.0 9.8694 475
97 808.3712 2017-08-19 00:00:00.0 9.9395 475
98 817.8156 2017-08-20 00:00:00.0 9.4444 475
99 825.9789 2017-08-21 00:00:00.0 8.1633 475
100 834.5993 2017-08-22 00:00:00.0 8.6204 475
101 842.0274 2017-08-23 00:00:00.0 7.4281 475
102 850.2514 2017-08-24 00:00:00.0 8.2240 475
103 859.8514 2017-08-25 00:00:00.0 9.6000 475
104 869.4514 2017-08-26 00:00:00.0 9.6000 475
105 879.4330 2017-08-27 00:00:00.0 9.9816 475
106 889.1910 2017-08-28 00:00:00.0 9.7580 475
107 898.5379 2017-08-29 00:00:00.0 9.3469 475
108 908.4231 2017-08-30 00:00:00.0 9.8852 475
109 918.3369 2017-08-31 00:00:00.0 9.9138 475
110 928.3287 2017-09-01 00:00:00.0 9.9918 475
111 938.2287 2017-09-02 00:00:00.0 9.9000 475
112 948.2103 2017-09-03 00:00:00.0 9.9816 475
113 957.0833 2017-09-04 00:00:00.0 8.8730 475
114 964.9277 2017-09-05 00:00:00.0 7.8444 475
115 973.1517 2017-09-06 00:00:00.0 8.2240 475
116 982.8068 2017-09-07 00:00:00.0 9.6551 475
117 990.6512 2017-09-08 00:00:00.0 7.8444 475
118 999.9900 2017-09-09 00:00:00.0 9.3388 475
119 1009.7122 2017-09-10 00:00:00.0 9.7222 475
120 1019.7076 2017-09-11 00:00:00.0 9.9954 475
121 1028.1076 2017-09-12 00:00:00.0 8.4000 475
122 1037.6484 2017-09-13 00:00:00.0 9.5408 475
123 1045.3581 2017-09-14 00:00:00.0 7.7097 475
124 1049.2964 2017-09-15 00:00:00.0 3.9383 475
125 1050.9372 2017-09-16 00:00:00.0 1.6408 475
126 1054.7637 2017-09-17 00:00:00.0 3.8265 475
127 1060.9020 2017-09-18 00:00:00.0 6.1383 475
128 1069.4688 2017-09-19 00:00:00.0 8.5668 475
129 1078.0892 2017-09-20 00:00:00.0 8.6204 475
130 1086.1907 2017-09-21 00:00:00.0 8.1015 475
131 1092.8433 2017-09-22 00:00:00.0 6.6526 475
132 1098.1413 2017-09-23 00:00:00.0 5.2980 475
133 1101.6265 2017-09-24 00:00:00.0 3.4852 475
134 1105.5648 2017-09-25 00:00:00.0 3.9383 475
135 7.1556 2018-05-15 00:00:00.0 7.1556 475
136 7.4281 2018-05-16 00:00:00.0 7.4281 475
137 3.7138 2018-05-17 00:00:00.0 3.7138 475
138 2.2811 2018-05-18 00:00:00.0 2.2811 475
139 5.1995 2018-05-19 00:00:00.0 5.1995 475
140 9.6000 2018-05-20 00:00:00.0 9.6000 475
141 9.9265 2018-05-21 00:00:00.0 9.9265 475
142 9.7580 2018-05-22 00:00:00.0 9.7580 475
143 9.1654 2018-05-23 00:00:00.0 9.1654 475
144 9.9995 2018-05-24 00:00:00.0 9.9995 475
145 9.9980 2018-05-25 00:00:00.0 9.9980 475
146 9.5709 2018-05-26 00:00:00.0 9.5709 475
147 9.9954 2018-05-27 00:00:00.0 9.9954 475
148 9.9889 2018-05-28 00:00:00.0 9.9889 475
149 9.6840 2018-05-29 00:00:00.0 9.6840 475
150 9.8852 2018-05-30 00:00:00.0 9.8852 475
151 9.9951 2018-05-31 00:00:00.0 9.9951 475
152 7.3551 2018-06-01 00:00:00.0 7.3551 475
153 13.7551 2018-06-02 00:00:00.0 6.4000 475
154 21.5327 2018-06-03 00:00:00.0 7.7776 475
155 30.0995 2018-06-04 00:00:00.0 8.5668 475
156 39.6403 2018-06-05 00:00:00.0 9.5408 475
157 48.9036 2018-06-06 00:00:00.0 9.2633 475
158 58.7383 2018-06-07 00:00:00.0 9.8347 475
159 68.5342 2018-06-08 00:00:00.0 9.7959 475
160 78.4607 2018-06-09 00:00:00.0 9.9265 475
161 87.7496 2018-06-10 00:00:00.0 9.2889 475
162 97.0511 2018-06-11 00:00:00.0 9.3015 475
163 105.9241 2018-06-12 00:00:00.0 8.8730 475
164 115.3685 2018-06-13 00:00:00.0 9.4444 475
165 125.1644 2018-06-14 00:00:00.0 9.7959 475
166 135.1231 2018-06-15 00:00:00.0 9.9587 475
167 143.9961 2018-06-16 00:00:00.0 8.8730 475
168 153.5961 2018-06-17 00:00:00.0 9.6000 475
169 163.1058 2018-06-18 00:00:00.0 9.5097 475
170 173.0196 2018-06-19 00:00:00.0 9.9138 475
171 183.0184 2018-06-20 00:00:00.0 9.9988 475
172 192.6184 2018-06-21 00:00:00.0 9.6000 475
173 202.3764 2018-06-22 00:00:00.0 9.7580 475
174 212.2764 2018-06-23 00:00:00.0 9.9000 475
175 222.0723 2018-06-24 00:00:00.0 9.7959 475
176 231.8682 2018-06-25 00:00:00.0 9.7959 475
177 241.6596 2018-06-26 00:00:00.0 9.7914 475
178 251.6398 2018-06-27 00:00:00.0 9.9802 475
179 261.6200 2018-06-28 00:00:00.0 9.9802 475
180 271.5690 2018-06-29 00:00:00.0 9.9490 475
181 281.2751 2018-06-30 00:00:00.0 9.7061 475
182 290.5384 2018-07-01 00:00:00.0 9.2633 475
183 300.2445 2018-07-02 00:00:00.0 9.7061 475
184 310.1583 2018-07-03 00:00:00.0 9.9138 475
185 320.1170 2018-07-04 00:00:00.0 9.9587 475
186 329.4920 2018-07-05 00:00:00.0 9.3750 475
187 339.4593 2018-07-06 00:00:00.0 9.9673 475
188 347.0692 2018-07-07 00:00:00.0 7.6099 475
189 357.0643 2018-07-08 00:00:00.0 9.9951 475
190 367.0133 2018-07-09 00:00:00.0 9.9490 475
191 376.4689 2018-07-10 00:00:00.0 9.4556 475
192 386.1911 2018-07-11 00:00:00.0 9.7222 475
193 395.8751 2018-07-12 00:00:00.0 9.6840 475
194 405.2220 2018-07-13 00:00:00.0 9.3469 475
195 413.2467 2018-07-14 00:00:00.0 8.0247 475
196 422.7243 2018-07-15 00:00:00.0 9.4776 475
197 431.0666 2018-07-16 00:00:00.0 8.3423 475
198 440.4416 2018-07-17 00:00:00.0 9.3750 475
199 450.3811 2018-07-18 00:00:00.0 9.9395 475
200 460.3811 2018-07-19 00:00:00.0 10.0000 475
201 470.2337 2018-07-20 00:00:00.0 9.8526 475
202 479.8618 2018-07-21 00:00:00.0 9.6281 475
203 489.8205 2018-07-22 00:00:00.0 9.9587 475
204 499.2649 2018-07-23 00:00:00.0 9.4444 475
205 508.1853 2018-07-24 00:00:00.0 8.9204 475
206 515.9629 2018-07-25 00:00:00.0 7.7776 475
207 524.6874 2018-07-26 00:00:00.0 8.7245 475
208 533.8297 2018-07-27 00:00:00.0 9.1423 475
209 543.2047 2018-07-28 00:00:00.0 9.3750 475
210 553.0741 2018-07-29 00:00:00.0 9.8694 475
211 563.0136 2018-07-30 00:00:00.0 9.9395 475
212 572.6136 2018-07-31 00:00:00.0 9.6000 475
213 579.1830 2018-08-01 00:00:00.0 6.5694 475
214 588.1498 2018-08-02 00:00:00.0 8.9668 475
215 597.7498 2018-08-03 00:00:00.0 9.6000 475
216 607.6004 2018-08-04 00:00:00.0 9.8506 475
217 617.2555 2018-08-05 00:00:00.0 9.6551 475
218 626.7963 2018-08-06 00:00:00.0 9.5408 475
219 636.0852 2018-08-07 00:00:00.0 9.2889 475
220 646.0741 2018-08-08 00:00:00.0 9.9889 475
221 656.0297 2018-08-09 00:00:00.0 9.9556 475
222 665.5359 2018-08-10 00:00:00.0 9.5062 475
223 672.6915 2018-08-11 00:00:00.0 7.1556 475
224 677.1495 2018-08-12 00:00:00.0 4.4580 475
225 686.9245 2018-08-13 00:00:00.0 9.7750 475
226 694.2796 2018-08-14 00:00:00.0 7.3551 475
227 704.2791 2018-08-15 00:00:00.0 9.9995 475
228 713.6179 2018-08-16 00:00:00.0 9.3388 475
229 723.0623 2018-08-17 00:00:00.0 9.4444 475
230 732.0944 2018-08-18 00:00:00.0 9.0321 475
231 741.4332 2018-08-19 00:00:00.0 9.3388 475
232 749.4720 2018-08-20 00:00:00.0 8.0388 475
233 758.1965 2018-08-21 00:00:00.0 8.7245 475
234 768.1837 2018-08-22 00:00:00.0 9.9872 475
235 778.1047 2018-08-23 00:00:00.0 9.9210 475
236 787.6756 2018-08-24 00:00:00.0 9.5709 475
237 796.1878 2018-08-25 00:00:00.0 8.5122 475
238 803.5429 2018-08-26 00:00:00.0 7.3551 475
239 809.2245 2018-08-27 00:00:00.0 5.6816 475
240 815.5383 2018-08-28 00:00:00.0 6.3138 475
241 824.3628 2018-08-29 00:00:00.0 8.8245 475
242 834.3623 2018-08-30 00:00:00.0 9.9995 475
243 844.0684 2018-08-31 00:00:00.0 9.7061 475
244 853.4786 2018-09-01 00:00:00.0 9.4102 475
245 861.7026 2018-09-02 00:00:00.0 8.2240 475
246 871.3307 2018-09-03 00:00:00.0 9.6281 475
247 879.9511 2018-09-04 00:00:00.0 8.6204 475
248 884.1098 2018-09-05 00:00:00.0 4.1587 475
249 890.0685 2018-09-06 00:00:00.0 5.9587 475
250 897.7782 2018-09-07 00:00:00.0 7.7097 475
251 906.7450 2018-09-08 00:00:00.0 8.9668 475
252 916.5409 2018-09-09 00:00:00.0 9.7959 475
253 925.4139 2018-09-10 00:00:00.0 8.8730 475
254 934.7889 2018-09-11 00:00:00.0 9.3750 475
255 938.9476 2018-09-12 00:00:00.0 4.1587 475
256 944.9063 2018-09-13 00:00:00.0 5.9587 475
257 951.2201 2018-09-14 00:00:00.0 6.3138 475
258 957.1788 2018-09-15 00:00:00.0 5.9587 475
259 963.4926 2018-09-16 00:00:00.0 6.3138 475
260 964.7370 2018-09-17 00:00:00.0 1.2444 475
261 969.1120 2018-09-18 00:00:00.0 4.3750 475
262 973.2707 2018-09-19 00:00:00.0 4.1587 475
263 973.2707 2018-09-20 00:00:00.0 0.0000 475
264 975.0416 2018-09-21 00:00:00.0 1.7709 475
265 975.0416 2018-09-22 00:00:00.0 0.0000 475
266 975.0416 2018-09-23 00:00:00.0 0.0000 475
267 975.0416 2018-09-24 00:00:00.0 0.0000 475
268 977.4477 2018-09-25 00:00:00.0 2.4061 475
CACHED false
EXECUTIONTIME 21
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '475') AND ddate < '2018-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/25/2018 2 977
9/24/2018 0 975
9/23/2018 0 975
9/22/2018 0 975
9/21/2018 2 975
9/20/2018 0 973
9/19/2018 4 973
9/18/2018 4 969
9/17/2018 1 965
9/16/2018 6 963
9/15/2018 6 957
9/14/2018 6 951
9/13/2018 6 945
9/12/2018 4 939
9/11/2018 9 935
9/10/2018 9 925
9/9/2018 10 917
9/8/2018 9 907
9/7/2018 8 898
9/6/2018 6 890
9/5/2018 4 884
9/4/2018 9 880
9/3/2018 10 871
9/2/2018 8 862
9/1/2018 9 853
8/31/2018 10 844
8/30/2018 10 834
8/29/2018 9 824
8/28/2018 6 816
8/27/2018 6 809
8/26/2018 7 804
8/25/2018 9 796
8/24/2018 10 788
8/23/2018 10 778
8/22/2018 10 768
8/21/2018 9 758
8/20/2018 8 749
8/19/2018 9 741
8/18/2018 9 732
8/17/2018 9 723
8/16/2018 9 714
8/15/2018 10 704
8/14/2018 7 694
8/13/2018 10 687
8/12/2018 4 677
8/11/2018 7 673
8/10/2018 10 666
8/9/2018 10 656
8/8/2018 10 646
8/7/2018 9 636
8/6/2018 10 627
8/5/2018 10 617
8/4/2018 10 608
8/3/2018 10 598
8/2/2018 9 588
8/1/2018 7 579
7/31/2018 10 573
7/30/2018 10 563
7/29/2018 10 553
7/28/2018 9 543
7/27/2018 9 534
7/26/2018 9 525
7/25/2018 8 516
7/24/2018 9 508
7/23/2018 9 499
7/22/2018 10 490
7/21/2018 10 480
7/20/2018 10 470
7/19/2018 10 460
7/18/2018 10 450
7/17/2018 9 440
7/16/2018 8 431
7/15/2018 9 423
7/14/2018 8 413
7/13/2018 9 405
7/12/2018 10 396
7/11/2018 10 386
7/10/2018 9 376
7/9/2018 10 367
7/8/2018 10 357
7/7/2018 8 347
7/6/2018 10 339
7/5/2018 9 329
7/4/2018 10 320
7/3/2018 10 310
7/2/2018 10 300
7/1/2018 9 291
6/30/2018 10 281
6/29/2018 10 272
6/28/2018 10 262
6/27/2018 10 252
6/26/2018 10 242
6/25/2018 10 232
6/24/2018 10 222
6/23/2018 10 212
6/22/2018 10 202
6/21/2018 10 193
6/20/2018 10 183
6/19/2018 10 173
6/18/2018 10 163
6/17/2018 10 154
6/16/2018 9 144
6/15/2018 10 135
6/14/2018 10 125
6/13/2018 9 115
6/12/2018 9 106
6/11/2018 9 97
6/10/2018 9 88
6/9/2018 10 78
6/8/2018 10 69
6/7/2018 10 59
6/6/2018 9 49
6/5/2018 10 40
6/4/2018 9 30
6/3/2018 8 22
6/2/2018 6 14
6/1/2018 7 7
5/31/2018 10 10
5/30/2018 10 10
5/29/2018 10 10
5/28/2018 10 10
5/27/2018 10 10
5/26/2018 10 10
5/25/2018 10 10
5/24/2018 10 10
5/23/2018 9 9
5/22/2018 10 10
5/21/2018 10 10
5/20/2018 10 10
5/19/2018 5 5
5/18/2018 2 2
5/17/2018 4 4
5/16/2018 7 7
5/15/2018 7 7