Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Get Consecutive Records


Get Consecutive Records

Author
Message
mrmnew
mrmnew
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 14
I am needing to get average and total downtime hours from a table. I have two source tables, DOWN (records with recorded downtime hours) and PROD (records with production values). For every record in my DOWN table, I need to get the most recent 7 consecutive records from PROD table whose RECORDDATE is less than the RECORDDATE in DOWN. I am not looking to get the last 7 historical record, mind you, but the most recent 7 historical records from PROD table whose HOURSFLOWED value is >= 18. I hope this makes sense. I have a solution that works, nut I was hoping to get input from the community to see if there is a faster solution. I am including a small set of data for each table - when I run this on a larger set of data (DOWN record count at 450K+ and PROD record count at 4.5 million +), the sql takes a long time to perform.


THE FOLLOWING IS THE SQL THAT BUILDS THE RECORDSET AND INCLUDESMY CURRENT SOLUTION


/*
CREATE TABLES

CREATE TABLE PROD (MASTERID INT,RECORDDATE DATETIME,HOURSFLOWED REAL)
CREATE TABLE DOWN (MASTERID INT,RECORDDATE DATETIME,DAILYDOWNTIME REAL)


*/

/*
POPULATE TABLES


INSERT INTO PROD
SELECT 6166 MASTERID,'05/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/26/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/25/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/24/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/10/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/09/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/08/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/07/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/06/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/05/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/04/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/03/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/02/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/01/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/30/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/29/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/28/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/26/2014' RECORDDATE,22 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/25/2014' RECORDDATE,18 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/24/2014' RECORDDATE,18 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/10/2014' RECORDDATE,11 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/09/2014' RECORDDATE,20 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/08/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/07/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/06/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/05/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/04/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/03/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/02/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/01/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/31/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/30/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/29/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/28/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/26/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/25/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/24/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/10/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/09/2014' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/08/2014' RECORDDATE,12 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/07/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/06/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/05/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/04/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/03/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/02/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/01/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/28/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/26/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/10/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/09/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/08/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/07/2014' RECORDDATE,13 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/23/2014' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/19/2014' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/01/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/14/2013' RECORDDATE,4 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/12/2013' RECORDDATE,14 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/20/2013' RECORDDATE,10 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/14/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/13/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/06/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/01/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/30/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/23/2013' RECORDDATE,10 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/16/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/09/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/02/2013' RECORDDATE,14 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/23/2013' RECORDDATE,15.9167 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/18/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/17/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/16/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/04/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/27/2013' RECORDDATE,12 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/21/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/18/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/05/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/18/2013' RECORDDATE,24 HOURSFLOWED


INSERT INTO DOWN
SELECT 6166 MASTERID,'12/20/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/21/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/22/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/23/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/24/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/25/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/26/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/27/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/28/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/29/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/30/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/31/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/01/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/02/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/05/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/18/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/21/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/27/2013' RECORDDATE,12 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/04/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/16/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/17/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/18/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/23/2013' RECORDDATE,8.08333 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/02/2013' RECORDDATE,10 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/09/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/16/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/23/2013' RECORDDATE,14 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/30/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/31/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/01/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/02/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/06/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/13/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/14/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/20/2013' RECORDDATE,14 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/12/2013' RECORDDATE,10 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/14/2013' RECORDDATE,20 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/28/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/29/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/30/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/31/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/01/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/28/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/29/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/30/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/01/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/02/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/28/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/29/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/30/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/31/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/01/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/02/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/03/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/04/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/05/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/06/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/07/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/08/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/09/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/10/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/11/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/12/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/13/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/14/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/15/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/16/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/17/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/18/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/19/2014' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/20/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/21/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/22/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/23/2014' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/24/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/25/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/26/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/27/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/28/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/29/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/30/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/31/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/01/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/02/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/03/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/04/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/05/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/06/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/07/2014' RECORDDATE,11 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/24/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/25/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/08/2014' RECORDDATE,12 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/09/2014' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/09/2014' RECORDDATE,4 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/10/2014' RECORDDATE,13 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/24/2014' RECORDDATE,6 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/25/2014' RECORDDATE,6 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/26/2014' RECORDDATE,2 DAILYDOWNTIME

*/



