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 9.1423 2017-05-15 00:00:00.0 9.1423 203
2 15.5423 2017-05-16 00:00:00.0 6.4000 203
3 17.4423 2017-05-17 00:00:00.0 1.9000 203
4 17.8663 2017-05-18 00:00:00.0 0.4240 203
5 21.8046 2017-05-19 00:00:00.0 3.9383 203
6 26.9046 2017-05-20 00:00:00.0 5.1000 203
7 28.2822 2017-05-21 00:00:00.0 1.3776 203
8 30.9353 2017-05-22 00:00:00.0 2.6531 203
9 37.9103 2017-05-23 00:00:00.0 6.9750 203
10 46.1940 2017-05-24 00:00:00.0 8.2837 203
11 54.3573 2017-05-25 00:00:00.0 8.1633 203
12 63.0818 2017-05-26 00:00:00.0 8.7245 203
13 71.5384 2017-05-27 00:00:00.0 8.4566 203
14 76.6384 2017-05-28 00:00:00.0 5.1000 203
15 78.7935 2017-05-29 00:00:00.0 2.1551 203
16 84.7522 2017-05-30 00:00:00.0 5.9587 203
17 93.1522 2017-05-31 00:00:00.0 8.4000 203
18 103.1338 2017-06-01 00:00:00.0 9.9816 203
19 111.7894 2017-06-02 00:00:00.0 8.6556 203
20 121.4734 2017-06-03 00:00:00.0 9.6840 203
21 131.2484 2017-06-04 00:00:00.0 9.7750 203
22 141.2402 2017-06-05 00:00:00.0 9.9918 203
23 150.9624 2017-06-06 00:00:00.0 9.7222 203
24 160.8318 2017-06-07 00:00:00.0 9.8694 203
25 170.7456 2017-06-08 00:00:00.0 9.9138 203
26 180.5206 2017-06-09 00:00:00.0 9.7750 203
27 190.4058 2017-06-10 00:00:00.0 9.8852 203
28 200.2910 2017-06-11 00:00:00.0 9.8852 203
29 209.0660 2017-06-12 00:00:00.0 8.7750 203
30 218.0328 2017-06-13 00:00:00.0 8.9668 203
31 227.6037 2017-06-14 00:00:00.0 9.5709 203
32 236.1159 2017-06-15 00:00:00.0 8.5122 203
33 244.5725 2017-06-16 00:00:00.0 8.4566 203
34 252.0725 2017-06-17 00:00:00.0 7.5000 203
35 259.3536 2017-06-18 00:00:00.0 7.2811 203
36 266.9245 2017-06-19 00:00:00.0 7.5709 203
37 275.2668 2017-06-20 00:00:00.0 8.3423 203
38 283.6091 2017-06-21 00:00:00.0 8.3423 203
39 292.0091 2017-06-22 00:00:00.0 8.4000 203
40 298.8249 2017-06-23 00:00:00.0 6.8158 203
41 303.3065 2017-06-24 00:00:00.0 4.4816 203
42 307.8937 2017-06-25 00:00:00.0 4.5872 203
43 315.8039 2017-06-26 00:00:00.0 7.9102 203
44 325.3748 2017-06-27 00:00:00.0 9.5709 203
45 334.7850 2017-06-28 00:00:00.0 9.4102 203
46 343.9687 2017-06-29 00:00:00.0 9.1837 203
47 352.5891 2017-06-30 00:00:00.0 8.6204 203
48 360.9314 2017-07-01 00:00:00.0 8.3423 203
49 368.9702 2017-07-02 00:00:00.0 8.0388 203
50 378.8049 2017-07-03 00:00:00.0 9.8347 203
51 388.4481 2017-07-04 00:00:00.0 9.6432 203
52 398.4283 2017-07-05 00:00:00.0 9.9802 203
53 408.4234 2017-07-06 00:00:00.0 9.9951 203
54 418.0234 2017-07-07 00:00:00.0 9.6000 203
55 427.9372 2017-07-08 00:00:00.0 9.9138 203
56 437.8862 2017-07-09 00:00:00.0 9.9490 203
57 447.8127 2017-07-10 00:00:00.0 9.9265 203
58 457.7617 2017-07-11 00:00:00.0 9.9490 203
59 466.4862 2017-07-12 00:00:00.0 8.7245 203
60 475.1066 2017-07-13 00:00:00.0 8.6204 203
61 484.8367 2017-07-14 00:00:00.0 9.7301 203
62 494.7750 2017-07-15 00:00:00.0 9.9383 203
63 504.6097 2017-07-16 00:00:00.0 9.8347 203
64 514.5097 2017-07-17 00:00:00.0 9.9000 203
65 523.8485 2017-07-18 00:00:00.0 9.3388 203
66 532.9051 2017-07-19 00:00:00.0 9.0566 203
67 542.4760 2017-07-20 00:00:00.0 9.5709 203
68 552.4433 2017-07-21 00:00:00.0 9.9673 203
69 561.8877 2017-07-22 00:00:00.0 9.4444 203
70 571.7224 2017-07-23 00:00:00.0 9.8347 203
71 581.6434 2017-07-24 00:00:00.0 9.9210 203
72 591.6388 2017-07-25 00:00:00.0 9.9954 203
73 601.5975 2017-07-26 00:00:00.0 9.9587 203
74 611.5955 2017-07-27 00:00:00.0 9.9980 203
75 621.4177 2017-07-28 00:00:00.0 9.8222 203
76 630.6461 2017-07-29 00:00:00.0 9.2284 203
77 639.6782 2017-07-30 00:00:00.0 9.0321 203
78 648.1659 2017-07-31 00:00:00.0 8.4877 203
79 658.0006 2017-08-01 00:00:00.0 9.8347 203
80 666.2246 2017-08-02 00:00:00.0 8.2240 203
81 675.0491 2017-08-03 00:00:00.0 8.8245 203
82 683.8241 2017-08-04 00:00:00.0 8.7750 203
83 692.7445 2017-08-05 00:00:00.0 8.9204 203
84 701.7113 2017-08-06 00:00:00.0 8.9668 203
85 711.4863 2017-08-07 00:00:00.0 9.7750 203
86 721.1674 2017-08-08 00:00:00.0 9.6811 203
87 730.3097 2017-08-09 00:00:00.0 9.1423 203
88 739.8505 2017-08-10 00:00:00.0 9.5408 203
89 749.0342 2017-08-11 00:00:00.0 9.1837 203
90 758.6893 2017-08-12 00:00:00.0 9.6551 203
91 768.4852 2017-08-13 00:00:00.0 9.7959 203
92 778.3378 2017-08-14 00:00:00.0 9.8526 203
93 788.2516 2017-08-15 00:00:00.0 9.9138 203
94 797.9577 2017-08-16 00:00:00.0 9.7061 203
95 807.3679 2017-08-17 00:00:00.0 9.4102 203
96 817.2026 2017-08-18 00:00:00.0 9.8347 203
97 826.9606 2017-08-19 00:00:00.0 9.7580 203
98 836.8744 2017-08-20 00:00:00.0 9.9138 203
99 844.7846 2017-08-21 00:00:00.0 7.9102 203
100 852.6948 2017-08-22 00:00:00.0 7.9102 203
101 857.6943 2017-08-23 00:00:00.0 4.9995 203
102 863.9208 2017-08-24 00:00:00.0 6.2265 203
103 873.5759 2017-08-25 00:00:00.0 9.6551 203
104 883.0203 2017-08-26 00:00:00.0 9.4444 203
105 892.8729 2017-08-27 00:00:00.0 9.8526 203
106 902.8124 2017-08-28 00:00:00.0 9.9395 203
107 912.3186 2017-08-29 00:00:00.0 9.5062 203
108 920.8854 2017-08-30 00:00:00.0 8.5668 203
109 930.6155 2017-08-31 00:00:00.0 9.7301 203
110 940.1864 2017-09-01 00:00:00.0 9.5709 203
111 949.5966 2017-09-02 00:00:00.0 9.4102 203
112 959.1063 2017-09-03 00:00:00.0 9.5097 203
113 967.0165 2017-09-04 00:00:00.0 7.9102 203
114 972.9752 2017-09-05 00:00:00.0 5.9587 203
115 977.8732 2017-09-06 00:00:00.0 4.8980 203
116 986.6977 2017-09-07 00:00:00.0 8.8245 203
117 994.5421 2017-09-08 00:00:00.0 7.8444 203
118 1004.1972 2017-09-09 00:00:00.0 9.6551 203
119 1013.7515 2017-09-10 00:00:00.0 9.5543 203
120 1023.6780 2017-09-11 00:00:00.0 9.9265 203
121 1033.0805 2017-09-12 00:00:00.0 9.4025 203
122 1042.5902 2017-09-13 00:00:00.0 9.5097 203
123 1050.0183 2017-09-14 00:00:00.0 7.4281 203
124 1054.1770 2017-09-15 00:00:00.0 4.1587 203
125 1056.2051 2017-09-16 00:00:00.0 2.0281 203
126 1059.8051 2017-09-17 00:00:00.0 3.6000 203
127 1066.8582 2017-09-18 00:00:00.0 7.0531 203
128 1075.7786 2017-09-19 00:00:00.0 8.9204 203
CACHED false
EXECUTIONTIME 3
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '203') 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 1076
9/18/2017 7 1067
9/17/2017 4 1060
9/16/2017 2 1056
9/15/2017 4 1054
9/14/2017 7 1050
9/13/2017 10 1043
9/12/2017 9 1033
9/11/2017 10 1024
9/10/2017 10 1014
9/9/2017 10 1004
9/8/2017 8 995
9/7/2017 9 987
9/6/2017 5 978
9/5/2017 6 973
9/4/2017 8 967
9/3/2017 10 959
9/2/2017 9 950
9/1/2017 10 940
8/31/2017 10 931
8/30/2017 9 921
8/29/2017 10 912
8/28/2017 10 903
8/27/2017 10 893
8/26/2017 9 883
8/25/2017 10 874
8/24/2017 6 864
8/23/2017 5 858
8/22/2017 8 853
8/21/2017 8 845
8/20/2017 10 837
8/19/2017 10 827
8/18/2017 10 817
8/17/2017 9 807
8/16/2017 10 798
8/15/2017 10 788
8/14/2017 10 778
8/13/2017 10 768
8/12/2017 10 759
8/11/2017 9 749
8/10/2017 10 740
8/9/2017 9 730
8/8/2017 10 721
8/7/2017 10 711
8/6/2017 9 702
8/5/2017 9 693
8/4/2017 9 684
8/3/2017 9 675
8/2/2017 8 666
8/1/2017 10 658
7/31/2017 8 648
7/30/2017 9 640
7/29/2017 9 631
7/28/2017 10 621
7/27/2017 10 612
7/26/2017 10 602
7/25/2017 10 592
7/24/2017 10 582
7/23/2017 10 572
7/22/2017 9 562
7/21/2017 10 552
7/20/2017 10 542
7/19/2017 9 533
7/18/2017 9 524
7/17/2017 10 515
7/16/2017 10 505
7/15/2017 10 495
7/14/2017 10 485
7/13/2017 9 475
7/12/2017 9 466
7/11/2017 10 458
7/10/2017 10 448
7/9/2017 10 438
7/8/2017 10 428
7/7/2017 10 418
7/6/2017 10 408
7/5/2017 10 398
7/4/2017 10 388
7/3/2017 10 379
7/2/2017 8 369
7/1/2017 8 361
6/30/2017 9 353
6/29/2017 9 344
6/28/2017 9 335
6/27/2017 10 325
6/26/2017 8 316
6/25/2017 5 308
6/24/2017 4 303
6/23/2017 7 299
6/22/2017 8 292
6/21/2017 8 284
6/20/2017 8 275
6/19/2017 8 267
6/18/2017 7 259
6/17/2017 8 252
6/16/2017 8 245
6/15/2017 9 236
6/14/2017 10 228
6/13/2017 9 218
6/12/2017 9 209
6/11/2017 10 200
6/10/2017 10 190
6/9/2017 10 181
6/8/2017 10 171
6/7/2017 10 161
6/6/2017 10 151
6/5/2017 10 141
6/4/2017 10 131
6/3/2017 10 121
6/2/2017 9 112
6/1/2017 10 103
5/31/2017 8 93
5/30/2017 6 85
5/29/2017 2 79
5/28/2017 5 77
5/27/2017 8 72
5/26/2017 9 63
5/25/2017 8 54
5/24/2017 8 46
5/23/2017 7 38
5/22/2017 3 31
5/21/2017 1 28
5/20/2017 5 27
5/19/2017 4 22
5/18/2017 0 18
5/17/2017 2 17
5/16/2017 6 16
5/15/2017 9 9