P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	8.6730	2017-05-15 00:00:00.0	8.6730	235
2	16.1011	2017-05-16 00:00:00.0	7.4281	235
3	16.3848	2017-05-17 00:00:00.0	0.2837	235
4	16.3848	2017-05-18 00:00:00.0	0.0000	235
5	20.6521	2017-05-19 00:00:00.0	4.2673	235
6	27.1373	2017-05-20 00:00:00.0	6.4852	235
7	30.3899	2017-05-21 00:00:00.0	3.2526	235
8	35.4899	2017-05-22 00:00:00.0	5.1000	235
9	43.1307	2017-05-23 00:00:00.0	7.6408	235
10	51.5307	2017-05-24 00:00:00.0	8.4000	235
11	59.1715	2017-05-25 00:00:00.0	7.6408	235
12	67.2103	2017-05-26 00:00:00.0	8.0388	235
13	75.6103	2017-05-27 00:00:00.0	8.4000	235
14	80.7103	2017-05-28 00:00:00.0	5.1000	235
15	82.7384	2017-05-29 00:00:00.0	2.0281	235
16	89.2236	2017-05-30 00:00:00.0	6.4852	235
17	98.2802	2017-05-31 00:00:00.0	9.0566	235
18	104.4086	2017-06-01 00:00:00.0	6.1284	235
19	112.9814	2017-06-02 00:00:00.0	8.5728	235
20	122.8814	2017-06-03 00:00:00.0	9.9000	235
21	132.5365	2017-06-04 00:00:00.0	9.6551	235
22	142.4921	2017-06-05 00:00:00.0	9.9556	235
23	152.4131	2017-06-06 00:00:00.0	9.9210	235
24	161.9539	2017-06-07 00:00:00.0	9.5408	235
25	171.9534	2017-06-08 00:00:00.0	9.9995	235
26	181.7493	2017-06-09 00:00:00.0	9.7959	235
27	191.5840	2017-06-10 00:00:00.0	9.8347	235
28	201.2651	2017-06-11 00:00:00.0	9.6811	235
29	210.5284	2017-06-12 00:00:00.0	9.2633	235
30	219.8672	2017-06-13 00:00:00.0	9.3388	235
31	229.0912	2017-06-14 00:00:00.0	9.2240	235
32	237.8662	2017-06-15 00:00:00.0	8.7750	235
33	245.7106	2017-06-16 00:00:00.0	7.8444	235
34	253.1387	2017-06-17 00:00:00.0	7.4281	235
35	260.3448	2017-06-18 00:00:00.0	7.2061	235
36	268.1224	2017-06-19 00:00:00.0	7.7776	235
37	276.7428	2017-06-20 00:00:00.0	8.6204	235
38	285.4673	2017-06-21 00:00:00.0	8.7245	235
39	294.1403	2017-06-22 00:00:00.0	8.6730	235
40	301.0362	2017-06-23 00:00:00.0	6.8959	235
41	305.8316	2017-06-24 00:00:00.0	4.7954	235
42	312.0581	2017-06-25 00:00:00.0	6.2265	235
43	321.2004	2017-06-26 00:00:00.0	9.1423	235
44	331.1958	2017-06-27 00:00:00.0	9.9954	235
45	341.1341	2017-06-28 00:00:00.0	9.9383	235
46	350.6438	2017-06-29 00:00:00.0	9.5097	235
47	359.5168	2017-06-30 00:00:00.0	8.8730	235
48	368.5290	2017-07-01 00:00:00.0	9.0122	235
49	377.4494	2017-07-02 00:00:00.0	8.9204	235
50	387.4412	2017-07-03 00:00:00.0	9.9918	235
51	397.0412	2017-07-04 00:00:00.0	9.6000	235
52	406.0733	2017-07-05 00:00:00.0	9.0321	235
53	415.8313	2017-07-06 00:00:00.0	9.7580	235
54	425.7007	2017-07-07 00:00:00.0	9.8694	235
55	435.4587	2017-07-08 00:00:00.0	9.7580	235
56	445.4476	2017-07-09 00:00:00.0	9.9889	235
57	455.4032	2017-07-10 00:00:00.0	9.9556	235
58	465.0843	2017-07-11 00:00:00.0	9.6811	235
59	474.0965	2017-07-12 00:00:00.0	9.0122	235
60	483.6965	2017-07-13 00:00:00.0	9.6000	235
61	493.5187	2017-07-14 00:00:00.0	9.8222	235
62	503.5182	2017-07-15 00:00:00.0	9.9995	235
63	513.5054	2017-07-16 00:00:00.0	9.9872	235
64	522.7338	2017-07-17 00:00:00.0	9.2284	235
65	532.5088	2017-07-18 00:00:00.0	9.7750	235
66	542.3047	2017-07-19 00:00:00.0	9.7959	235
67	552.1741	2017-07-20 00:00:00.0	9.8694	235
68	562.1006	2017-07-21 00:00:00.0	9.9265	235
69	571.5782	2017-07-22 00:00:00.0	9.4776	235
70	581.5369	2017-07-23 00:00:00.0	9.9587	235
71	591.1369	2017-07-24 00:00:00.0	9.6000	235
72	601.1320	2017-07-25 00:00:00.0	9.9951	235
73	611.0530	2017-07-26 00:00:00.0	9.9210	235
74	620.8444	2017-07-27 00:00:00.0	9.7914	235
75	629.5802	2017-07-28 00:00:00.0	8.7358	235
76	638.9827	2017-07-29 00:00:00.0	9.4025	235
77	648.0827	2017-07-30 00:00:00.0	9.1000	235
78	655.8000	2017-07-31 00:00:00.0	7.7173	235
79	665.7954	2017-08-01 00:00:00.0	9.9954	235
80	674.5704	2017-08-02 00:00:00.0	8.7750	235
81	683.8719	2017-08-03 00:00:00.0	9.3015	235
82	693.5270	2017-08-04 00:00:00.0	9.6551	235
83	703.1821	2017-08-05 00:00:00.0	9.6551	235
84	712.7530	2017-08-06 00:00:00.0	9.5709	235
85	722.7484	2017-08-07 00:00:00.0	9.9954	235
86	732.4785	2017-08-08 00:00:00.0	9.7301	235
87	741.7800	2017-08-09 00:00:00.0	9.3015	235
88	751.4351	2017-08-10 00:00:00.0	9.6551	235
89	761.2101	2017-08-11 00:00:00.0	9.7750	235
90	771.1101	2017-08-12 00:00:00.0	9.9000	235
91	781.0591	2017-08-13 00:00:00.0	9.9490	235
92	791.0463	2017-08-14 00:00:00.0	9.9872	235
93	800.8621	2017-08-15 00:00:00.0	9.8158	235
94	810.7473	2017-08-16 00:00:00.0	9.8852	235
95	820.5631	2017-08-17 00:00:00.0	9.8158	235
96	830.5626	2017-08-18 00:00:00.0	9.9995	235
97	840.0182	2017-08-19 00:00:00.0	9.4556	235
98	849.9447	2017-08-20 00:00:00.0	9.9265	235
99	858.9115	2017-08-21 00:00:00.0	8.9668	235
100	867.8319	2017-08-22 00:00:00.0	8.9204	235
101	874.8069	2017-08-23 00:00:00.0	6.9750	235
102	881.6227	2017-08-24 00:00:00.0	6.8158	235
103	891.0671	2017-08-25 00:00:00.0	9.4444	235
104	900.5768	2017-08-26 00:00:00.0	9.5097	235
105	910.4620	2017-08-27 00:00:00.0	9.8852	235
106	920.2534	2017-08-28 00:00:00.0	9.7914	235
107	930.2090	2017-08-29 00:00:00.0	9.9556	235
108	939.3927	2017-08-30 00:00:00.0	9.1837	235
109	948.8371	2017-08-31 00:00:00.0	9.4444	235
110	958.7509	2017-09-01 00:00:00.0	9.9138	235
111	968.5856	2017-09-02 00:00:00.0	9.8347	235
112	978.1565	2017-09-03 00:00:00.0	9.5709	235
113	986.7769	2017-09-04 00:00:00.0	8.6204	235
114	993.9830	2017-09-05 00:00:00.0	7.2061	235
115	1001.2641	2017-09-06 00:00:00.0	7.2811	235
116	1010.6743	2017-09-07 00:00:00.0	9.4102	235
117	1018.3151	2017-09-08 00:00:00.0	7.6408	235
118	1027.5391	2017-09-09 00:00:00.0	9.2240	235
119	1037.1391	2017-09-10 00:00:00.0	9.6000	235
120	1047.0978	2017-09-11 00:00:00.0	9.9587	235
121	1056.6521	2017-09-12 00:00:00.0	9.5543	235
122	1065.6643	2017-09-13 00:00:00.0	9.0122	235
123	1072.0643	2017-09-14 00:00:00.0	6.4000	235
124	1076.1133	2017-09-15 00:00:00.0	4.0490	235
125	1078.0133	2017-09-16 00:00:00.0	1.9000	235
126	1081.0291	2017-09-17 00:00:00.0	3.0158	235
127	1086.6163	2017-09-18 00:00:00.0	5.5872	235
128	1094.3939	2017-09-19 00:00:00.0	7.7776	235

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
9/19/2017	8	1094
9/18/2017	6	1087
9/17/2017	3	1081
9/16/2017	2	1078
9/15/2017	4	1076
9/14/2017	6	1072
9/13/2017	9	1066
9/12/2017	10	1057
9/11/2017	10	1047
9/10/2017	10	1037
9/9/2017	9	1028
9/8/2017	8	1018
9/7/2017	9	1011
9/6/2017	7	1001
9/5/2017	7	994
9/4/2017	9	987
9/3/2017	10	978
9/2/2017	10	969
9/1/2017	10	959
8/31/2017	9	949
8/30/2017	9	939
8/29/2017	10	930
8/28/2017	10	920
8/27/2017	10	910
8/26/2017	10	901
8/25/2017	9	891
8/24/2017	7	882
8/23/2017	7	875
8/22/2017	9	868
8/21/2017	9	859
8/20/2017	10	850
8/19/2017	9	840
8/18/2017	10	831
8/17/2017	10	821
8/16/2017	10	811
8/15/2017	10	801
8/14/2017	10	791
8/13/2017	10	781
8/12/2017	10	771
8/11/2017	10	761
8/10/2017	10	751
8/9/2017	9	742
8/8/2017	10	732
8/7/2017	10	723
8/6/2017	10	713
8/5/2017	10	703
8/4/2017	10	694
8/3/2017	9	684
8/2/2017	9	675
8/1/2017	10	666
7/31/2017	8	656
7/30/2017	9	648
7/29/2017	9	639
7/28/2017	9	630
7/27/2017	10	621
7/26/2017	10	611
7/25/2017	10	601
7/24/2017	10	591
7/23/2017	10	582
7/22/2017	9	572
7/21/2017	10	562
7/20/2017	10	552
7/19/2017	10	542
7/18/2017	10	533
7/17/2017	9	523
7/16/2017	10	514
7/15/2017	10	504
7/14/2017	10	494
7/13/2017	10	484
7/12/2017	9	474
7/11/2017	10	465
7/10/2017	10	455
7/9/2017	10	445
7/8/2017	10	435
7/7/2017	10	426
7/6/2017	10	416
7/5/2017	9	406
7/4/2017	10	397
7/3/2017	10	387
7/2/2017	9	377
7/1/2017	9	369
6/30/2017	9	360
6/29/2017	10	351
6/28/2017	10	341
6/27/2017	10	331
6/26/2017	9	321
6/25/2017	6	312
6/24/2017	5	306
6/23/2017	7	301
6/22/2017	9	294
6/21/2017	9	285
6/20/2017	9	277
6/19/2017	8	268
6/18/2017	7	260
6/17/2017	7	253
6/16/2017	8	246
6/15/2017	9	238
6/14/2017	9	229
6/13/2017	9	220
6/12/2017	9	211
6/11/2017	10	201
6/10/2017	10	192
6/9/2017	10	182
6/8/2017	10	172
6/7/2017	10	162
6/6/2017	10	152
6/5/2017	10	142
6/4/2017	10	133
6/3/2017	10	123
6/2/2017	9	113
6/1/2017	6	104
5/31/2017	9	98
5/30/2017	6	89
5/29/2017	2	83
5/28/2017	5	81
5/27/2017	8	76
5/26/2017	8	67
5/25/2017	8	59
5/24/2017	8	52
5/23/2017	8	43
5/22/2017	5	35
5/21/2017	3	30
5/20/2017	6	27
5/19/2017	4	21
5/18/2017	0	16
5/17/2017	0	16
5/16/2017	7	16
5/15/2017	9	9

mbpotatoes.ca

Physiological Days