/*
CREATE INTERPRETED COLUMNS:
ID: ORDER RECORDS BY RECORDDATE TO USE IN SELF JOIN LATER
INCLUDE: INDICATES WHETHER THE RECORD CAN BE INCLUDE IN THE "CONSECUTIVE RECORD" COUNT
*/
;WITH CTE_PROD AS (
SELECT
ID = ROW_NUMBER() OVER (PARTITION BY MASTERID ORDER BY RECORDDATE DESC)
,INCLUDE = CASE WHEN HOURSFLOWED >= 18 THEN 1 ELSE 0 END
,A.*
FROM PROD A
)

/*
CREATE INTERPRETED COLUMNS:
MIN_DATE: MOST HISTORICAL RECORD WHERE PROD RECORD CAN BE INCLUDED IN THE CONSECUTIVE COUNT
MAX_DATE: LEAST HISTORICAL RECORD WHERE PROD RECORD CAN BE INCLUDED IN THE CONSECUTIVE COUNT
CPD: COUNT OF PROD RECORDS INCLUDED IN THE CONSECUTIVE COUNT
DAY_RNG: NUMBER OF DAYS DIFFERENCE BETWEEN THE MIN AND MAX DAYS
*/

,PROD_DAYS AS (
SELECT DISTINCT
A.MASTERID
,A.ID
,A.RECORDDATE
,CPD = SUM(B.INCLUDE) OVER (PARTITION BY A.MASTERID, A.ID)
,MIN_DATE = MIN(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID)
,MAX_DATE = MAX(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID)
,DAY_RNG = DATEDIFF(DAY,MIN(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID,A.RECORDDATE),MAX(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID,A.RECORDDATE)+1)
FROM CTE_PROD A
LEFT JOIN CTE_PROD B ON A.MASTERID = B.MASTERID AND B.RECORDDATE <= A.RECORDDATE AND B.ID BETWEEN A.ID AND A.ID + 6
)



/*
CREATE INTERPRETED COLUMNS:
MINID: THE BEGINNING ID OF THE FIRST SET OF 7 HISTORICAL RECORDS
*/


,A AS (
SELECT D2.MASTERID
,D2.RECORDDATE
,D2.DAILYDOWNTIME
,MIN(PD2.ID) AS MINID
FROM DOWN D2
LEFT JOIN PROD_DAYS PD2
ON D2.MASTERID = PD2.MASTERID
AND D2.RECORDDATE > PD2.RECORDDATE
AND PD2.CPD >= 7
GROUP BY D2.MASTERID
,D2.RECORDDATE
,D2.DAILYDOWNTIME
)

/*
FINAL SELECT
*/
SELECT DISTINCT
A.MASTERID AS MASTERID
,A.RECORDDATE AS RECORDDATE
,PD.MIN_DATE AS MINDATE
,PD.MAX_DATE AS MAXDATE
,PD.DAY_RNG AS DAY_RNG
,AVG(P.HOURSFLOWED) AS AVG_FLOW_HRS
,SUM(P.HOURSFLOWED) AS SUM_FLOW_HRS
FROM A
LEFT JOIN PROD_DAYS PD ON A.MASTERID = PD.MASTERID AND A.MINID = PD.ID
LEFT JOIN PROD P ON PD.MASTERID = P.MASTERID AND P.RECORDDATE BETWEEN PD.MIN_DATE AND PD.MAX_DATE
GROUP BY
A.MASTERID
,A.RECORDDATE
,PD.MIN_DATE
,PD.MAX_DATE
,A.DAILYDOWNTIME
,PD.DAY_RNG
ORDER BY A.MASTERID,A.RECORDDATE DESC
Nevyn
Nevyn
SSC Eights!
SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)

Group: General Forum Members
Points: 960 Visits: 3149
First tip: if you put all of that in a code block it will give a seperate scrollbar and not make your page so long and hard to read.

At first blush ... it is likely the distincts which are killing your performance. I'll edit later if I have a better suggestion. Edit: actually, the number of windowing functions doesn't help either
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16632 Visits: 17024
mrmnew (5/28/2014)
I am needing to get average and total downtime hours from a table. I have two source tables, DOWN (records with recorded downtime hours) and PROD (records with production values). For every record in my DOWN table, I need to get the most recent 7 consecutive records from PROD table whose RECORDDATE is less than the RECORDDATE in DOWN. I am not looking to get the last 7 historical record, mind you, but the most recent 7 historical records from PROD table whose HOURSFLOWED value is >= 18. I hope this makes sense. I have a solution that works, nut I was hoping to get input from the community to see if there is a faster solution. I am including a small set of data for each table - when I run this on a larger set of data (DOWN record count at 450K+ and PROD record count at 4.5 million +), the sql takes a long time to perform.


