P-Days

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

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '475') AND ddate < '2017-11-01' ORDER BY ddate ASC

Date	P-Days		Start	End
Date	Daily	Total	Start	End
9/25/2017	4	1106
9/24/2017	3	1102
9/23/2017	5	1098
9/22/2017	7	1093
9/21/2017	8	1086
9/20/2017	9	1078
9/19/2017	9	1069
9/18/2017	6	1061
9/17/2017	4	1055
9/16/2017	2	1051
9/15/2017	4	1049
9/14/2017	8	1045
9/13/2017	10	1038
9/12/2017	8	1028
9/11/2017	10	1020
9/10/2017	10	1010
9/9/2017	9	1000
9/8/2017	8	991
9/7/2017	10	983
9/6/2017	8	973
9/5/2017	8	965
9/4/2017	9	957
9/3/2017	10	948
9/2/2017	10	938
9/1/2017	10	928
8/31/2017	10	918
8/30/2017	10	908
8/29/2017	9	899
8/28/2017	10	889
8/27/2017	10	879
8/26/2017	10	869
8/25/2017	10	860
8/24/2017	8	850
8/23/2017	7	842
8/22/2017	9	835
8/21/2017	8	826
8/20/2017	9	818
8/19/2017	10	808
8/18/2017	10	798
8/17/2017	9	789
8/16/2017	10	779
8/15/2017	9	769
8/14/2017	9	761
8/13/2017	9	751
8/12/2017	9	742
8/11/2017	9	733
8/10/2017	9	724
8/9/2017	8	715
8/8/2017	10	706
8/7/2017	10	697
8/6/2017	9	687
8/5/2017	9	678
8/4/2017	9	670
8/3/2017	9	661
8/2/2017	7	652
8/1/2017	10	645
7/31/2017	9	635
7/30/2017	9	626
7/29/2017	10	617
7/28/2017	10	607
7/27/2017	10	597
7/26/2017	10	587
7/25/2017	10	577
7/24/2017	10	567
7/23/2017	10	557
7/22/2017	9	547
7/21/2017	10	538
7/20/2017	10	528
7/19/2017	9	518
7/18/2017	9	509
7/17/2017	10	500
7/16/2017	10	490
7/15/2017	10	481
7/14/2017	10	471
7/13/2017	9	461
7/12/2017	8	452
7/11/2017	10	444
7/10/2017	10	434
7/9/2017	10	424
7/8/2017	10	414
7/7/2017	10	404
7/6/2017	10	395
7/5/2017	10	385
7/4/2017	9	375
7/3/2017	10	365
7/2/2017	8	356
7/1/2017	9	347
6/30/2017	8	339
6/29/2017	9	331
6/28/2017	10	321
6/27/2017	10	311
6/26/2017	7	302
6/25/2017	5	294
6/24/2017	3	289
6/23/2017	6	286
6/22/2017	8	280
6/21/2017	9	272
6/20/2017	8	263
6/19/2017	8	255
6/18/2017	7	248
6/17/2017	8	240
6/16/2017	8	233
6/15/2017	8	225
6/14/2017	8	216
6/13/2017	9	208
6/12/2017	9	199
6/11/2017	9	191
6/10/2017	9	181
6/9/2017	9	172
6/8/2017	10	163
6/7/2017	9	153
6/6/2017	10	144
6/5/2017	10	134
6/4/2017	10	124
6/3/2017	10	114
6/2/2017	10	105
6/1/2017	10	95
5/31/2017	9	85
5/30/2017	5	76
5/29/2017	3	71
5/28/2017	5	68
5/27/2017	7	63
5/26/2017	6	56
5/25/2017	7	50
5/24/2017	8	43
5/23/2017	7	36
5/22/2017	4	29
5/21/2017	2	24
5/20/2017	5	22
5/19/2017	2	17
5/18/2017	0	15
5/17/2017	0	15
5/16/2017	7	15
5/15/2017	8	8

mbpotatoes.ca

Physiological Days