P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	8.2240	2017-05-15 00:00:00.0	8.2240	246
2	14.2730	2017-05-16 00:00:00.0	6.0490	246
3	14.2730	2017-05-17 00:00:00.0	0.0000	246
4	14.2730	2017-05-18 00:00:00.0	0.0000	246
5	16.9261	2017-05-19 00:00:00.0	2.6531	246
6	21.7215	2017-05-20 00:00:00.0	4.7954	246
7	22.2848	2017-05-21 00:00:00.0	0.5633	246
8	25.3006	2017-05-22 00:00:00.0	3.0158	246
9	31.7006	2017-05-23 00:00:00.0	6.4000	246
10	38.9067	2017-05-24 00:00:00.0	7.2061	246
11	45.5593	2017-05-25 00:00:00.0	6.6526	246
12	51.7858	2017-05-26 00:00:00.0	6.2265	246
13	58.6817	2017-05-27 00:00:00.0	6.8959	246
14	62.6200	2017-05-28 00:00:00.0	3.9383	246
15	64.1297	2017-05-29 00:00:00.0	1.5097	246
16	68.5047	2017-05-30 00:00:00.0	4.3750	246
17	76.8470	2017-05-31 00:00:00.0	8.3423	246
18	86.7608	2017-06-01 00:00:00.0	9.9138	246
19	95.8608	2017-06-02 00:00:00.0	9.1000	246
20	105.8526	2017-06-03 00:00:00.0	9.9918	246
21	115.4235	2017-06-04 00:00:00.0	9.5709	246
22	125.4051	2017-06-05 00:00:00.0	9.9816	246
23	135.3051	2017-06-06 00:00:00.0	9.9000	246
24	144.1781	2017-06-07 00:00:00.0	8.8730	246
25	154.0475	2017-06-08 00:00:00.0	9.8694	246
26	163.5572	2017-06-09 00:00:00.0	9.5097	246
27	173.0016	2017-06-10 00:00:00.0	9.4444	246
28	182.4460	2017-06-11 00:00:00.0	9.4444	246
29	190.9026	2017-06-12 00:00:00.0	8.4566	246
30	199.1863	2017-06-13 00:00:00.0	8.2837	246
31	207.5286	2017-06-14 00:00:00.0	8.3423	246
32	215.1694	2017-06-15 00:00:00.0	7.6408	246
33	223.3934	2017-06-16 00:00:00.0	8.2240	246
34	230.1281	2017-06-17 00:00:00.0	6.7347	246
35	236.2664	2017-06-18 00:00:00.0	6.1383	246
36	243.3965	2017-06-19 00:00:00.0	7.1301	246
37	250.8246	2017-06-20 00:00:00.0	7.4281	246
38	259.5491	2017-06-21 00:00:00.0	8.7245	246
39	266.9772	2017-06-22 00:00:00.0	7.4281	246
40	272.7522	2017-06-23 00:00:00.0	5.7750	246
41	275.2823	2017-06-24 00:00:00.0	2.5301	246
42	279.7639	2017-06-25 00:00:00.0	4.4816	246
43	286.9700	2017-06-26 00:00:00.0	7.2061	246
44	296.4144	2017-06-27 00:00:00.0	9.4444	246
45	306.2302	2017-06-28 00:00:00.0	9.8158	246
46	315.1970	2017-06-29 00:00:00.0	8.9668	246
47	323.2358	2017-06-30 00:00:00.0	8.0388	246
48	331.3373	2017-07-01 00:00:00.0	8.1015	246
49	338.9781	2017-07-02 00:00:00.0	7.6408	246
50	348.7939	2017-07-03 00:00:00.0	9.8158	246
51	358.4371	2017-07-04 00:00:00.0	9.6432	246
52	368.4260	2017-07-05 00:00:00.0	9.9889	246
53	378.4010	2017-07-06 00:00:00.0	9.9750	246
54	387.8454	2017-07-07 00:00:00.0	9.4444	246
55	397.7837	2017-07-08 00:00:00.0	9.9383	246
56	407.7327	2017-07-09 00:00:00.0	9.9490	246
57	417.7077	2017-07-10 00:00:00.0	9.9750	246
58	427.5771	2017-07-11 00:00:00.0	9.8694	246
59	435.3547	2017-07-12 00:00:00.0	7.7776	246
60	443.5180	2017-07-13 00:00:00.0	8.1633	246
61	453.3527	2017-07-14 00:00:00.0	9.8347	246
62	463.0828	2017-07-15 00:00:00.0	9.7301	246
63	472.7639	2017-07-16 00:00:00.0	9.6811	246
64	482.7195	2017-07-17 00:00:00.0	9.9556	246
65	491.6863	2017-07-18 00:00:00.0	8.9668	246
66	500.6067	2017-07-19 00:00:00.0	8.9204	246
67	510.0511	2017-07-20 00:00:00.0	9.4444	246
68	519.8669	2017-07-21 00:00:00.0	9.8158	246
69	529.0092	2017-07-22 00:00:00.0	9.1423	246
70	538.6092	2017-07-23 00:00:00.0	9.6000	246
71	548.6043	2017-07-24 00:00:00.0	9.9951	246
72	558.4569	2017-07-25 00:00:00.0	9.8526	246
73	568.3263	2017-07-26 00:00:00.0	9.8694	246
74	578.2646	2017-07-27 00:00:00.0	9.9383	246
75	588.2641	2017-07-28 00:00:00.0	9.9995	246
76	598.2621	2017-07-29 00:00:00.0	9.9980	246
77	608.0535	2017-07-30 00:00:00.0	9.7914	246
78	617.3424	2017-07-31 00:00:00.0	9.2889	246
79	626.9975	2017-08-01 00:00:00.0	9.6551	246
80	633.8934	2017-08-02 00:00:00.0	6.8959	246
81	642.2934	2017-08-03 00:00:00.0	8.4000	246
82	651.2138	2017-08-04 00:00:00.0	8.9204	246
83	659.7806	2017-08-05 00:00:00.0	8.5668	246
84	668.2372	2017-08-06 00:00:00.0	8.4566	246
85	677.6474	2017-08-07 00:00:00.0	9.4102	246
86	687.1250	2017-08-08 00:00:00.0	9.4776	246
87	695.2883	2017-08-09 00:00:00.0	8.1633	246
88	704.1613	2017-08-10 00:00:00.0	8.8730	246
89	713.1281	2017-08-11 00:00:00.0	8.9668	246
90	722.2281	2017-08-12 00:00:00.0	9.1000	246
91	731.6031	2017-08-13 00:00:00.0	9.3750	246
92	741.1128	2017-08-14 00:00:00.0	9.5097	246
93	750.2128	2017-08-15 00:00:00.0	9.1000	246
94	759.8128	2017-08-16 00:00:00.0	9.6000	246
95	769.1143	2017-08-17 00:00:00.0	9.3015	246
96	778.8204	2017-08-18 00:00:00.0	9.7061	246
97	788.8076	2017-08-19 00:00:00.0	9.9872	246
98	797.9076	2017-08-20 00:00:00.0	9.1000	246
99	805.2627	2017-08-21 00:00:00.0	7.3551	246
100	812.9035	2017-08-22 00:00:00.0	7.6408	246
101	818.7708	2017-08-23 00:00:00.0	5.8673	246
102	826.0519	2017-08-24 00:00:00.0	7.2811	246
103	835.3907	2017-08-25 00:00:00.0	9.3388	246
104	844.7657	2017-08-26 00:00:00.0	9.3750	246
105	854.2433	2017-08-27 00:00:00.0	9.4776	246
106	864.2249	2017-08-28 00:00:00.0	9.9816	246
107	874.2229	2017-08-29 00:00:00.0	9.9980	246
108	883.0959	2017-08-30 00:00:00.0	8.8730	246
109	892.9117	2017-08-31 00:00:00.0	9.8158	246
110	902.8989	2017-09-01 00:00:00.0	9.9872	246
111	912.4086	2017-09-02 00:00:00.0	9.5097	246
112	921.9183	2017-09-03 00:00:00.0	9.5097	246
113	929.6280	2017-09-04 00:00:00.0	7.7097	246
114	935.2152	2017-09-05 00:00:00.0	5.5872	246
115	942.1902	2017-09-06 00:00:00.0	6.9750	246
116	950.6468	2017-09-07 00:00:00.0	8.4566	246
117	957.7769	2017-09-08 00:00:00.0	7.1301	246
118	967.4320	2017-09-09 00:00:00.0	9.6551	246
119	977.4122	2017-09-10 00:00:00.0	9.9802	246
120	987.0933	2017-09-11 00:00:00.0	9.6811	246
121	997.0489	2017-09-12 00:00:00.0	9.9556	246
122	1005.6157	2017-09-13 00:00:00.0	8.5668	246
123	1011.4830	2017-09-14 00:00:00.0	5.8673	246
124	1013.3830	2017-09-15 00:00:00.0	1.9000	246
125	1013.3830	2017-09-16 00:00:00.0	0.0000	246
126	1014.4932	2017-09-17 00:00:00.0	1.1102	246
127	1019.6927	2017-09-18 00:00:00.0	5.1995	246
128	1027.3335	2017-09-19 00:00:00.0	7.6408	246
129	1034.4636	2017-09-20 00:00:00.0	7.1301	246
130	1042.1733	2017-09-21 00:00:00.0	7.7097	246
131	1045.7733	2017-09-22 00:00:00.0	3.6000	246
132	1048.1794	2017-09-23 00:00:00.0	2.4061	246
133	1049.9503	2017-09-24 00:00:00.0	1.7709	246
134	1051.0605	2017-09-25 00:00:00.0	1.1102	246
135	1051.0605	2017-09-26 00:00:00.0	0.0000	246
136	1055.9585	2017-09-27 00:00:00.0	4.8980	246
137	1060.2258	2017-09-28 00:00:00.0	4.2673	246
138	1060.6498	2017-09-29 00:00:00.0	0.4240	246
139	1067.7799	2017-09-30 00:00:00.0	7.1301	246
140	1075.1350	2017-10-01 00:00:00.0	7.3551	246
141	1080.0330	2017-10-02 00:00:00.0	4.8980	246
142	1080.0330	2017-10-03 00:00:00.0	0.0000	246
143	1080.0330	2017-10-04 00:00:00.0	0.0000	246
144	1080.0330	2017-10-05 00:00:00.0	0.0000	246
145	1082.4391	2017-10-06 00:00:00.0	2.4061	246
146	1088.3064	2017-10-07 00:00:00.0	5.8673	246
147	1088.4487	2017-10-08 00:00:00.0	0.1423	246
148	1088.4487	2017-10-09 00:00:00.0	0.0000	246
149	1089.0120	2017-10-10 00:00:00.0	0.5633	246
150	1091.7870	2017-10-11 00:00:00.0	2.7750	246
151	1092.3503	2017-10-12 00:00:00.0	0.5633	246
152	1092.3503	2017-10-13 00:00:00.0	0.0000	246
153	1092.3503	2017-10-14 00:00:00.0	0.0000	246
154	1092.3503	2017-10-15 00:00:00.0	0.0000	246
155	1092.9136	2017-10-16 00:00:00.0	0.5633	246
156	1097.7090	2017-10-17 00:00:00.0	4.7954	246
157	1102.1906	2017-10-18 00:00:00.0	4.4816	246
158	1105.2064	2017-10-19 00:00:00.0	3.0158	246
159	1112.8472	2017-10-20 00:00:00.0	7.6408	246
160	1118.6222	2017-10-21 00:00:00.0	5.7750	246
161	1119.3237	2017-10-22 00:00:00.0	0.7015	246
162	1119.3237	2017-10-23 00:00:00.0	0.0000	246
163	1119.3237	2017-10-24 00:00:00.0	0.0000	246
164	1119.3237	2017-10-25 00:00:00.0	0.0000	246
165	1119.3237	2017-10-26 00:00:00.0	0.0000	246
166	1119.3237	2017-10-27 00:00:00.0	0.0000	246
167	1119.3237	2017-10-28 00:00:00.0	0.0000	246
168	1119.3237	2017-10-29 00:00:00.0	0.0000	246
169	1119.3237	2017-10-30 00:00:00.0	0.0000	246
170	1119.3237	2017-10-31 00:00:00.0	0.0000	246

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1119
10/30/2017	0	1119
10/29/2017	0	1119
10/28/2017	0	1119
10/27/2017	0	1119
10/26/2017	0	1119
10/25/2017	0	1119
10/24/2017	0	1119
10/23/2017	0	1119
10/22/2017	1	1119
10/21/2017	6	1119
10/20/2017	8	1113
10/19/2017	3	1105
10/18/2017	4	1102
10/17/2017	5	1098
10/16/2017	1	1093
10/15/2017	0	1092
10/14/2017	0	1092
10/13/2017	0	1092
10/12/2017	1	1092
10/11/2017	3	1092
10/10/2017	1	1089
10/9/2017	0	1088
10/8/2017	0	1088
10/7/2017	6	1088
10/6/2017	2	1082
10/5/2017	0	1080
10/4/2017	0	1080
10/3/2017	0	1080
10/2/2017	5	1080
10/1/2017	7	1075
9/30/2017	7	1068
9/29/2017	0	1061
9/28/2017	4	1060
9/27/2017	5	1056
9/26/2017	0	1051
9/25/2017	1	1051
9/24/2017	2	1050
9/23/2017	2	1048
9/22/2017	4	1046
9/21/2017	8	1042
9/20/2017	7	1034
9/19/2017	8	1027
9/18/2017	5	1020
9/17/2017	1	1014
9/16/2017	0	1013
9/15/2017	2	1013
9/14/2017	6	1011
9/13/2017	9	1006
9/12/2017	10	997
9/11/2017	10	987
9/10/2017	10	977
9/9/2017	10	967
9/8/2017	7	958
9/7/2017	8	951
9/6/2017	7	942
9/5/2017	6	935
9/4/2017	8	930
9/3/2017	10	922
9/2/2017	10	912
9/1/2017	10	903
8/31/2017	10	893
8/30/2017	9	883
8/29/2017	10	874
8/28/2017	10	864
8/27/2017	9	854
8/26/2017	9	845
8/25/2017	9	835
8/24/2017	7	826
8/23/2017	6	819
8/22/2017	8	813
8/21/2017	7	805
8/20/2017	9	798
8/19/2017	10	789
8/18/2017	10	779
8/17/2017	9	769
8/16/2017	10	760
8/15/2017	9	750
8/14/2017	10	741
8/13/2017	9	732
8/12/2017	9	722
8/11/2017	9	713
8/10/2017	9	704
8/9/2017	8	695
8/8/2017	9	687
8/7/2017	9	678
8/6/2017	8	668
8/5/2017	9	660
8/4/2017	9	651
8/3/2017	8	642
8/2/2017	7	634
8/1/2017	10	627
7/31/2017	9	617
7/30/2017	10	608
7/29/2017	10	598
7/28/2017	10	588
7/27/2017	10	578
7/26/2017	10	568
7/25/2017	10	558
7/24/2017	10	549
7/23/2017	10	539
7/22/2017	9	529
7/21/2017	10	520
7/20/2017	9	510
7/19/2017	9	501
7/18/2017	9	492
7/17/2017	10	483
7/16/2017	10	473
7/15/2017	10	463
7/14/2017	10	453
7/13/2017	8	444
7/12/2017	8	435
7/11/2017	10	428
7/10/2017	10	418
7/9/2017	10	408
7/8/2017	10	398
7/7/2017	9	388
7/6/2017	10	378
7/5/2017	10	368
7/4/2017	10	358
7/3/2017	10	349
7/2/2017	8	339
7/1/2017	8	331
6/30/2017	8	323
6/29/2017	9	315
6/28/2017	10	306
6/27/2017	9	296
6/26/2017	7	287
6/25/2017	4	280
6/24/2017	3	275
6/23/2017	6	273
6/22/2017	7	267
6/21/2017	9	260
6/20/2017	7	251
6/19/2017	7	243
6/18/2017	6	236
6/17/2017	7	230
6/16/2017	8	223
6/15/2017	8	215
6/14/2017	8	208
6/13/2017	8	199
6/12/2017	8	191
6/11/2017	9	182
6/10/2017	9	173
6/9/2017	10	164
6/8/2017	10	154
6/7/2017	9	144
6/6/2017	10	135
6/5/2017	10	125
6/4/2017	10	115
6/3/2017	10	106
6/2/2017	9	96
6/1/2017	10	87
5/31/2017	8	77
5/30/2017	4	69
5/29/2017	2	64
5/28/2017	4	63
5/27/2017	7	59
5/26/2017	6	52
5/25/2017	7	46
5/24/2017	7	39
5/23/2017	6	32
5/22/2017	3	25
5/21/2017	1	22
5/20/2017	5	22
5/19/2017	3	17
5/18/2017	0	14
5/17/2017	0	14
5/16/2017	6	14
5/15/2017	8	8

mbpotatoes.ca

Physiological Days