THE FOLLOWING IS THE SQL THAT BUILDS THE RECORDSET AND INCLUDESMY CURRENT SOLUTION


/*
CREATE TABLES

CREATE TABLE PROD (MASTERID INT,RECORDDATE DATETIME,HOURSFLOWED REAL)
CREATE TABLE DOWN (MASTERID INT,RECORDDATE DATETIME,DAILYDOWNTIME REAL)


*/

/*
POPULATE TABLES


INSERT INTO PROD
SELECT 6166 MASTERID,'05/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/26/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/25/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/24/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/10/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/09/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/08/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/07/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/06/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/05/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/04/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/03/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/02/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/01/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/30/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/29/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/28/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/26/2014' RECORDDATE,22 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/25/2014' RECORDDATE,18 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/24/2014' RECORDDATE,18 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/10/2014' RECORDDATE,11 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/09/2014' RECORDDATE,20 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/08/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/07/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/06/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/05/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/04/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/03/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/02/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/01/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/31/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/30/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/29/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/28/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/26/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/25/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/24/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/10/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/09/2014' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/08/2014' RECORDDATE,12 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/07/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/06/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/05/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/04/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/03/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/02/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/01/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/28/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/27/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/26/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/23/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/22/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/21/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/20/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/19/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/18/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/17/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/16/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/15/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/14/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/13/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/12/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/11/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/10/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/09/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/08/2014' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/07/2014' RECORDDATE,13 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/23/2014' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/19/2014' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'11/01/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/14/2013' RECORDDATE,4 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/12/2013' RECORDDATE,14 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'10/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'09/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'08/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'07/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/20/2013' RECORDDATE,10 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/14/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/13/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/06/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'06/01/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/30/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/23/2013' RECORDDATE,10 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/16/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/09/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/02/2013' RECORDDATE,14 HOURSFLOWED UNION
SELECT 6166 MASTERID,'05/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/23/2013' RECORDDATE,15.9167 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/18/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/17/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/16/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/04/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'04/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/27/2013' RECORDDATE,12 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/21/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/18/2013' RECORDDATE,0.5 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/05/2013' RECORDDATE,9 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'03/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/18/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/17/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/16/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/15/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/14/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/13/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/12/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/11/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/10/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/09/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/08/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/07/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/06/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/05/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/04/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/03/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/02/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'02/01/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/31/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/30/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/29/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/28/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/27/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/26/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/25/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/24/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/23/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/22/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/21/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/20/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/19/2013' RECORDDATE,24 HOURSFLOWED UNION
SELECT 6166 MASTERID,'01/18/2013' RECORDDATE,24 HOURSFLOWED


INSERT INTO DOWN
SELECT 6166 MASTERID,'12/20/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/21/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/22/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/23/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/24/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/25/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/26/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/27/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/28/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/29/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/30/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/31/2012' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/01/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/02/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/05/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/18/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/21/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/27/2013' RECORDDATE,12 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/04/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/16/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/17/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/18/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/23/2013' RECORDDATE,8.08333 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/02/2013' RECORDDATE,10 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/09/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/16/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/23/2013' RECORDDATE,14 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/30/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'05/31/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/01/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/02/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/06/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/13/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/14/2013' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'06/20/2013' RECORDDATE,14 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/12/2013' RECORDDATE,10 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/14/2013' RECORDDATE,20 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/28/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/29/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/30/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'10/31/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/01/2013' RECORDDATE,15 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/28/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/29/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'11/30/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/01/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/02/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/03/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/04/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/05/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/06/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/07/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/08/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/09/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/10/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/11/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/12/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/13/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/14/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/15/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/16/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/17/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/18/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/19/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/20/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/21/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/22/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/23/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/24/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/25/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/26/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/27/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/28/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/29/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/30/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'12/31/2013' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/01/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/02/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/03/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/04/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/05/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/06/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/07/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/08/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/09/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/10/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/11/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/12/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/13/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/14/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/15/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/16/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/17/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/18/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/19/2014' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/20/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/21/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/22/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/23/2014' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/24/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/25/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/26/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/27/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/28/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/29/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/30/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'01/31/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/01/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/02/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/03/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/04/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/05/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/06/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/07/2014' RECORDDATE,11 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/24/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'02/25/2014' RECORDDATE,24 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/08/2014' RECORDDATE,12 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'03/09/2014' RECORDDATE,23.5 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/09/2014' RECORDDATE,4 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/10/2014' RECORDDATE,13 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/24/2014' RECORDDATE,6 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/25/2014' RECORDDATE,6 DAILYDOWNTIME UNION
SELECT 6166 MASTERID,'04/26/2014' RECORDDATE,2 DAILYDOWNTIME

*/



