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 9.1000 2017-05-19 00:00:00.0 9.1000 327
2 15.0587 2017-05-20 00:00:00.0 5.9587 327
3 17.3398 2017-05-21 00:00:00.0 2.2811 327
4 21.0536 2017-05-22 00:00:00.0 3.7138 327
5 29.0924 2017-05-23 00:00:00.0 8.0388 327
6 37.1939 2017-05-24 00:00:00.0 8.1015 327
7 44.7648 2017-05-25 00:00:00.0 7.5709 327
8 52.8663 2017-05-26 00:00:00.0 8.1015 327
9 61.1500 2017-05-27 00:00:00.0 8.2837 327
10 66.0480 2017-05-28 00:00:00.0 4.8980 327
11 67.8189 2017-05-29 00:00:00.0 1.7709 327
12 74.5536 2017-05-30 00:00:00.0 6.7347 327
13 83.4266 2017-05-31 00:00:00.0 8.8730 327
14 93.3853 2017-06-01 00:00:00.0 9.9587 327
15 101.9581 2017-06-02 00:00:00.0 8.5728 327
16 111.9383 2017-06-03 00:00:00.0 9.9802 327
17 121.7342 2017-06-04 00:00:00.0 9.7959 327
18 131.7092 2017-06-05 00:00:00.0 9.9750 327
19 141.4393 2017-06-06 00:00:00.0 9.7301 327
20 150.7781 2017-06-07 00:00:00.0 9.3388 327
21 160.5740 2017-06-08 00:00:00.0 9.7959 327
22 169.6740 2017-06-09 00:00:00.0 9.1000 327
23 179.3021 2017-06-10 00:00:00.0 9.6281 327
24 188.4444 2017-06-11 00:00:00.0 9.1423 327
25 197.2689 2017-06-12 00:00:00.0 8.8245 327
26 205.7811 2017-06-13 00:00:00.0 8.5122 327
27 213.8826 2017-06-14 00:00:00.0 8.1015 327
28 221.5923 2017-06-15 00:00:00.0 7.7097 327
29 229.7556 2017-06-16 00:00:00.0 8.1633 327
30 237.1837 2017-06-17 00:00:00.0 7.4281 327
31 244.3898 2017-06-18 00:00:00.0 7.2061 327
32 252.3000 2017-06-19 00:00:00.0 7.9102 327
33 260.2750 2017-06-20 00:00:00.0 7.9750 327
34 269.4990 2017-06-21 00:00:00.0 9.2240 327
35 277.6623 2017-06-22 00:00:00.0 8.1633 327
36 283.8888 2017-06-23 00:00:00.0 6.2265 327
37 288.0475 2017-06-24 00:00:00.0 4.1587 327
38 293.8225 2017-06-25 00:00:00.0 5.7750 327
39 301.7327 2017-06-26 00:00:00.0 7.9102 327
40 311.6327 2017-06-27 00:00:00.0 9.9000 327
41 321.5914 2017-06-28 00:00:00.0 9.9587 327
42 330.6914 2017-06-29 00:00:00.0 9.1000 327
43 337.1766 2017-07-01 00:00:00.0 6.4852 327
44 340.6618 2017-07-02 00:00:00.0 3.4852 327
45 348.6368 2017-07-05 00:00:00.0 7.9750 327
46 358.6257 2017-07-06 00:00:00.0 9.9889 327
47 368.3788 2017-07-07 00:00:00.0 9.7531 327
48 378.3677 2017-07-08 00:00:00.0 9.9889 327
49 388.3628 2017-07-09 00:00:00.0 9.9951 327
50 398.2628 2017-07-10 00:00:00.0 9.9000 327
51 408.1628 2017-07-11 00:00:00.0 9.9000 327
52 416.4465 2017-07-12 00:00:00.0 8.2837 327
53 423.0991 2017-07-13 00:00:00.0 6.6526 327
54 433.0578 2017-07-14 00:00:00.0 9.9587 327
55 442.9578 2017-07-15 00:00:00.0 9.9000 327
56 452.7925 2017-07-16 00:00:00.0 9.8347 327
57 462.7320 2017-07-17 00:00:00.0 9.9395 327
58 471.8743 2017-07-18 00:00:00.0 9.1423 327
59 481.1758 2017-07-19 00:00:00.0 9.3015 327
60 490.8039 2017-07-20 00:00:00.0 9.6281 327
61 500.6891 2017-07-21 00:00:00.0 9.8852 327
62 509.9906 2017-07-22 00:00:00.0 9.3015 327
63 519.7207 2017-07-23 00:00:00.0 9.7301 327
64 529.5972 2017-07-24 00:00:00.0 9.8765 327
65 539.4319 2017-07-25 00:00:00.0 9.8347 327
66 549.4237 2017-07-26 00:00:00.0 9.9918 327
67 559.4217 2017-07-27 00:00:00.0 9.9980 327
68 568.2353 2017-07-28 00:00:00.0 8.8136 327
69 578.1563 2017-07-29 00:00:00.0 9.9210 327
70 587.5588 2017-07-30 00:00:00.0 9.4025 327
71 596.3724 2017-07-31 00:00:00.0 8.8136 327
72 606.1683 2017-08-01 00:00:00.0 9.7959 327
73 616.1173 2017-08-03 00:00:00.0 9.9490 327
74 626.0760 2017-08-05 00:00:00.0 9.9587 327
75 635.0882 2017-08-06 00:00:00.0 9.0122 327
76 644.7943 2017-08-07 00:00:00.0 9.7061 327
77 654.7861 2017-08-08 00:00:00.0 9.9918 327
78 664.7750 2017-08-10 00:00:00.0 9.9889 327
79 673.9587 2017-08-11 00:00:00.0 9.1837 327
80 682.8317 2017-08-12 00:00:00.0 8.8730 327
81 689.3169 2017-08-13 00:00:00.0 6.4852 327
82 699.1863 2017-08-14 00:00:00.0 9.8694 327
83 707.1110 2017-08-19 00:00:00.0 7.9247 327
84 715.5110 2017-08-20 00:00:00.0 8.4000 327
85 723.6125 2017-08-21 00:00:00.0 8.1015 327
86 730.0977 2017-08-22 00:00:00.0 6.4852 327
87 739.8727 2017-08-24 00:00:00.0 9.7750 327
88 749.5538 2017-08-25 00:00:00.0 9.6811 327
89 757.9538 2017-08-28 00:00:00.0 8.4000 327
90 767.6349 2017-08-29 00:00:00.0 9.6811 327
91 773.9487 2017-08-30 00:00:00.0 6.3138 327
92 783.8181 2017-08-31 00:00:00.0 9.8694 327
93 793.8161 2017-09-01 00:00:00.0 9.9980 327
94 803.4442 2017-09-02 00:00:00.0 9.6281 327
95 813.0151 2017-09-03 00:00:00.0 9.5709 327
96 821.1784 2017-09-04 00:00:00.0 8.1633 327
97 827.4049 2017-09-05 00:00:00.0 6.2265 327
98 834.9049 2017-09-06 00:00:00.0 7.5000 327
99 843.4717 2017-09-07 00:00:00.0 8.5668 327
100 851.0426 2017-09-08 00:00:00.0 7.5709 327
101 860.4870 2017-09-09 00:00:00.0 9.4444 327
102 870.4265 2017-09-10 00:00:00.0 9.9395 327
103 880.0265 2017-09-11 00:00:00.0 9.6000 327
104 890.0265 2017-09-12 00:00:00.0 10.0000 327
105 898.5933 2017-09-13 00:00:00.0 8.5668 327
106 904.0851 2017-09-14 00:00:00.0 5.4918 327
107 906.8601 2017-09-15 00:00:00.0 2.7750 327
108 911.2351 2017-09-17 00:00:00.0 4.3750 327
109 916.2346 2017-09-18 00:00:00.0 4.9995 327
110 923.5157 2017-09-19 00:00:00.0 7.2811 327
111 933.3116 2017-09-20 00:00:00.0 9.7959 327
112 941.2218 2017-09-21 00:00:00.0 7.9102 327
113 947.7912 2017-09-22 00:00:00.0 6.5694 327
114 952.9907 2017-09-23 00:00:00.0 5.1995 327
115 957.5779 2017-09-25 00:00:00.0 4.5872 327
116 959.2187 2017-09-26 00:00:00.0 1.6408 327
117 965.7881 2017-09-27 00:00:00.0 6.5694 327
118 971.7468 2017-09-28 00:00:00.0 5.9587 327
119 974.6427 2017-09-29 00:00:00.0 2.8959 327
120 980.8692 2017-09-30 00:00:00.0 6.2265 327
121 988.4401 2017-10-01 00:00:00.0 7.5709 327
122 995.4151 2017-10-02 00:00:00.0 6.9750 327
123 997.5702 2017-10-03 00:00:00.0 2.1551 327
124 1001.1702 2017-10-04 00:00:00.0 3.6000 327
125 1003.3253 2017-10-05 00:00:00.0 2.1551 327
126 1008.2233 2017-10-06 00:00:00.0 4.8980 327
127 1015.3534 2017-10-07 00:00:00.0 7.1301 327
128 1019.0672 2017-10-08 00:00:00.0 3.7138 327
129 1019.0672 2017-10-09 00:00:00.0 0.0000 327
130 1021.7203 2017-10-10 00:00:00.0 2.6531 327
131 1023.8754 2017-10-11 00:00:00.0 2.1551 327
132 1026.6504 2017-10-12 00:00:00.0 2.7750 327
133 1026.6504 2017-10-13 00:00:00.0 0.0000 327
134 1026.6504 2017-10-14 00:00:00.0 0.0000 327
135 1026.6504 2017-10-15 00:00:00.0 0.0000 327
136 1030.4769 2017-10-16 00:00:00.0 3.8265 327
137 1037.4519 2017-10-17 00:00:00.0 6.9750 327
138 1044.3478 2017-10-18 00:00:00.0 6.8959 327
139 1048.3968 2017-10-19 00:00:00.0 4.0490 327
140 1055.8968 2017-10-20 00:00:00.0 7.5000 327
141 1063.6065 2017-10-21 00:00:00.0 7.7097 327
142 1067.3203 2017-10-22 00:00:00.0 3.7138 327
143 1067.3203 2017-10-23 00:00:00.0 0.0000 327
144 1067.3203 2017-10-24 00:00:00.0 0.0000 327
145 1067.8836 2017-10-25 00:00:00.0 0.5633 327
146 1067.8836 2017-10-26 00:00:00.0 0.0000 327
147 1067.8836 2017-10-27 00:00:00.0 0.0000 327
148 1067.8836 2017-10-28 00:00:00.0 0.0000 327
149 1067.8836 2017-10-29 00:00:00.0 0.0000 327
150 1067.8836 2017-10-30 00:00:00.0 0.0000 327
151 1067.8836 2017-10-31 00:00:00.0 0.0000 327
152 1067.8836 2017-11-01 00:00:00.0 0.0000 327
153 1067.8836 2017-11-02 00:00:00.0 0.0000 327
154 1067.8836 2017-11-03 00:00:00.0 0.0000 327
155 1067.8836 2017-11-04 00:00:00.0 0.0000 327
156 1067.8836 2017-11-05 00:00:00.0 0.0000 327
157 1067.8836 2017-11-06 00:00:00.0 0.0000 327
158 1067.8836 2017-11-07 00:00:00.0 0.0000 327
159 1067.8836 2017-11-08 00:00:00.0 0.0000 327
160 1067.8836 2017-11-09 00:00:00.0 0.0000 327
161 1067.8836 2017-11-10 00:00:00.0 0.0000 327
162 1067.8836 2017-11-11 00:00:00.0 0.0000 327
163 1067.8836 2017-11-12 00:00:00.0 0.0000 327
164 1067.8836 2017-11-13 00:00:00.0 0.0000 327
165 1067.8836 2017-11-14 00:00:00.0 0.0000 327
166 1067.8836 2017-11-15 00:00:00.0 0.0000 327
167 1067.8836 2017-11-16 00:00:00.0 0.0000 327
168 1067.8836 2017-11-17 00:00:00.0 0.0000 327
169 1067.8836 2017-11-18 00:00:00.0 0.0000 327
170 1067.8836 2017-11-19 00:00:00.0 0.0000 327
171 1067.8836 2017-11-20 00:00:00.0 0.0000 327
172 1067.8836 2017-11-21 00:00:00.0 0.0000 327
173 1067.8836 2017-11-22 00:00:00.0 0.0000 327
174 1067.8836 2017-11-23 00:00:00.0 0.0000 327
175 1067.8836 2017-11-24 00:00:00.0 0.0000 327
176 1067.8836 2017-11-25 00:00:00.0 0.0000 327
177 1067.8836 2017-11-26 00:00:00.0 0.0000 327
178 1067.8836 2017-11-27 00:00:00.0 0.0000 327
179 1067.8836 2017-11-28 00:00:00.0 0.0000 327
180 1067.8836 2017-11-29 00:00:00.0 0.0000 327
181 1067.8836 2017-11-30 00:00:00.0 0.0000 327
182 1067.8836 2017-12-01 00:00:00.0 0.0000 327
183 1067.8836 2017-12-02 00:00:00.0 0.0000 327
184 1067.8836 2017-12-03 00:00:00.0 0.0000 327
185 1067.8836 2017-12-04 00:00:00.0 0.0000 327
186 1067.8836 2017-12-05 00:00:00.0 0.0000 327
187 1067.8836 2017-12-06 00:00:00.0 0.0000 327
188 1067.8836 2017-12-07 00:00:00.0 0.0000 327
189 1067.8836 2017-12-08 00:00:00.0 0.0000 327
190 1067.8836 2017-12-09 00:00:00.0 0.0000 327
191 1067.8836 2017-12-10 00:00:00.0 0.0000 327
192 1067.8836 2017-12-11 00:00:00.0 0.0000 327
193 1067.8836 2017-12-12 00:00:00.0 0.0000 327
194 1067.8836 2017-12-13 00:00:00.0 0.0000 327
195 1067.8836 2017-12-14 00:00:00.0 0.0000 327
196 1067.8836 2017-12-15 00:00:00.0 0.0000 327
197 1067.8836 2017-12-16 00:00:00.0 0.0000 327
198 1067.8836 2017-12-17 00:00:00.0 0.0000 327
199 1067.8836 2017-12-18 00:00:00.0 0.0000 327
200 1067.8836 2017-12-19 00:00:00.0 0.0000 327
201 1067.8836 2017-12-20 00:00:00.0 0.0000 327
202 1067.8836 2017-12-21 00:00:00.0 0.0000 327
CACHED false
EXECUTIONTIME 4
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '327') AND ddate < '2018-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total