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.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
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '327') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/15/2017 3 907
9/14/2017 5 904
9/13/2017 9 899
9/12/2017 10 890
9/11/2017 10 880
9/10/2017 10 870
9/9/2017 9 860
9/8/2017 8 851
9/7/2017 9 843
9/6/2017 8 835
9/5/2017 6 827
9/4/2017 8 821
9/3/2017 10 813
9/2/2017 10 803
9/1/2017 10 794
8/31/2017 10 784
8/30/2017 6 774
8/29/2017 10 768
8/28/2017 8 758
8/25/2017 10 750
8/24/2017 10 740
8/22/2017 6 730
8/21/2017 8 724
8/20/2017 8 716
8/19/2017 8 707
8/14/2017 10 699
8/13/2017 6 689
8/12/2017 9 683
8/11/2017 9 674
8/10/2017 10 665
8/8/2017 10 655
8/7/2017 10 645
8/6/2017 9 635
8/5/2017 10 626
8/3/2017 10 616
8/1/2017 10 606
7/31/2017 9 596
7/30/2017 9 588
7/29/2017 10 578
7/28/2017 9 568
7/27/2017 10 559
7/26/2017 10 549
7/25/2017 10 539
7/24/2017 10 530
7/23/2017 10 520
7/22/2017 9 510
7/21/2017 10 501
7/20/2017 10 491
7/19/2017 9 481
7/18/2017 9 472
7/17/2017 10 463
7/16/2017 10 453
7/15/2017 10 443
7/14/2017 10 433
7/13/2017 7 423
7/12/2017 8 416
7/11/2017 10 408
7/10/2017 10 398
7/9/2017 10 388
7/8/2017 10 378
7/7/2017 10 368
7/6/2017 10 359
7/5/2017 8 349
7/2/2017 3 341
7/1/2017 6 337
6/29/2017 9 331
6/28/2017 10 322
6/27/2017 10 312
6/26/2017 8 302
6/25/2017 6 294
6/24/2017 4 288
6/23/2017 6 284
6/22/2017 8 278
6/21/2017 9 269
6/20/2017 8 260
6/19/2017 8 252
6/18/2017 7 244
6/17/2017 7 237
6/16/2017 8 230
6/15/2017 8 222
6/14/2017 8 214
6/13/2017 9 206
6/12/2017 9 197
6/11/2017 9 188
6/10/2017 10 179
6/9/2017 9 170
6/8/2017 10 161
6/7/2017 9 151
6/6/2017 10 141
6/5/2017 10 132
6/4/2017 10 122
6/3/2017 10 112
6/2/2017 9 102
6/1/2017 10 93
5/31/2017 9 83
5/30/2017 7 75
5/29/2017 2 68
5/28/2017 5 66
5/27/2017 8 61
5/26/2017 8 53
5/25/2017 8 45
5/24/2017 8 37
5/23/2017 8 29
5/22/2017 4 21
5/21/2017 2 17
5/20/2017 6 15
5/19/2017 9 9