/*
CREATE INTERPRETED COLUMNS:
ID: ORDER RECORDS BY RECORDDATE TO USE IN SELF JOIN LATER
INCLUDE: INDICATES WHETHER THE RECORD CAN BE INCLUDE IN THE "CONSECUTIVE RECORD" COUNT
*/
;WITH CTE_PROD AS (
SELECT
ID = ROW_NUMBER() OVER (PARTITION BY MASTERID ORDER BY RECORDDATE DESC)
,INCLUDE = CASE WHEN HOURSFLOWED >= 18 THEN 1 ELSE 0 END
,A.*
FROM PROD A
)

/*
CREATE INTERPRETED COLUMNS:
MIN_DATE: MOST HISTORICAL RECORD WHERE PROD RECORD CAN BE INCLUDED IN THE CONSECUTIVE COUNT
MAX_DATE: LEAST HISTORICAL RECORD WHERE PROD RECORD CAN BE INCLUDED IN THE CONSECUTIVE COUNT
CPD: COUNT OF PROD RECORDS INCLUDED IN THE CONSECUTIVE COUNT
DAY_RNG: NUMBER OF DAYS DIFFERENCE BETWEEN THE MIN AND MAX DAYS
*/

,PROD_DAYS AS (
SELECT DISTINCT
A.MASTERID
,A.ID
,A.RECORDDATE
,CPD = SUM(B.INCLUDE) OVER (PARTITION BY A.MASTERID, A.ID)
,MIN_DATE = MIN(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID)
,MAX_DATE = MAX(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID)
,DAY_RNG = DATEDIFF(DAY,MIN(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID,A.RECORDDATE),MAX(B.RECORDDATE) OVER (PARTITION BY A.MASTERID,A.ID,A.RECORDDATE)+1)
FROM CTE_PROD A
LEFT JOIN CTE_PROD B ON A.MASTERID = B.MASTERID AND B.RECORDDATE <= A.RECORDDATE AND B.ID BETWEEN A.ID AND A.ID + 6
)



/*
CREATE INTERPRETED COLUMNS:
MINID: THE BEGINNING ID OF THE FIRST SET OF 7 HISTORICAL RECORDS
*/


,A AS (
SELECT D2.MASTERID
,D2.RECORDDATE
,D2.DAILYDOWNTIME
,MIN(PD2.ID) AS MINID
FROM DOWN D2
LEFT JOIN PROD_DAYS PD2
ON D2.MASTERID = PD2.MASTERID
AND D2.RECORDDATE > PD2.RECORDDATE
AND PD2.CPD >= 7
GROUP BY D2.MASTERID
,D2.RECORDDATE
,D2.DAILYDOWNTIME
)

/*
FINAL SELECT
*/
SELECT DISTINCT
A.MASTERID AS MASTERID
,A.RECORDDATE AS RECORDDATE
,PD.MIN_DATE AS MINDATE
,PD.MAX_DATE AS MAXDATE
,PD.DAY_RNG AS DAY_RNG
,AVG(P.HOURSFLOWED) AS AVG_FLOW_HRS
,SUM(P.HOURSFLOWED) AS SUM_FLOW_HRS
FROM A
LEFT JOIN PROD_DAYS PD ON A.MASTERID = PD.MASTERID AND A.MINID = PD.ID
LEFT JOIN PROD P ON PD.MASTERID = P.MASTERID AND P.RECORDDATE BETWEEN PD.MIN_DATE AND PD.MAX_DATE
GROUP BY
A.MASTERID
,A.RECORDDATE
,PD.MIN_DATE
,PD.MAX_DATE
,A.DAILYDOWNTIME
,PD.DAY_RNG
ORDER BY A.MASTERID,A.RECORDDATE DESC




Do these tables have any indexes? Primary keys? The issue here is that this is too slow right? Can you post the actual execution plan?

Here is an article that explains what information to post for performance issues.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16632 Visits: 17024
One other point of concern. I noticed you are using the REAL datatype. This is not an exact numeric type, it is an approximate datatype so if accuracy is important I would recommend changing to a numeric datatype instead.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Nevyn
Nevyn
SSC Eights!
SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)

