P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	8.2240	2017-05-25 00:00:00.0	8.2240	362
2	16.4480	2017-05-26 00:00:00.0	8.2240	362
3	24.8480	2017-05-27 00:00:00.0	8.4000	362
4	30.0475	2017-05-28 00:00:00.0	5.1995	362
5	32.2026	2017-05-29 00:00:00.0	2.1551	362
6	38.8552	2017-05-30 00:00:00.0	6.6526	362
7	47.9975	2017-05-31 00:00:00.0	9.1423	362
8	57.9370	2017-06-01 00:00:00.0	9.9395	362
9	66.5926	2017-06-02 00:00:00.0	8.6556	362
10	76.4691	2017-06-03 00:00:00.0	9.8765	362
11	86.1502	2017-06-04 00:00:00.0	9.6811	362
12	96.1304	2017-06-05 00:00:00.0	9.9802	362
13	105.6401	2017-06-06 00:00:00.0	9.5097	362
14	115.2110	2017-06-07 00:00:00.0	9.5709	362
15	125.1110	2017-06-08 00:00:00.0	9.9000	362
16	134.1676	2017-06-09 00:00:00.0	9.0566	362
17	143.7957	2017-06-10 00:00:00.0	9.6281	362
18	152.9380	2017-06-11 00:00:00.0	9.1423	362
19	161.7625	2017-06-12 00:00:00.0	8.8245	362
20	170.5375	2017-06-13 00:00:00.0	8.7750	362
21	178.2472	2017-06-14 00:00:00.0	7.7097	362
22	185.9569	2017-06-15 00:00:00.0	7.7097	362
23	194.1202	2017-06-16 00:00:00.0	8.1633	362
24	201.5483	2017-06-17 00:00:00.0	7.4281	362
25	208.7544	2017-06-18 00:00:00.0	7.2061	362
26	216.6646	2017-06-19 00:00:00.0	7.9102	362
27	224.7034	2017-06-20 00:00:00.0	8.0388	362
28	233.9274	2017-06-21 00:00:00.0	9.2240	362
29	241.6371	2017-06-22 00:00:00.0	7.7097	362
30	247.0325	2017-06-23 00:00:00.0	5.3954	362
31	251.0815	2017-06-24 00:00:00.0	4.0490	362
32	257.0402	2017-06-25 00:00:00.0	5.9587	362
33	264.9504	2017-06-26 00:00:00.0	7.9102	362
34	274.7662	2017-06-27 00:00:00.0	9.8158	362
35	284.6356	2017-06-28 00:00:00.0	9.8694	362
36	293.6024	2017-06-29 00:00:00.0	8.9668	362
37	301.9447	2017-06-30 00:00:00.0	8.3423	362
38	311.0013	2017-07-01 00:00:00.0	9.0566	362
39	319.6217	2017-07-02 00:00:00.0	8.6204	362
40	329.6019	2017-07-03 00:00:00.0	9.9802	362
41	339.5019	2017-07-04 00:00:00.0	9.9000	362
42	349.5007	2017-07-05 00:00:00.0	9.9988	362
43	359.4594	2017-07-06 00:00:00.0	9.9587	362
44	369.2553	2017-07-07 00:00:00.0	9.7959	362
45	379.2541	2017-07-08 00:00:00.0	9.9988	362
46	389.2529	2017-07-09 00:00:00.0	9.9988	362
47	399.1924	2017-07-10 00:00:00.0	9.9395	362
48	408.8475	2017-07-11 00:00:00.0	9.6551	362
49	418.1490	2017-07-12 00:00:00.0	9.3015	362
50	427.4878	2017-07-13 00:00:00.0	9.3388	362
51	437.4551	2017-07-14 00:00:00.0	9.9673	362
52	447.3816	2017-07-15 00:00:00.0	9.9265	362
53	457.3199	2017-07-16 00:00:00.0	9.9383	362
54	467.2786	2017-07-17 00:00:00.0	9.9587	362
55	475.9516	2017-07-18 00:00:00.0	8.6730	362
56	485.3618	2017-07-19 00:00:00.0	9.4102	362
57	495.0919	2017-07-20 00:00:00.0	9.7301	362
58	505.0735	2017-07-21 00:00:00.0	9.9816	362
59	514.2975	2017-07-22 00:00:00.0	9.2240	362
60	524.0934	2017-07-23 00:00:00.0	9.7959	362
61	533.9156	2017-07-24 00:00:00.0	9.8222	362
62	543.2171	2017-07-25 00:00:00.0	9.3015	362
63	553.2043	2017-07-26 00:00:00.0	9.9872	362
64	563.1994	2017-07-27 00:00:00.0	9.9951	362
65	572.6019	2017-07-28 00:00:00.0	9.4025	362
66	582.3599	2017-07-29 00:00:00.0	9.7580	362
67	591.4599	2017-07-30 00:00:00.0	9.1000	362
68	600.6883	2017-07-31 00:00:00.0	9.2284	362
69	610.4414	2017-08-01 00:00:00.0	9.7531	362
70	617.6475	2017-08-02 00:00:00.0	7.2061	362
71	626.3720	2017-08-03 00:00:00.0	8.7245	362
72	635.7822	2017-08-04 00:00:00.0	9.4102	362
73	645.1210	2017-08-05 00:00:00.0	9.3388	362
74	654.2633	2017-08-06 00:00:00.0	9.1423	362
75	663.9694	2017-08-07 00:00:00.0	9.7061	362
76	673.6245	2017-08-08 00:00:00.0	9.6551	362
77	681.8485	2017-08-09 00:00:00.0	8.2240	362
78	690.8607	2017-08-10 00:00:00.0	9.0122	362
79	700.2357	2017-08-11 00:00:00.0	9.3750	362
80	709.6801	2017-08-12 00:00:00.0	9.4444	362
81	719.2801	2017-08-13 00:00:00.0	9.6000	362
82	729.0760	2017-08-14 00:00:00.0	9.7959	362
83	738.3775	2017-08-15 00:00:00.0	9.3015	362
84	748.1933	2017-08-16 00:00:00.0	9.8158	362
85	757.6035	2017-08-17 00:00:00.0	9.4102	362
86	767.3994	2017-08-18 00:00:00.0	9.7959	362
87	777.3912	2017-08-19 00:00:00.0	9.9918	362
88	786.2642	2017-08-20 00:00:00.0	8.8730	362
89	794.9372	2017-08-21 00:00:00.0	8.6730	362
90	803.2795	2017-08-22 00:00:00.0	8.3423	362
91	810.3326	2017-08-23 00:00:00.0	7.0531	362
92	818.1102	2017-08-24 00:00:00.0	7.7776	362
93	827.7653	2017-08-25 00:00:00.0	9.6551	362
94	837.1403	2017-08-26 00:00:00.0	9.3750	362
95	846.8464	2017-08-27 00:00:00.0	9.7061	362
96	856.8444	2017-08-28 00:00:00.0	9.9980	362
97	866.8117	2017-08-29 00:00:00.0	9.9673	362
98	875.5867	2017-08-30 00:00:00.0	8.7750	362
99	885.5250	2017-08-31 00:00:00.0	9.9383	362
100	895.5204	2017-09-01 00:00:00.0	9.9954	362
101	905.1204	2017-09-02 00:00:00.0	9.6000	362
102	914.6301	2017-09-03 00:00:00.0	9.5097	362
103	922.3398	2017-09-04 00:00:00.0	7.7097	362
104	928.1148	2017-09-05 00:00:00.0	5.7750	362
105	936.2781	2017-09-06 00:00:00.0	8.1633	362
106	944.5021	2017-09-07 00:00:00.0	8.2240	362
107	952.7261	2017-09-08 00:00:00.0	8.2240	362
108	962.1363	2017-09-09 00:00:00.0	9.4102	362
109	972.1235	2017-09-10 00:00:00.0	9.9872	362
110	981.5679	2017-09-11 00:00:00.0	9.4444	362
111	991.4679	2017-09-12 00:00:00.0	9.9000	362
112	1000.0347	2017-09-13 00:00:00.0	8.5668	362
113	1005.4301	2017-09-14 00:00:00.0	5.3954	362
114	1008.2051	2017-09-15 00:00:00.0	2.7750	362
115	1009.0439	2017-09-16 00:00:00.0	0.8388	362
116	1010.4215	2017-09-17 00:00:00.0	1.3776	362
117	1016.0087	2017-09-18 00:00:00.0	5.5872	362
118	1023.5796	2017-09-19 00:00:00.0	7.5709	362
119	1033.3755	2017-09-20 00:00:00.0	9.7959	362
120	1041.4143	2017-09-21 00:00:00.0	8.0388	362
121	1048.1490	2017-09-22 00:00:00.0	6.7347	362
122	1053.5444	2017-09-23 00:00:00.0	5.3954	362
123	1057.1444	2017-09-24 00:00:00.0	3.6000	362
124	1061.0827	2017-09-25 00:00:00.0	3.9383	362
125	1062.9827	2017-09-26 00:00:00.0	1.9000	362
126	1069.6353	2017-09-27 00:00:00.0	6.6526	362
127	1076.0353	2017-09-28 00:00:00.0	6.4000	362
128	1079.0511	2017-09-29 00:00:00.0	3.0158	362
129	1085.4511	2017-09-30 00:00:00.0	6.4000	362
130	1093.1608	2017-10-01 00:00:00.0	7.7097	362
131	1100.3669	2017-10-02 00:00:00.0	7.2061	362
132	1102.8970	2017-10-03 00:00:00.0	2.5301	362
133	1106.6108	2017-10-04 00:00:00.0	3.7138	362
134	1108.7659	2017-10-05 00:00:00.0	2.1551	362
135	1113.8659	2017-10-06 00:00:00.0	5.1000	362
136	1121.1470	2017-10-07 00:00:00.0	7.2811	362
137	1125.0853	2017-10-08 00:00:00.0	3.9383	362
138	1125.0853	2017-10-09 00:00:00.0	0.0000	362
139	1128.1011	2017-10-10 00:00:00.0	3.0158	362
140	1130.5072	2017-10-11 00:00:00.0	2.4061	362
141	1133.5230	2017-10-12 00:00:00.0	3.0158	362
142	1133.5230	2017-10-13 00:00:00.0	0.0000	362
143	1133.5230	2017-10-14 00:00:00.0	0.0000	362
144	1133.5230	2017-10-15 00:00:00.0	0.0000	362
145	1137.5720	2017-10-16 00:00:00.0	4.0490	362
146	1144.7781	2017-10-17 00:00:00.0	7.2061	362
147	1151.8312	2017-10-18 00:00:00.0	7.0531	362
148	1156.0985	2017-10-19 00:00:00.0	4.2673	362
149	1163.7393	2017-10-20 00:00:00.0	7.6408	362
150	1171.5169	2017-10-21 00:00:00.0	7.7776	362
151	1175.4552	2017-10-22 00:00:00.0	3.9383	362
152	1175.4552	2017-10-23 00:00:00.0	0.0000	362
153	1175.4552	2017-10-24 00:00:00.0	0.0000	362
154	1176.2940	2017-10-25 00:00:00.0	0.8388	362
155	1176.2940	2017-10-26 00:00:00.0	0.0000	362
156	1176.2940	2017-10-27 00:00:00.0	0.0000	362
157	1176.2940	2017-10-28 00:00:00.0	0.0000	362
158	1176.2940	2017-10-29 00:00:00.0	0.0000	362
159	1176.2940	2017-10-30 00:00:00.0	0.0000	362
160	1176.2940	2017-10-31 00:00:00.0	0.0000	362

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1176
10/30/2017	0	1176
10/29/2017	0	1176
10/28/2017	0	1176
10/27/2017	0	1176
10/26/2017	0	1176
10/25/2017	1	1176
10/24/2017	0	1175
10/23/2017	0	1175
10/22/2017	4	1175
10/21/2017	8	1172
10/20/2017	8	1164
10/19/2017	4	1156
10/18/2017	7	1152
10/17/2017	7	1145
10/16/2017	4	1138
10/15/2017	0	1134
10/14/2017	0	1134
10/13/2017	0	1134
10/12/2017	3	1134
10/11/2017	2	1131
10/10/2017	3	1128
10/9/2017	0	1125
10/8/2017	4	1125
10/7/2017	7	1121
10/6/2017	5	1114
10/5/2017	2	1109
10/4/2017	4	1107
10/3/2017	3	1103
10/2/2017	7	1100
10/1/2017	8	1093
9/30/2017	6	1085
9/29/2017	3	1079
9/28/2017	6	1076
9/27/2017	7	1070
9/26/2017	2	1063
9/25/2017	4	1061
9/24/2017	4	1057
9/23/2017	5	1054
9/22/2017	7	1048
9/21/2017	8	1041
9/20/2017	10	1033
9/19/2017	8	1024
9/18/2017	6	1016
9/17/2017	1	1010
9/16/2017	1	1009
9/15/2017	3	1008
9/14/2017	5	1005
9/13/2017	9	1000
9/12/2017	10	991
9/11/2017	9	982
9/10/2017	10	972
9/9/2017	9	962
9/8/2017	8	953
9/7/2017	8	945
9/6/2017	8	936
9/5/2017	6	928
9/4/2017	8	922
9/3/2017	10	915
9/2/2017	10	905
9/1/2017	10	896
8/31/2017	10	886
8/30/2017	9	876
8/29/2017	10	867
8/28/2017	10	857
8/27/2017	10	847
8/26/2017	9	837
8/25/2017	10	828
8/24/2017	8	818
8/23/2017	7	810
8/22/2017	8	803
8/21/2017	9	795
8/20/2017	9	786
8/19/2017	10	777
8/18/2017	10	767
8/17/2017	9	758
8/16/2017	10	748
8/15/2017	9	738
8/14/2017	10	729
8/13/2017	10	719
8/12/2017	9	710
8/11/2017	9	700
8/10/2017	9	691
8/9/2017	8	682
8/8/2017	10	674
8/7/2017	10	664
8/6/2017	9	654
8/5/2017	9	645
8/4/2017	9	636
8/3/2017	9	626
8/2/2017	7	618
8/1/2017	10	610
7/31/2017	9	601
7/30/2017	9	591
7/29/2017	10	582
7/28/2017	9	573
7/27/2017	10	563
7/26/2017	10	553
7/25/2017	9	543
7/24/2017	10	534
7/23/2017	10	524
7/22/2017	9	514
7/21/2017	10	505
7/20/2017	10	495
7/19/2017	9	485
7/18/2017	9	476
7/17/2017	10	467
7/16/2017	10	457
7/15/2017	10	447
7/14/2017	10	437
7/13/2017	9	427
7/12/2017	9	418
7/11/2017	10	409
7/10/2017	10	399
7/9/2017	10	389
7/8/2017	10	379
7/7/2017	10	369
7/6/2017	10	359
7/5/2017	10	350
7/4/2017	10	340
7/3/2017	10	330
7/2/2017	9	320
7/1/2017	9	311
6/30/2017	8	302
6/29/2017	9	294
6/28/2017	10	285
6/27/2017	10	275
6/26/2017	8	265
6/25/2017	6	257
6/24/2017	4	251
6/23/2017	5	247
6/22/2017	8	242
6/21/2017	9	234
6/20/2017	8	225
6/19/2017	8	217
6/18/2017	7	209
6/17/2017	7	202
6/16/2017	8	194
6/15/2017	8	186
6/14/2017	8	178
6/13/2017	9	171
6/12/2017	9	162
6/11/2017	9	153
6/10/2017	10	144
6/9/2017	9	134
6/8/2017	10	125
6/7/2017	10	115
6/6/2017	10	106
6/5/2017	10	96
6/4/2017	10	86
6/3/2017	10	76
6/2/2017	9	67
6/1/2017	10	58
5/31/2017	9	48
5/30/2017	7	39
5/29/2017	2	32
5/28/2017	5	30
5/27/2017	8	25
5/26/2017	8	16
5/25/2017	8	8

mbpotatoes.ca

Physiological Days