Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Carberry North Wawanesa Glenboro Glenora Treherne Gladstone Portage East High Bluff Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Macdonald Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 8.9668 2017-05-15 00:00:00.0 8.9668 202
2 16.2479 2017-05-16 00:00:00.0 7.2811 202
3 17.8887 2017-05-17 00:00:00.0 1.6408 202
4 18.4520 2017-05-18 00:00:00.0 0.5633 202
5 22.6107 2017-05-19 00:00:00.0 4.1587 202
6 28.5694 2017-05-20 00:00:00.0 5.9587 202
7 30.7245 2017-05-21 00:00:00.0 2.1551 202
8 33.9771 2017-05-22 00:00:00.0 3.2526 202
9 41.3322 2017-05-23 00:00:00.0 7.3551 202
10 49.3072 2017-05-24 00:00:00.0 7.9750 202
11 57.0848 2017-05-25 00:00:00.0 7.7776 202
12 65.1236 2017-05-26 00:00:00.0 8.0388 202
13 73.4073 2017-05-27 00:00:00.0 8.2837 202
14 78.8027 2017-05-28 00:00:00.0 5.3954 202
15 80.7027 2017-05-29 00:00:00.0 1.9000 202
16 87.1027 2017-05-30 00:00:00.0 6.4000 202
17 95.7757 2017-05-31 00:00:00.0 8.6730 202
18 105.7752 2017-06-01 00:00:00.0 9.9995 202
19 114.6641 2017-06-02 00:00:00.0 8.8889 202
20 124.5851 2017-06-03 00:00:00.0 9.9210 202
21 134.2912 2017-06-04 00:00:00.0 9.7061 202
22 144.2912 2017-06-05 00:00:00.0 10.0000 202
23 154.1134 2017-06-06 00:00:00.0 9.8222 202
24 163.8435 2017-06-07 00:00:00.0 9.7301 202
25 173.8307 2017-06-08 00:00:00.0 9.9872 202
26 183.5838 2017-06-09 00:00:00.0 9.7531 202
27 193.4185 2017-06-10 00:00:00.0 9.8347 202
28 203.2144 2017-06-11 00:00:00.0 9.7959 202
29 212.3144 2017-06-12 00:00:00.0 9.1000 202
30 221.1874 2017-06-13 00:00:00.0 8.8730 202
31 230.5262 2017-06-14 00:00:00.0 9.3388 202
32 239.2507 2017-06-15 00:00:00.0 8.7245 202
33 247.2257 2017-06-16 00:00:00.0 7.9750 202
34 254.2007 2017-06-17 00:00:00.0 6.9750 202
35 261.3308 2017-06-18 00:00:00.0 7.1301 202
36 268.3839 2017-06-19 00:00:00.0 7.0531 202
37 276.7839 2017-06-20 00:00:00.0 8.4000 202
38 285.1262 2017-06-21 00:00:00.0 8.3423 202
39 293.4099 2017-06-22 00:00:00.0 8.2837 202
40 299.8951 2017-06-23 00:00:00.0 6.4852 202
41 303.8334 2017-06-24 00:00:00.0 3.9383 202
42 308.3150 2017-06-25 00:00:00.0 4.4816 202
43 316.6573 2017-06-26 00:00:00.0 8.3423 202
44 326.3124 2017-06-27 00:00:00.0 9.6551 202
45 335.9405 2017-06-28 00:00:00.0 9.6281 202
46 345.3155 2017-06-29 00:00:00.0 9.3750 202
47 353.8823 2017-06-30 00:00:00.0 8.5668 202
48 362.5027 2017-07-01 00:00:00.0 8.6204 202
49 370.9593 2017-07-02 00:00:00.0 8.4566 202
50 380.8976 2017-07-03 00:00:00.0 9.9383 202
51 390.7976 2017-07-04 00:00:00.0 9.9000 202
52 400.6741 2017-07-05 00:00:00.0 9.8765 202
53 410.6721 2017-07-06 00:00:00.0 9.9980 202
54 420.3782 2017-07-07 00:00:00.0 9.7061 202
55 430.3532 2017-07-08 00:00:00.0 9.9750 202
56 440.3282 2017-07-09 00:00:00.0 9.9750 202
57 450.3154 2017-07-10 00:00:00.0 9.9872 202
58 460.0215 2017-07-11 00:00:00.0 9.7061 202
59 468.6945 2017-07-12 00:00:00.0 8.6730 202
60 478.0333 2017-07-13 00:00:00.0 9.3388 202
61 487.9598 2017-07-14 00:00:00.0 9.9265 202
62 497.8981 2017-07-15 00:00:00.0 9.9383 202
63 507.7675 2017-07-16 00:00:00.0 9.8694 202
64 517.5897 2017-07-17 00:00:00.0 9.8222 202
65 526.8530 2017-07-18 00:00:00.0 9.2633 202
66 536.0367 2017-07-19 00:00:00.0 9.1837 202
67 545.6076 2017-07-20 00:00:00.0 9.5709 202
68 555.3826 2017-07-21 00:00:00.0 9.7750 202
69 564.7576 2017-07-22 00:00:00.0 9.3750 202
70 574.6428 2017-07-23 00:00:00.0 9.8852 202
71 584.6119 2017-07-24 00:00:00.0 9.9691 202
72 594.5935 2017-07-25 00:00:00.0 9.9816 202
73 604.5751 2017-07-26 00:00:00.0 9.9816 202
74 614.4516 2017-07-27 00:00:00.0 9.8765 202
75 623.9578 2017-07-28 00:00:00.0 9.5062 202
76 633.6418 2017-07-29 00:00:00.0 9.6840 202
77 642.7418 2017-07-30 00:00:00.0 9.1000 202
78 651.3146 2017-07-31 00:00:00.0 8.5728 202
79 661.0896 2017-08-01 00:00:00.0 9.7750 202
80 669.1284 2017-08-02 00:00:00.0 8.0388 202
81 677.9034 2017-08-03 00:00:00.0 8.7750 202
82 687.0034 2017-08-04 00:00:00.0 9.1000 202
83 696.0156 2017-08-05 00:00:00.0 9.0122 202
84 705.3544 2017-08-06 00:00:00.0 9.3388 202
85 715.2396 2017-08-07 00:00:00.0 9.8852 202
86 724.9457 2017-08-08 00:00:00.0 9.7061 202
87 734.1697 2017-08-09 00:00:00.0 9.2240 202
88 743.6141 2017-08-10 00:00:00.0 9.4444 202
89 753.2692 2017-08-11 00:00:00.0 9.6551 202
90 763.1218 2017-08-12 00:00:00.0 9.8526 202
91 772.9744 2017-08-13 00:00:00.0 9.8526 202
92 782.9331 2017-08-14 00:00:00.0 9.9587 202
93 792.7857 2017-08-15 00:00:00.0 9.8526 202
94 802.6995 2017-08-16 00:00:00.0 9.9138 202
95 812.2403 2017-08-17 00:00:00.0 9.5408 202
96 822.2153 2017-08-18 00:00:00.0 9.9750 202
97 832.1153 2017-08-19 00:00:00.0 9.9000 202
98 841.9847 2017-08-20 00:00:00.0 9.8694 202
99 849.9597 2017-08-21 00:00:00.0 7.9750 202
100 857.9985 2017-08-22 00:00:00.0 8.0388 202
101 863.6801 2017-08-23 00:00:00.0 5.6816 202
102 870.1653 2017-08-24 00:00:00.0 6.4852 202
103 879.7061 2017-08-25 00:00:00.0 9.5408 202
104 889.1163 2017-08-26 00:00:00.0 9.4102 202
105 899.0301 2017-08-27 00:00:00.0 9.9138 202
106 908.7523 2017-08-28 00:00:00.0 9.7222 202
107 918.7079 2017-08-29 00:00:00.0 9.9556 202
108 927.5324 2017-08-30 00:00:00.0 8.8245 202
109 936.9426 2017-08-31 00:00:00.0 9.4102 202
110 946.5707 2017-09-01 00:00:00.0 9.6281 202
111 956.0804 2017-09-02 00:00:00.0 9.5097 202
112 965.4554 2017-09-03 00:00:00.0 9.3750 202
113 973.4304 2017-09-04 00:00:00.0 7.9750 202
114 979.6569 2017-09-05 00:00:00.0 6.2265 202
115 986.3916 2017-09-06 00:00:00.0 6.7347 202
116 995.4482 2017-09-07 00:00:00.0 9.0566 202
117 1002.7293 2017-09-08 00:00:00.0 7.2811 202
118 1012.1737 2017-09-09 00:00:00.0 9.4444 202
119 1021.9317 2017-09-10 00:00:00.0 9.7580 202
120 1031.8455 2017-09-11 00:00:00.0 9.9138 202
121 1041.4455 2017-09-12 00:00:00.0 9.6000 202
122 1050.5878 2017-09-13 00:00:00.0 9.1423 202
123 1057.7939 2017-09-14 00:00:00.0 7.2061 202
124 1061.7322 2017-09-15 00:00:00.0 3.9383 202
125 1063.3730 2017-09-16 00:00:00.0 1.6408 202
126 1066.7424 2017-09-17 00:00:00.0 3.3694 202
127 1072.0404 2017-09-18 00:00:00.0 5.2980 202
128 1080.5526 2017-09-19 00:00:00.0 8.5122 202
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '202') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/19/2017 9 1081
9/18/2017 5 1072
9/17/2017 3 1067
9/16/2017 2 1063
9/15/2017 4 1062
9/14/2017 7 1058
9/13/2017 9 1051
9/12/2017 10 1041
9/11/2017 10 1032
9/10/2017 10 1022
9/9/2017 9 1012
9/8/2017 7 1003
9/7/2017 9 995
9/6/2017 7 986
9/5/2017 6 980
9/4/2017 8 973
9/3/2017 9 965
9/2/2017 10 956
9/1/2017 10 947
8/31/2017 9 937
8/30/2017 9 928
8/29/2017 10 919
8/28/2017 10 909
8/27/2017 10 899
8/26/2017 9 889
8/25/2017 10 880
8/24/2017 6 870
8/23/2017 6 864
8/22/2017 8 858
8/21/2017 8 850
8/20/2017 10 842
8/19/2017 10 832
8/18/2017 10 822
8/17/2017 10 812
8/16/2017 10 803
8/15/2017 10 793
8/14/2017 10 783
8/13/2017 10 773
8/12/2017 10 763
8/11/2017 10 753
8/10/2017 9 744
8/9/2017 9 734
8/8/2017 10 725
8/7/2017 10 715
8/6/2017 9 705
8/5/2017 9 696
8/4/2017 9 687
8/3/2017 9 678
8/2/2017 8 669
8/1/2017 10 661
7/31/2017 9 651
7/30/2017 9 643
7/29/2017 10 634
7/28/2017 10 624
7/27/2017 10 614
7/26/2017 10 605
7/25/2017 10 595
7/24/2017 10 585
7/23/2017 10 575
7/22/2017 9 565
7/21/2017 10 555
7/20/2017 10 546
7/19/2017 9 536
7/18/2017 9 527
7/17/2017 10 518
7/16/2017 10 508
7/15/2017 10 498
7/14/2017 10 488
7/13/2017 9 478
7/12/2017 9 469
7/11/2017 10 460
7/10/2017 10 450
7/9/2017 10 440
7/8/2017 10 430
7/7/2017 10 420
7/6/2017 10 411
7/5/2017 10 401
7/4/2017 10 391
7/3/2017 10 381
7/2/2017 8 371
7/1/2017 9 363
6/30/2017 9 354
6/29/2017 9 345
6/28/2017 10 336
6/27/2017 10 326
6/26/2017 8 317
6/25/2017 4 308
6/24/2017 4 304
6/23/2017 6 300
6/22/2017 8 293
6/21/2017 8 285
6/20/2017 8 277
6/19/2017 7 268
6/18/2017 7 261
6/17/2017 7 254
6/16/2017 8 247
6/15/2017 9 239
6/14/2017 9 231
6/13/2017 9 221
6/12/2017 9 212
6/11/2017 10 203
6/10/2017 10 193
6/9/2017 10 184
6/8/2017 10 174
6/7/2017 10 164
6/6/2017 10 154
6/5/2017 10 144
6/4/2017 10 134
6/3/2017 10 125
6/2/2017 9 115
6/1/2017 10 106
5/31/2017 9 96
5/30/2017 6 87
5/29/2017 2 81
5/28/2017 5 79
5/27/2017 8 73
5/26/2017 8 65
5/25/2017 8 57
5/24/2017 8 49
5/23/2017 7 41
5/22/2017 3 34
5/21/2017 2 31
5/20/2017 6 29
5/19/2017 4 23
5/18/2017 1 18
5/17/2017 2 18
5/16/2017 7 16
5/15/2017 9 9