Group: General Forum Members
Points: 960 Visits: 3149
This is what I came out with.

No idea if it will perform well. So many iterations and changes as I got to understand the intracacies of your requirement.

I suspect it will be better as it removes redundant distincts and has less windowing, but I'm still grouping a lot so who knows?


;WITH CTE_PROD AS (
SELECT
ROW_NUMBER() OVER (PARTITION BY MASTERID ORDER BY RECORDDATE ASC) rownum,
CASE WHEN HOURSFLOWED >= 18 THEN 1 ELSE 0 END IncludeCurrent
,MasterID,recorddate
FROM PROD A
),
gaps AS (
SELECT
rownum,
MASTERID
FROM CTE_PROD
WHERE IncludeCurrent = 0
),
nearestgapbelow AS (
SELECT
c.rownum,
c.MASTERID,
C.RECORDDATE,
COALESCE(MAX(g.rownum),0) closestGap
FROM CTE_PROD c
LEFT JOIN gaps g
ON c.MASTERID = g.MASTERID
AND c.rownum > g.rownum
WHERE c.IncludeCurrent = 1
GROUP BY c.rownum,c.MASTERID,c.RECORDDATE
),
islands AS (
SELECT c.rownum,c.MasterID, c.RECORDDATE ceilingDate,f.RECORDDATE floorDate, DATEDIFF(day,f.recorddate,c.recorddate)+1 DayRange
FROM nearestgapbelow c
JOIN nearestgapbelow f
ON c.MASTERID=f.MASTERID
AND c.rownum = f.rownum + 6
AND c.closestGap = f.closestGap
),
closestisland AS (
SELECT
d.MASTERID,
d.RECORDDATE,
MAX(i.rownum) rownum
FROM DOWN d
LEFT JOIN islands i
ON d.MASTERID = i.MASTERID
AND d.RECORDDATE > i.ceilingDate
GROUP BY d.MASTERID, d.RECORDDATE
)

SELECT
ci.MASTERID,
ci.RECORDDATE,
i.floorDate,
i.CeilingDate,
i.DayRange,
AVG(p.HOURSFLOWED) AVG_FLOW_HOURS,
SUM(p.HOURSFLOWED) SUM_FLOW_HOURS
FROM closestisland ci
LEFT JOIN islands i
ON ci.MASTERID = i.MASTERID
AND ci.rownum = i.rownum
LEFT JOIN PROD p
ON i.MASTERID = p.MASTERID
AND p.RECORDDATE BETWEEN i.floorDate AND i.ceilingDate
GROUP BY ci.MASTERID,ci.RECORDDATE,i.floorDate,i.ceilingDate,i.DayRange
ORDER BY ci.MASTERID,ci.RECORDDATE DESC


ScottPletcher
ScottPletcher
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3950 Visits: 6686
I'd urge you to add a bit flag to the PROD table to indicate whether a given row has 7 consecutive valid flow values or not, rather than recomputing every time across ~4.5M rows.

If somehow historical PROD table data gets deleted/added/changed, you'd need a trigger to recompute the bit each time when a row(s) were DELETEd, INSERTed or UPDATEd (naturally you'd have to recompute a range of rows around the directly affected row(s)).

Then I think a simple OUTER APPLY could quickly give you the list you need, esp. if the tables are clustered by date -- or (masterid, date) if applicable -- as would seem logical based on table usage so far.

SQL DBA,SQL Server MVP('07, '08, '09)

Prosecutor James Blackburn, in closing argument in the "Fatal Vision" murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."
Nevyn
Nevyn
SSC Eights!
SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)SSC Eights! (960 reputation)

Group: General Forum Members
Points: 960 Visits: 3149
EDIT: Removed this approach as performance was terrible


I did a quick and dirty scale out of the test data (adding copies of the test set for other masterid's), and the first solution I posted looks quicker than the original and far quicker than the attempt I deleted here.

None of them scale all that well though. At 100x the size of the test sample my query took 3 seconds and the original 8 on my home laptop. At 1000x my query took 1:36 to 2:31 for the original.
Michael Meierruth
Michael Meierruth
SSChasing Mays
SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)SSChasing Mays (655 reputation)

Group: General Forum Members
Points: 655 Visits: 2508
I woulld be very curious to know from the OP what kind of environment produces this sort of data.
Although the problem is interesting, what exactly does the query result tell you? What sort of decision can be made?
Instead of 7 consecutive days >18 hours, would you ever ask something different? E.g. 14 consecutive days >12 hous?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search