P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	9.1423	2017-05-15 00:00:00.0	9.1423	223
2	15.1913	2017-05-16 00:00:00.0	6.0490	223
3	17.2194	2017-05-17 00:00:00.0	2.0281	223
4	17.5031	2017-05-18 00:00:00.0	0.2837	223
5	21.7704	2017-05-19 00:00:00.0	4.2673	223
6	26.7699	2017-05-20 00:00:00.0	4.9995	223
7	27.6087	2017-05-21 00:00:00.0	0.8388	223
8	30.0148	2017-05-22 00:00:00.0	2.4061	223
9	37.1449	2017-05-23 00:00:00.0	7.1301	223
10	45.2464	2017-05-24 00:00:00.0	8.1015	223
11	53.1566	2017-05-25 00:00:00.0	7.9102	223
12	61.9811	2017-05-26 00:00:00.0	8.8245	223
13	70.6015	2017-05-27 00:00:00.0	8.6204	223
14	75.4995	2017-05-28 00:00:00.0	4.8980	223
15	77.0092	2017-05-29 00:00:00.0	1.5097	223
16	82.2087	2017-05-30 00:00:00.0	5.1995	223
17	90.4327	2017-05-31 00:00:00.0	8.2240	223
18	98.9204	2017-06-01 00:00:00.0	8.4877	223
19	107.6562	2017-06-02 00:00:00.0	8.7358	223
20	117.2994	2017-06-03 00:00:00.0	9.6432	223
21	127.1520	2017-06-04 00:00:00.0	9.8526	223
22	137.1508	2017-06-05 00:00:00.0	9.9988	223
23	146.7508	2017-06-06 00:00:00.0	9.6000	223
24	156.6360	2017-06-07 00:00:00.0	9.8852	223
25	166.6176	2017-06-08 00:00:00.0	9.9816	223
26	176.5176	2017-06-09 00:00:00.0	9.9000	223
27	186.4176	2017-06-10 00:00:00.0	9.9000	223
28	196.3763	2017-06-11 00:00:00.0	9.9587	223
29	205.6396	2017-06-12 00:00:00.0	9.2633	223
30	214.6962	2017-06-13 00:00:00.0	9.0566	223
31	224.3773	2017-06-14 00:00:00.0	9.6811	223
32	232.9441	2017-06-15 00:00:00.0	8.5668	223
33	241.3441	2017-06-16 00:00:00.0	8.4000	223
34	248.5502	2017-06-17 00:00:00.0	7.2061	223
35	255.8313	2017-06-18 00:00:00.0	7.2811	223
36	263.6757	2017-06-19 00:00:00.0	7.8444	223
37	272.5961	2017-06-20 00:00:00.0	8.9204	223
38	281.1083	2017-06-21 00:00:00.0	8.5122	223
39	289.7813	2017-06-22 00:00:00.0	8.6730	223
40	296.5971	2017-06-23 00:00:00.0	6.8158	223
41	301.1843	2017-06-24 00:00:00.0	4.5872	223
42	306.7715	2017-06-25 00:00:00.0	5.5872	223
43	315.2281	2017-06-26 00:00:00.0	8.4566	223
44	324.9342	2017-06-27 00:00:00.0	9.7061	223
45	334.3444	2017-06-28 00:00:00.0	9.4102	223
46	343.9153	2017-06-29 00:00:00.0	9.5709	223
47	352.7883	2017-06-30 00:00:00.0	8.8730	223
48	361.4613	2017-07-01 00:00:00.0	8.6730	223
49	370.2858	2017-07-02 00:00:00.0	8.8245	223
50	380.1710	2017-07-03 00:00:00.0	9.8852	223
51	389.6266	2017-07-04 00:00:00.0	9.4556	223
52	399.1809	2017-07-05 00:00:00.0	9.5543	223
53	409.1611	2017-07-06 00:00:00.0	9.9802	223
54	418.9769	2017-07-07 00:00:00.0	9.8158	223
55	428.9749	2017-07-08 00:00:00.0	9.9980	223
56	438.9729	2017-07-09 00:00:00.0	9.9980	223
57	448.9683	2017-07-10 00:00:00.0	9.9954	223
58	458.8030	2017-07-11 00:00:00.0	9.8347	223
59	467.5275	2017-07-12 00:00:00.0	8.7245	223
60	476.6698	2017-07-13 00:00:00.0	9.1423	223
61	486.5392	2017-07-14 00:00:00.0	9.8694	223
62	496.4979	2017-07-15 00:00:00.0	9.9587	223
63	506.4117	2017-07-16 00:00:00.0	9.9138	223
64	515.9660	2017-07-17 00:00:00.0	9.5543	223
65	525.6961	2017-07-18 00:00:00.0	9.7301	223
66	535.0349	2017-07-19 00:00:00.0	9.3388	223
67	544.8507	2017-07-20 00:00:00.0	9.8158	223
68	554.7772	2017-07-21 00:00:00.0	9.9265	223
69	564.3772	2017-07-22 00:00:00.0	9.6000	223
70	574.3155	2017-07-23 00:00:00.0	9.9383	223
71	584.1920	2017-07-24 00:00:00.0	9.8765	223
72	594.1871	2017-07-25 00:00:00.0	9.9951	223
73	604.1871	2017-07-26 00:00:00.0	10.0000	223
74	614.0377	2017-07-27 00:00:00.0	9.8506	223
75	623.6377	2017-07-28 00:00:00.0	9.6000	223
76	631.8550	2017-07-29 00:00:00.0	8.2173	223
77	640.2550	2017-07-30 00:00:00.0	8.4000	223
78	648.4723	2017-07-31 00:00:00.0	8.2173	223
79	658.4213	2017-08-01 00:00:00.0	9.9490	223
80	667.0943	2017-08-02 00:00:00.0	8.6730	223
81	676.3958	2017-08-03 00:00:00.0	9.3015	223
82	685.5381	2017-08-04 00:00:00.0	9.1423	223
83	694.7621	2017-08-05 00:00:00.0	9.2240	223
84	704.2718	2017-08-06 00:00:00.0	9.5097	223
85	714.1718	2017-08-07 00:00:00.0	9.9000	223
86	723.9876	2017-08-08 00:00:00.0	9.8158	223
87	733.2891	2017-08-09 00:00:00.0	9.3015	223
88	742.9952	2017-08-10 00:00:00.0	9.7061	223
89	752.5360	2017-08-11 00:00:00.0	9.5408	223
90	762.3110	2017-08-12 00:00:00.0	9.7750	223
91	772.1962	2017-08-13 00:00:00.0	9.8852	223
92	782.1635	2017-08-14 00:00:00.0	9.9673	223
93	792.0900	2017-08-15 00:00:00.0	9.9265	223
94	801.8431	2017-08-16 00:00:00.0	9.7531	223
95	811.6181	2017-08-17 00:00:00.0	9.7750	223
96	821.4875	2017-08-18 00:00:00.0	9.8694	223
97	831.4566	2017-08-19 00:00:00.0	9.9691	223
98	841.4484	2017-08-20 00:00:00.0	9.9918	223
99	849.5499	2017-08-21 00:00:00.0	8.1015	223
100	857.5249	2017-08-22 00:00:00.0	7.9750	223
101	862.2167	2017-08-23 00:00:00.0	4.6918	223
102	868.7019	2017-08-24 00:00:00.0	6.4852	223
103	878.2116	2017-08-25 00:00:00.0	9.5097	223
104	887.4356	2017-08-26 00:00:00.0	9.2240	223
105	897.3943	2017-08-27 00:00:00.0	9.9587	223
106	907.2449	2017-08-28 00:00:00.0	9.8506	223
107	916.8881	2017-08-29 00:00:00.0	9.6432	223
108	925.9881	2017-08-30 00:00:00.0	9.1000	223
109	935.6432	2017-08-31 00:00:00.0	9.6551	223
110	945.1208	2017-09-01 00:00:00.0	9.4776	223
111	954.6917	2017-09-02 00:00:00.0	9.5709	223
112	964.1693	2017-09-03 00:00:00.0	9.4776	223
113	971.8790	2017-09-04 00:00:00.0	7.7097	223
114	978.2790	2017-09-05 00:00:00.0	6.4000	223
115	983.5770	2017-09-06 00:00:00.0	5.2980	223
116	992.4015	2017-09-07 00:00:00.0	8.8245	223
117	999.8296	2017-09-08 00:00:00.0	7.4281	223
118	1009.2046	2017-09-09 00:00:00.0	9.3750	223
119	1019.0268	2017-09-10 00:00:00.0	9.8222	223
120	1028.9941	2017-09-11 00:00:00.0	9.9673	223
121	1038.2225	2017-09-12 00:00:00.0	9.2284	223
122	1047.6669	2017-09-13 00:00:00.0	9.4444	223
123	1054.8730	2017-09-14 00:00:00.0	7.2061	223
124	1059.0317	2017-09-15 00:00:00.0	4.1587	223
125	1061.0598	2017-09-16 00:00:00.0	2.0281	223
126	1064.6598	2017-09-17 00:00:00.0	3.6000	223
127	1071.7129	2017-09-18 00:00:00.0	7.0531	223
128	1080.4879	2017-09-19 00:00:00.0	8.7750	223
129	1089.4547	2017-09-20 00:00:00.0	8.9668	223
130	1098.8649	2017-09-21 00:00:00.0	9.4102	223
131	1106.7751	2017-09-22 00:00:00.0	7.9102	223
132	1112.5501	2017-09-23 00:00:00.0	5.7750	223
133	1116.7088	2017-09-24 00:00:00.0	4.1587	223
134	1119.7246	2017-09-25 00:00:00.0	3.0158	223
135	1122.2547	2017-09-26 00:00:00.0	2.5301	223
136	1127.1527	2017-09-27 00:00:00.0	4.8980	223
137	1131.3114	2017-09-28 00:00:00.0	4.1587	223
138	1133.8415	2017-09-29 00:00:00.0	2.5301	223
139	1141.2696	2017-09-30 00:00:00.0	7.4281	223
140	1149.2446	2017-10-01 00:00:00.0	7.9750	223
141	1156.5257	2017-10-02 00:00:00.0	7.2811	223
142	1158.2966	2017-10-03 00:00:00.0	1.7709	223
143	1160.9497	2017-10-04 00:00:00.0	2.6531	223
144	1160.9497	2017-10-05 00:00:00.0	0.0000	223
145	1164.7762	2017-10-06 00:00:00.0	3.8265	223
146	1171.3456	2017-10-07 00:00:00.0	6.5694	223
147	1174.3614	2017-10-08 00:00:00.0	3.0158	223
148	1174.3614	2017-10-09 00:00:00.0	0.0000	223
149	1175.8711	2017-10-10 00:00:00.0	1.5097	223
150	1179.3563	2017-10-11 00:00:00.0	3.4852	223
151	1184.3558	2017-10-12 00:00:00.0	4.9995	223
152	1184.3558	2017-10-13 00:00:00.0	0.0000	223
153	1184.3558	2017-10-14 00:00:00.0	0.0000	223
154	1184.3558	2017-10-15 00:00:00.0	0.0000	223
155	1186.7619	2017-10-16 00:00:00.0	2.4061	223
156	1193.0757	2017-10-17 00:00:00.0	6.3138	223
157	1199.9716	2017-10-18 00:00:00.0	6.8959	223
158	1204.5588	2017-10-19 00:00:00.0	4.5872	223
159	1213.8976	2017-10-20 00:00:00.0	9.3388	223
160	1222.8644	2017-10-21 00:00:00.0	8.9668	223
161	1227.0231	2017-10-22 00:00:00.0	4.1587	223
162	1227.0231	2017-10-23 00:00:00.0	0.0000	223
163	1227.0231	2017-10-24 00:00:00.0	0.0000	223
164	1227.0231	2017-10-25 00:00:00.0	0.0000	223
165	1227.0231	2017-10-26 00:00:00.0	0.0000	223
166	1227.0231	2017-10-27 00:00:00.0	0.0000	223
167	1227.0231	2017-10-28 00:00:00.0	0.0000	223
168	1227.0231	2017-10-29 00:00:00.0	0.0000	223
169	1227.0231	2017-10-30 00:00:00.0	0.0000	223
170	1227.0231	2017-10-31 00:00:00.0	0.0000	223

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1227
10/30/2017	0	1227
10/29/2017	0	1227
10/28/2017	0	1227
10/27/2017	0	1227
10/26/2017	0	1227
10/25/2017	0	1227
10/24/2017	0	1227
10/23/2017	0	1227
10/22/2017	4	1227
10/21/2017	9	1223
10/20/2017	9	1214
10/19/2017	5	1205
10/18/2017	7	1200
10/17/2017	6	1193
10/16/2017	2	1187
10/15/2017	0	1184
10/14/2017	0	1184
10/13/2017	0	1184
10/12/2017	5	1184
10/11/2017	3	1179
10/10/2017	2	1176
10/9/2017	0	1174
10/8/2017	3	1174
10/7/2017	7	1171
10/6/2017	4	1165
10/5/2017	0	1161
10/4/2017	3	1161
10/3/2017	2	1158
10/2/2017	7	1157
10/1/2017	8	1149
9/30/2017	7	1141
9/29/2017	3	1134
9/28/2017	4	1131
9/27/2017	5	1127
9/26/2017	3	1122
9/25/2017	3	1120
9/24/2017	4	1117
9/23/2017	6	1113
9/22/2017	8	1107
9/21/2017	9	1099
9/20/2017	9	1089
9/19/2017	9	1080
9/18/2017	7	1072
9/17/2017	4	1065
9/16/2017	2	1061
9/15/2017	4	1059
9/14/2017	7	1055
9/13/2017	9	1048
9/12/2017	9	1038
9/11/2017	10	1029
9/10/2017	10	1019
9/9/2017	9	1009
9/8/2017	7	1000
9/7/2017	9	992
9/6/2017	5	984
9/5/2017	6	978
9/4/2017	8	972
9/3/2017	9	964
9/2/2017	10	955
9/1/2017	9	945
8/31/2017	10	936
8/30/2017	9	926
8/29/2017	10	917
8/28/2017	10	907
8/27/2017	10	897
8/26/2017	9	887
8/25/2017	10	878
8/24/2017	6	869
8/23/2017	5	862
8/22/2017	8	858
8/21/2017	8	850
8/20/2017	10	841
8/19/2017	10	831
8/18/2017	10	821
8/17/2017	10	812
8/16/2017	10	802
8/15/2017	10	792
8/14/2017	10	782
8/13/2017	10	772
8/12/2017	10	762
8/11/2017	10	753
8/10/2017	10	743
8/9/2017	9	733
8/8/2017	10	724
8/7/2017	10	714
8/6/2017	10	704
8/5/2017	9	695
8/4/2017	9	686
8/3/2017	9	676
8/2/2017	9	667
8/1/2017	10	658
7/31/2017	8	648
7/30/2017	8	640
7/29/2017	8	632
7/28/2017	10	624
7/27/2017	10	614
7/26/2017	10	604
7/25/2017	10	594
7/24/2017	10	584
7/23/2017	10	574
7/22/2017	10	564
7/21/2017	10	555
7/20/2017	10	545
7/19/2017	9	535
7/18/2017	10	526
7/17/2017	10	516
7/16/2017	10	506
7/15/2017	10	496
7/14/2017	10	487
7/13/2017	9	477
7/12/2017	9	468
7/11/2017	10	459
7/10/2017	10	449
7/9/2017	10	439
7/8/2017	10	429
7/7/2017	10	419
7/6/2017	10	409
7/5/2017	10	399
7/4/2017	9	390
7/3/2017	10	380
7/2/2017	9	370
7/1/2017	9	361
6/30/2017	9	353
6/29/2017	10	344
6/28/2017	9	334
6/27/2017	10	325
6/26/2017	8	315
6/25/2017	6	307
6/24/2017	5	301
6/23/2017	7	297
6/22/2017	9	290
6/21/2017	9	281
6/20/2017	9	273
6/19/2017	8	264
6/18/2017	7	256
6/17/2017	7	249
6/16/2017	8	241
6/15/2017	9	233
6/14/2017	10	224
6/13/2017	9	215
6/12/2017	9	206
6/11/2017	10	196
6/10/2017	10	186
6/9/2017	10	177
6/8/2017	10	167
6/7/2017	10	157
6/6/2017	10	147
6/5/2017	10	137
6/4/2017	10	127
6/3/2017	10	117
6/2/2017	9	108
6/1/2017	8	99
5/31/2017	8	90
5/30/2017	5	82
5/29/2017	2	77
5/28/2017	5	75
5/27/2017	9	71
5/26/2017	9	62
5/25/2017	8	53
5/24/2017	8	45
5/23/2017	7	37
5/22/2017	2	30
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	15
5/15/2017	9	9

mbpotatoes.ca

Physiological Days