P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	5.8469	2017-06-05 00:00:00.0	5.8469	474
2	15.6691	2017-06-06 00:00:00.0	9.8222	474
3	25.5038	2017-06-07 00:00:00.0	9.8347	474
4	35.4840	2017-06-08 00:00:00.0	9.9802	474
5	45.1121	2017-06-09 00:00:00.0	9.6281	474
6	54.9468	2017-06-10 00:00:00.0	9.8347	474
7	64.8162	2017-06-11 00:00:00.0	9.8694	474
8	74.3259	2017-06-12 00:00:00.0	9.5097	474
9	83.1504	2017-06-13 00:00:00.0	8.8245	474
10	92.4137	2017-06-14 00:00:00.0	9.2633	474
11	101.1887	2017-06-15 00:00:00.0	8.7750	474
12	110.4520	2017-06-16 00:00:00.0	9.2633	474
13	118.3622	2017-06-17 00:00:00.0	7.9102	474
14	125.9331	2017-06-18 00:00:00.0	7.5709	474
15	134.2168	2017-06-19 00:00:00.0	8.2837	474
16	143.0413	2017-06-20 00:00:00.0	8.8245	474
17	152.1413	2017-06-21 00:00:00.0	9.1000	474
18	161.0617	2017-06-22 00:00:00.0	8.9204	474
19	168.4898	2017-06-23 00:00:00.0	7.4281	474
20	172.5388	2017-06-24 00:00:00.0	4.0490	474
21	178.3138	2017-06-25 00:00:00.0	5.7750	474
22	187.0888	2017-06-26 00:00:00.0	8.7750	474
23	197.0378	2017-06-27 00:00:00.0	9.9490	474
24	206.8725	2017-06-28 00:00:00.0	9.8347	474
25	216.3169	2017-06-29 00:00:00.0	9.4444	474
26	225.1414	2017-06-30 00:00:00.0	8.8245	474
27	233.8144	2017-07-01 00:00:00.0	8.6730	474
28	242.5894	2017-07-02 00:00:00.0	8.7750	474
29	252.5848	2017-07-03 00:00:00.0	9.9954	474
30	261.6848	2017-07-04 00:00:00.0	9.1000	474
31	270.7848	2017-07-05 00:00:00.0	9.1000	474
32	280.3391	2017-07-06 00:00:00.0	9.5543	474
33	290.1917	2017-07-07 00:00:00.0	9.8526	474
34	300.0139	2017-07-08 00:00:00.0	9.8222	474
35	309.9349	2017-07-09 00:00:00.0	9.9210	474
36	319.8349	2017-07-10 00:00:00.0	9.9000	474
37	329.8329	2017-07-11 00:00:00.0	9.9980	474
38	338.1166	2017-07-12 00:00:00.0	8.2837	474
39	347.3003	2017-07-13 00:00:00.0	9.1837	474
40	357.2590	2017-07-14 00:00:00.0	9.9587	474
41	367.2544	2017-07-15 00:00:00.0	9.9954	474
42	377.1927	2017-07-16 00:00:00.0	9.9383	474
43	386.9149	2017-07-17 00:00:00.0	9.7222	474
44	396.6210	2017-07-18 00:00:00.0	9.7061	474
45	405.4940	2017-07-19 00:00:00.0	8.8730	474
46	415.4205	2017-07-20 00:00:00.0	9.9265	474
47	425.4021	2017-07-21 00:00:00.0	9.9816	474
48	435.0021	2017-07-22 00:00:00.0	9.6000	474
49	444.9771	2017-07-23 00:00:00.0	9.9750	474
50	454.8277	2017-07-24 00:00:00.0	9.8506	474
51	464.8272	2017-07-25 00:00:00.0	9.9995	474
52	474.8223	2017-07-26 00:00:00.0	9.9951	474
53	484.6988	2017-07-27 00:00:00.0	9.8765	474
54	493.9272	2017-07-28 00:00:00.0	9.2284	474
55	503.6112	2017-07-29 00:00:00.0	9.6840	474
56	512.2668	2017-07-30 00:00:00.0	8.6556	474
57	520.0890	2017-07-31 00:00:00.0	7.8222	474
58	530.0563	2017-08-01 00:00:00.0	9.9673	474
59	537.7660	2017-08-02 00:00:00.0	7.7097	474
60	547.1048	2017-08-03 00:00:00.0	9.3388	474
61	556.6145	2017-08-04 00:00:00.0	9.5097	474
62	565.9160	2017-08-05 00:00:00.0	9.3015	474
63	575.2910	2017-08-06 00:00:00.0	9.3750	474
64	585.1604	2017-08-07 00:00:00.0	9.8694	474
65	594.9762	2017-08-08 00:00:00.0	9.8158	474
66	603.9430	2017-08-09 00:00:00.0	8.9668	474
67	613.6961	2017-08-10 00:00:00.0	9.7531	474
68	623.2961	2017-08-11 00:00:00.0	9.6000	474
69	633.0492	2017-08-12 00:00:00.0	9.7531	474
70	642.8242	2017-08-13 00:00:00.0	9.7750	474
71	652.7380	2017-08-14 00:00:00.0	9.9138	474
72	662.3931	2017-08-15 00:00:00.0	9.6551	474
73	672.2089	2017-08-16 00:00:00.0	9.8158	474
74	682.0048	2017-08-17 00:00:00.0	9.7959	474
75	691.9538	2017-08-18 00:00:00.0	9.9490	474
76	701.7760	2017-08-19 00:00:00.0	9.8222	474
77	711.6286	2017-08-20 00:00:00.0	9.8526	474
78	720.0852	2017-08-21 00:00:00.0	8.4566	474
79	728.9582	2017-08-22 00:00:00.0	8.8730	474
80	735.2720	2017-08-23 00:00:00.0	6.3138	474
81	742.6271	2017-08-24 00:00:00.0	7.3551	474
82	752.1047	2017-08-25 00:00:00.0	9.4776	474
83	761.6144	2017-08-26 00:00:00.0	9.5097	474
84	771.4996	2017-08-27 00:00:00.0	9.8852	474
85	781.2576	2017-08-28 00:00:00.0	9.7580	474
86	790.7638	2017-08-29 00:00:00.0	9.5062	474
87	800.1026	2017-08-30 00:00:00.0	9.3388	474
88	809.5802	2017-08-31 00:00:00.0	9.4776	474
89	819.4328	2017-09-01 00:00:00.0	9.8526	474
90	829.2854	2017-09-02 00:00:00.0	9.8526	474
91	839.1548	2017-09-03 00:00:00.0	9.8694	474
92	847.8793	2017-09-04 00:00:00.0	8.7245	474

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
9/4/2017	9	848
9/3/2017	10	839
9/2/2017	10	829
9/1/2017	10	819
8/31/2017	9	810
8/30/2017	9	800
8/29/2017	10	791
8/28/2017	10	781
8/27/2017	10	771
8/26/2017	10	762
8/25/2017	9	752
8/24/2017	7	743
8/23/2017	6	735
8/22/2017	9	729
8/21/2017	8	720
8/20/2017	10	712
8/19/2017	10	702
8/18/2017	10	692
8/17/2017	10	682
8/16/2017	10	672
8/15/2017	10	662
8/14/2017	10	653
8/13/2017	10	643
8/12/2017	10	633
8/11/2017	10	623
8/10/2017	10	614
8/9/2017	9	604
8/8/2017	10	595
8/7/2017	10	585
8/6/2017	9	575
8/5/2017	9	566
8/4/2017	10	557
8/3/2017	9	547
8/2/2017	8	538
8/1/2017	10	530
7/31/2017	8	520
7/30/2017	9	512
7/29/2017	10	504
7/28/2017	9	494
7/27/2017	10	485
7/26/2017	10	475
7/25/2017	10	465
7/24/2017	10	455
7/23/2017	10	445
7/22/2017	10	435
7/21/2017	10	425
7/20/2017	10	415
7/19/2017	9	405
7/18/2017	10	397
7/17/2017	10	387
7/16/2017	10	377
7/15/2017	10	367
7/14/2017	10	357
7/13/2017	9	347
7/12/2017	8	338
7/11/2017	10	330
7/10/2017	10	320
7/9/2017	10	310
7/8/2017	10	300
7/7/2017	10	290
7/6/2017	10	280
7/5/2017	9	271
7/4/2017	9	262
7/3/2017	10	253
7/2/2017	9	243
7/1/2017	9	234
6/30/2017	9	225
6/29/2017	9	216
6/28/2017	10	207
6/27/2017	10	197
6/26/2017	9	187
6/25/2017	6	178
6/24/2017	4	173
6/23/2017	7	168
6/22/2017	9	161
6/21/2017	9	152
6/20/2017	9	143
6/19/2017	8	134
6/18/2017	8	126
6/17/2017	8	118
6/16/2017	9	110
6/15/2017	9	101
6/14/2017	9	92
6/13/2017	9	83
6/12/2017	10	74
6/11/2017	10	65
6/10/2017	10	55
6/9/2017	10	45
6/8/2017	10	35
6/7/2017	10	26
6/6/2017	10	16
6/5/2017	6	6

mbpotatoes.ca

Physiological Days