June 8, 2016 at 9:27 am
Hello,
I have a table that stores date functions as nvarchar that I would like to use in SQL to extract data from another table. When I try this I get error "Conversion failed when converting date and/or time from character string" However if I don't get the date function from the table and just hard code it the query works. I have included test data for both tables below.
--=== this will produce error: Conversion failed when converting date and/or time from character string.
DECLARE @myjfunction nvarchar(10)
DECLARE @mydaterange int
DECLARE @mystartdatecode nvarchar(100)
DECLARE @myenddatecode nvarchar(100)
SET @myjfunction = 'coding'
SET @mydaterange = 3
SET @mystartdatecode = (SELECT startdate FROM #mydaterangetable WHERE (tbldaterangeID = @mydaterange))
SELECT tbluserID, jfunction, time AS PunchIn, timeout AS PunchOut
FROM #myclocktable
WHERE (time >= @mystartdatecode) AND (timeout <= DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)) AND (jfunction = @myjfunction)
--===However if I dont use the #mydaterangetable to look up the code for the date range and just plug it in, the query will work.
DECLARE @myjfunction nvarchar(10)
DECLARE @mydaterange int
DECLARE @mystartdatecode nvarchar(100)
DECLARE @myenddatecode nvarchar(100)
SET @myjfunction = 'coding'
SET @mystartdatecode = DATEADD(day, DATEDIFF(day, -1, getdate()) - 8, 0)
SELECT tbluserID, jfunction, time AS PunchIn, timeout AS PunchOut
FROM #myclocktable
WHERE (time >= @mystartdatecode) AND (timeout <= DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)) AND (jfunction = @myjfunction)
DATA
--===== Create a date range table
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#mydaterangetable','U') IS NOT NULL
DROP TABLE #mydaterangetable
--===== Create the test date range table with
CREATE TABLE #mydaterangetable(
[tbldaterangeID] [int] NOT NULL,
[SelectDate] [nvarchar](50) NULL,
[startdate] [nvarchar](100) NULL,
[enddate] [nvarchar](100) NULL,
CONSTRAINT [PK_tbldaterange] PRIMARY KEY CLUSTERED
(
[tbldaterangeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET DATEFORMAT YMD
GO
--===== Insert the test data into the test date range table
INSERT INTO #mydaterangetable
(tbldaterangeID, SelectDate, startdate, enddate)
SELECT '1','Today','DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)','getdate()' UNION ALL
SELECT '2','Yesterday','DATEADD(day, DATEDIFF(day, -1, getdate()) - 2, 0)','DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)' UNION ALL
SELECT '3','Last 7 days','DATEADD(day, DATEDIFF(day, -1, getdate()) - 8, 0)','DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)' UNION ALL
SELECT '4','Last 14 days','DATEADD(day, DATEDIFF(day, -1, getdate()) - 15, 0) ','DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)' UNION ALL
SELECT '5','This month to date','DATEADD(month, DATEDIFF(month, -1, getdate()) - 1, 0)','getdate()' UNION ALL
SELECT '6','Last Month','DATEADD(month, DATEDIFF(month, 1, getdate()) - 1, 0)','DATEADD(month, DATEDIFF(month, -1, getdate()) - 1, 0) ' UNION ALL
SELECT '7','Last 3 months','DATEADD(month, DATEDIFF(month, 1, getdate()) - 3, 0)','DATEADD(month, DATEDIFF(month, -1, getdate()) - 1, 0)' UNION ALL
SELECT '8','Last 6 months','DATEADD(month, DATEDIFF(month, 1, getdate()) -6, 0)','DATEADD(month, DATEDIFF(month, -1, getdate()) - 1, 0)' UNION ALL
SELECT '9','Last year','DATEADD(month, DATEDIFF(month, 1, getdate()) -12, 0)','DATEADD(month, DATEDIFF(month, -1, getdate()) - 1, 0)'
--===== Create a clock table
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#myclocktable','U') IS NOT NULL
DROP TABLE #myclocktable
--===== Create the test date range table with
CREATE TABLE #myclocktable(
[tblclockID] [int] NOT NULL,
[tbluserID] [int] NULL,
[time] [datetime] NULL,
[timeout] [datetime] NULL,
[jfunction] [nvarchar](50) NULL,
CONSTRAINT [PK_tblclock] PRIMARY KEY CLUSTERED
(
[tblclockID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
--===== Insert the test data into the test clock table
INSERT INTO #myclocktable
(tblclockID, tbluserID, time, timeout, jfunction)
SELECT '53105','3089','May 6 2016 10:02AM','May 6 2016 10:04AM','Coding' UNION ALL
SELECT '53106','3089','May 6 2016 10:06AM','May 6 2016 10:08AM','Coding' UNION ALL
SELECT '53107','3133','May 6 2016 10:09AM','May 6 2016 10:18AM','ACESII' UNION ALL
SELECT '53108','3089','May 6 2016 10:16AM','May 6 2016 10:35AM','Coding' UNION ALL
SELECT '53109','3133','May 6 2016 10:18AM','May 6 2016 10:47AM','Data Entry' UNION ALL
SELECT '53110','3089','May 6 2016 10:38AM','May 6 2016 10:49AM','Coding' UNION ALL
SELECT '53111','3133','May 6 2016 10:47AM','May 6 2016 12:26PM','ACESII' UNION ALL
SELECT '53112','3089','May 6 2016 10:51AM','May 6 2016 10:53AM','Coding' UNION ALL
SELECT '53113','2067','May 6 2016 10:51AM','May 6 2016 12:59PM','Coding' UNION ALL
SELECT '53114','3089','May 6 2016 10:57AM','May 6 2016 11:18AM','Coding' UNION ALL
SELECT '53115','3089','May 6 2016 11:19AM','May 6 2016 11:24AM','Coding' UNION ALL
SELECT '53116','3089','May 6 2016 11:27AM','May 6 2016 11:28AM','Coding' UNION ALL
SELECT '53117','3089','May 6 2016 11:50AM','May 6 2016 11:53AM','Coding' UNION ALL
SELECT '53118','3089','May 6 2016 12:01PM','May 6 2016 12:02PM','Coding' UNION ALL
SELECT '53119','3089','May 6 2016 12:04PM','May 6 2016 12:06PM','Coding' UNION ALL
SELECT '53120','3581','May 6 2016 12:19PM','May 6 2016 2:07PM','Submitting' UNION ALL
SELECT '53121','3133','May 6 2016 12:44PM','May 6 2016 2:35PM','ACESII' UNION ALL
SELECT '53122','3089','May 6 2016 1:23PM','May 6 2016 1:23PM','Coding' UNION ALL
SELECT '53123','3089','May 6 2016 1:33PM','May 6 2016 1:34PM','Coding' UNION ALL
SELECT '53124','3089','May 6 2016 1:38PM','May 6 2016 1:38PM','Coding' UNION ALL
SELECT '53125','3089','May 6 2016 1:46PM','May 6 2016 1:47PM','Coding' UNION ALL
SELECT '53126','3089','May 6 2016 1:54PM','May 6 2016 3:17PM','Coding' UNION ALL
SELECT '53127','4707','May 6 2016 1:54PM','May 6 2016 3:51PM','Data Entry' UNION ALL
SELECT '53128','3133','May 6 2016 2:35PM','May 6 2016 3:00PM','Data Entry' UNION ALL
SELECT '53129','3089','May 6 2016 3:18PM','May 6 2016 3:21PM','Coding' UNION ALL
SELECT '53130','4707','May 6 2016 3:54PM','May 6 2016 6:09PM','Data Entry' UNION ALL
SELECT '53131','4505','May 6 2016 7:19PM','May 6 2016 9:13PM','Submitting' UNION ALL
SELECT '53132','3931','May 7 2016 1:32PM','May 7 2016 1:39PM','Submitting' UNION ALL
SELECT '53133','3931','May 7 2016 1:42PM','May 7 2016 2:02PM','Submitting' UNION ALL
SELECT '53134','3931','May 7 2016 2:02PM','May 7 2016 2:36PM','Submitting' UNION ALL
SELECT '53135','3931','May 7 2016 2:39PM','May 7 2016 3:11PM','Submitting' UNION ALL
SELECT '53136','3931','May 7 2016 3:11PM','May 7 2016 3:53PM','Submitting' UNION ALL
SELECT '53137','3931','May 7 2016 6:36PM','May 7 2016 6:37PM','Submitting' UNION ALL
SELECT '53138','3931','May 7 2016 6:37PM','May 7 2016 6:53PM','Submitting' UNION ALL
SELECT '53139','3931','May 7 2016 6:53PM','May 7 2016 7:29PM','Submitting' UNION ALL
SELECT '53140','4511','May 7 2016 7:19PM','May 7 2016 7:19PM','Submitting' UNION ALL
SELECT '53141','4511','May 7 2016 7:19PM','May 7 2016 8:01PM','Submitting' UNION ALL
SELECT '53142','3931','May 7 2016 7:29PM','May 7 2016 8:11PM','Submitting' UNION ALL
SELECT '53143','1501','May 8 2016 12:15PM','May 8 2016 12:21PM','Coding' UNION ALL
SELECT '53144','3931','May 8 2016 7:25PM','May 8 2016 7:28PM','Submitting' UNION ALL
SELECT '53145','3931','May 8 2016 7:32PM','May 8 2016 8:20PM','Submitting' UNION ALL
SELECT '53146','2067','May 9 2016 6:29AM','May 9 2016 6:34AM','Coding' UNION ALL
SELECT '53147','2067','May 9 2016 6:34AM','May 9 2016 11:43AM','Coding' UNION ALL
SELECT '53148','1501','May 9 2016 6:35AM','May 9 2016 7:49AM','Coding' UNION ALL
SELECT '53149','3089','May 9 2016 7:13AM','May 9 2016 10:12AM','Coding' UNION ALL
SELECT '53150','3931','May 9 2016 9:41AM','May 9 2016 9:41AM','Submitting' UNION ALL
SELECT '53151','3931','May 9 2016 9:41AM','May 9 2016 9:57AM','Submitting' UNION ALL
SELECT '53152','829','May 9 2016 9:44AM','May 9 2016 2:29PM','Submitting' UNION ALL
SELECT '53153','3931','May 9 2016 9:57AM','May 9 2016 11:58AM','Submitting' UNION ALL
SELECT '53154','3669','May 9 2016 9:57AM','May 9 2016 2:02PM','Submitting' UNION ALL
SELECT '53155','3581','May 9 2016 10:03AM','May 9 2016 11:04AM','Data Entry' UNION ALL
SELECT '53156','3089','May 9 2016 10:18AM','May 9 2016 10:51AM','Coding' UNION ALL
SELECT '53157','3089','May 9 2016 10:53AM','May 9 2016 11:46AM','Coding' UNION ALL
SELECT '53158','3581','May 9 2016 11:04AM','May 9 2016 11:59AM','Submitting' UNION ALL
SELECT '53159','3133','May 9 2016 11:12AM','May 9 2016 12:58PM','ACESII' UNION ALL
SELECT '53160','3089','May 9 2016 11:46AM','May 9 2016 11:49AM','Coding' UNION ALL
SELECT '53161','3089','May 9 2016 11:50AM','May 9 2016 1:50PM','Coding' UNION ALL
SELECT '53162','2067','May 9 2016 12:06PM','May 9 2016 12:15PM','Coding' UNION ALL
SELECT '53163','3581','May 9 2016 12:17PM','May 9 2016 1:51PM','Submitting' UNION ALL
SELECT '53164','3133','May 9 2016 1:00PM','May 9 2016 1:58PM','ACESII' UNION ALL
SELECT '53165','2067','May 9 2016 1:02PM','May 9 2016 3:31PM','Coding' UNION ALL
SELECT '53166','4707','May 9 2016 1:49PM','May 9 2016 1:57PM','Data Entry' UNION ALL
SELECT '53167','3089','May 9 2016 1:51PM','May 9 2016 1:51PM','Coding' UNION ALL
SELECT '53168','4707','May 9 2016 1:57PM','May 9 2016 8:09PM','Data Entry' UNION ALL
SELECT '53169','3133','May 9 2016 2:03PM','May 9 2016 4:21PM','ACESII' UNION ALL
SELECT '53170','3669','May 9 2016 2:03PM','May 9 2016 2:03PM','Submitting' UNION ALL
SELECT '53171','3089','May 9 2016 2:11PM','May 9 2016 3:08PM','Coding' UNION ALL
SELECT '53172','3089','May 9 2016 3:09PM','May 9 2016 3:22PM','Coding' UNION ALL
SELECT '53173','3089','May 9 2016 3:23PM','May 9 2016 3:40PM','Coding' UNION ALL
SELECT '53174','3133','May 9 2016 4:21PM','May 9 2016 6:17PM','Data Entry' UNION ALL
SELECT '53175','3133','May 9 2016 6:18PM','May 9 2016 6:18PM','Data Entry' UNION ALL
SELECT '53176','2067','May 10 2016 6:26AM','May 10 2016 11:26AM','Coding' UNION ALL
SELECT '53177','3089','May 10 2016 6:30AM','May 10 2016 1:11PM','Coding' UNION ALL
SELECT '53178','1501','May 10 2016 6:43AM','May 10 2016 8:32AM','Coding' UNION ALL
SELECT '53179','1501','May 10 2016 8:37AM','May 10 2016 12:11PM','Coding' UNION ALL
SELECT '53180','3669','May 10 2016 10:00AM','May 10 2016 2:13PM','Submitting' UNION ALL
SELECT '53181','829','May 10 2016 10:01AM','May 10 2016 10:14AM','Submitting' UNION ALL
SELECT '53182','3931','May 10 2016 10:02AM','May 10 2016 11:25AM','Submitting' UNION ALL
SELECT '53183','829','May 10 2016 10:15AM','May 10 2016 10:38AM','Submitting' UNION ALL
SELECT '53184','3133','May 10 2016 10:20AM','May 10 2016 10:41AM','ACESII' UNION ALL
SELECT '53185','829','May 10 2016 10:41AM','May 10 2016 11:39AM','Submitting' UNION ALL
SELECT '53186','3133','May 10 2016 10:41AM','May 10 2016 10:44AM','Data Entry' UNION ALL
SELECT '53187','3133','May 10 2016 10:44AM','May 10 2016 12:12PM','ACESII' UNION ALL
SELECT '53188','2067','May 10 2016 11:35AM','May 10 2016 1:01PM','Coding' UNION ALL
SELECT '53189','3931','May 10 2016 11:51AM','May 10 2016 12:15PM','Submitting' UNION ALL
SELECT '53190','829','May 10 2016 11:59AM','May 10 2016 1:53PM','Submitting' UNION ALL
SELECT '53191','1501','May 10 2016 12:14PM','May 10 2016 2:04PM','Coding' UNION ALL
SELECT '53192','3931','May 10 2016 12:15PM','May 10 2016 2:07PM','Submitting' UNION ALL
SELECT '53193','3133','May 10 2016 12:37PM','May 10 2016 1:58PM','ACESII' UNION ALL
SELECT '53194','3089','May 10 2016 1:12PM','May 10 2016 1:33PM','Coding' UNION ALL
SELECT '53195','4707','May 10 2016 1:48PM','May 10 2016 5:59PM','Data Entry' UNION ALL
SELECT '53196','829','May 10 2016 1:53PM','May 10 2016 2:13PM','Submitting' UNION ALL
SELECT '53197','2067','May 10 2016 2:00PM','May 10 2016 3:40PM','Coding' UNION ALL
SELECT '53198','3133','May 10 2016 2:07PM','May 10 2016 4:14PM','ACESII' UNION ALL
SELECT '53199','3089','May 10 2016 2:13PM','May 10 2016 3:17PM','Coding' UNION ALL
SELECT '53200','3089','May 10 2016 3:17PM','May 10 2016 3:41PM','Coding' UNION ALL
SELECT '53201','3089','May 10 2016 3:41PM','May 10 2016 3:41PM','Coding' UNION ALL
SELECT '53202','3133','May 10 2016 4:17PM','May 10 2016 5:41PM','Data Entry' UNION ALL
SELECT '53203','1501','May 10 2016 4:20PM','May 10 2016 5:05PM','Coding' UNION ALL
SELECT '53204','4505','May 10 2016 8:24PM','May 10 2016 10:18PM','Submitting' UNION ALL
SELECT '53205','4707','May 10 2016 9:16PM','May 10 2016 10:36PM','Data Entry' UNION ALL
SELECT '53206','4511','May 10 2016 10:07PM','May 10 2016 10:59PM','Submitting' UNION ALL
SELECT '53207','4511','May 10 2016 11:00PM','May 10 2016 11:55PM','Submitting' UNION ALL
SELECT '53208','2067','May 11 2016 6:00AM','May 11 2016 7:24AM','Coding' UNION ALL
SELECT '53209','3089','May 11 2016 6:32AM','May 11 2016 12:34PM','Coding' UNION ALL
SELECT '53210','1501','May 11 2016 6:42AM','May 11 2016 8:48AM','Coding' UNION ALL
SELECT '53211','2067','May 11 2016 7:28AM','May 11 2016 12:59PM','Coding' UNION ALL
SELECT '53212','1501','May 11 2016 8:59AM','May 11 2016 10:43AM','Coding' UNION ALL
SELECT '53213','829','May 11 2016 9:44AM','May 11 2016 2:09PM','Submitting' UNION ALL
SELECT '53214','3581','May 11 2016 9:58AM','May 11 2016 11:59AM','Submitting' UNION ALL
SELECT '53215','3931','May 11 2016 10:00AM','May 11 2016 10:05AM','Submitting' UNION ALL
SELECT '53216','3931','May 11 2016 10:05AM','May 11 2016 10:07AM','Submitting' UNION ALL
SELECT '53217','3931','May 11 2016 10:10AM','May 11 2016 10:20AM','Submitting' UNION ALL
SELECT '53218','3133','May 11 2016 10:16AM','May 11 2016 12:00PM','ACESII' UNION ALL
SELECT '53219','3931','May 11 2016 10:20AM','May 11 2016 12:07PM','Submitting' UNION ALL
SELECT '53220','1501','May 11 2016 10:50AM','May 11 2016 12:13PM','Coding' UNION ALL
SELECT '53221','3931','May 11 2016 12:13PM','May 11 2016 12:17PM','Submitting' UNION ALL
SELECT '53222','1501','May 11 2016 12:18PM','May 11 2016 1:55PM','Coding' UNION ALL
SELECT '53223','3581','May 11 2016 12:25PM','May 11 2016 1:37PM','Submitting' UNION ALL
SELECT '53224','3133','May 11 2016 12:34PM','May 11 2016 12:35PM','ACESII' UNION ALL
SELECT '53225','3931','May 11 2016 12:35PM','May 11 2016 12:46PM','Submitting' UNION ALL
SELECT '53226','3133','May 11 2016 12:35PM','May 11 2016 12:59PM','Data Entry' UNION ALL
SELECT '53227','3089','May 11 2016 12:35PM','May 11 2016 1:35PM','Coding' UNION ALL
SELECT '53228','3931','May 11 2016 12:46PM','May 11 2016 1:07PM','Submitting' UNION ALL
SELECT '53229','3133','May 11 2016 12:59PM','May 11 2016 1:21PM','ACESII' UNION ALL
SELECT '53230','3931','May 11 2016 1:07PM','May 11 2016 1:10PM','Submitting' UNION ALL
SELECT '53231','3931','May 11 2016 1:10PM','May 11 2016 2:11PM','Submitting' UNION ALL
SELECT '53232','3133','May 11 2016 1:21PM','May 11 2016 1:50PM','Data Entry' UNION ALL
SELECT '53233','2067','May 11 2016 1:39PM','May 11 2016 2:57PM','Coding' UNION ALL
SELECT '53234','3133','May 11 2016 1:50PM','May 11 2016 4:05PM','ACESII' UNION ALL
SELECT '53235','4707','May 11 2016 1:52PM','May 11 2016 7:21PM','Data Entry' UNION ALL
SELECT '53236','3931','May 11 2016 2:12PM','May 11 2016 2:33PM','Submitting' UNION ALL
SELECT '53237','3089','May 11 2016 2:13PM','May 11 2016 2:29PM','Coding' UNION ALL
SELECT '53238','3089','May 11 2016 2:29PM','May 11 2016 3:17PM','Coding' UNION ALL
SELECT '53239','3931','May 11 2016 2:33PM','May 11 2016 2:38PM','Submitting' UNION ALL
SELECT '53240','3133','May 11 2016 4:05PM','May 11 2016 4:06PM','Data Entry' UNION ALL
SELECT '53241','3133','May 11 2016 4:06PM','May 11 2016 5:18PM','Data Entry' UNION ALL
SELECT '53242','1501','May 11 2016 5:36PM','May 11 2016 6:06PM','Coding' UNION ALL
SELECT '53243','1501','May 11 2016 6:07PM','May 11 2016 6:20PM','Coding' UNION ALL
SELECT '53244','4505','May 11 2016 8:57PM','May 11 2016 10:00PM','Submitting' UNION ALL
SELECT '53245','4505','May 11 2016 10:06PM','May 11 2016 11:02PM','Submitting' UNION ALL
SELECT '53246','2067','May 12 2016 6:09AM','May 12 2016 2:28PM','Coding' UNION ALL
SELECT '53247','3089','May 12 2016 6:36AM','May 12 2016 10:37AM','Coding' UNION ALL
SELECT '53248','1501','May 12 2016 6:44AM','May 12 2016 8:15AM','Coding' UNION ALL
SELECT '53249','1501','May 12 2016 8:22AM','May 12 2016 11:24AM','Coding' UNION ALL
SELECT '53250','3931','May 12 2016 9:24AM','May 12 2016 10:16AM','Submitting' UNION ALL
SELECT '53251','3669','May 12 2016 9:48AM','May 12 2016 10:39AM','Submitting' UNION ALL
SELECT '53252','829','May 12 2016 9:54AM','May 12 2016 9:59AM','Submitting' UNION ALL
SELECT '53253','829','May 12 2016 10:00AM','May 12 2016 12:13PM','Submitting' UNION ALL
SELECT '53254','3581','May 12 2016 10:03AM','May 12 2016 12:01PM','Submitting' UNION ALL
SELECT '53255','3931','May 12 2016 10:28AM','May 12 2016 10:54AM','Submitting' UNION ALL
SELECT '53256','3669','May 12 2016 10:39AM','May 12 2016 1:58PM','Submitting' UNION ALL
SELECT '53257','3089','May 12 2016 10:40AM','May 12 2016 10:52AM','Coding' UNION ALL
SELECT '53258','3089','May 12 2016 10:52AM','May 12 2016 12:59PM','Coding' UNION ALL
SELECT '53259','3931','May 12 2016 10:54AM','May 12 2016 10:57AM','Submitting' UNION ALL
SELECT '53260','3931','May 12 2016 10:57AM','May 12 2016 11:16AM','Submitting' UNION ALL
SELECT '53261','3133','May 12 2016 10:58AM','May 12 2016 12:17PM','ACESII' UNION ALL
SELECT '53262','3931','May 12 2016 11:16AM','May 12 2016 12:23PM','Submitting' UNION ALL
SELECT '53263','1501','May 12 2016 11:27AM','May 12 2016 1:15PM','Coding' UNION ALL
SELECT '53264','3133','May 12 2016 12:17PM','May 12 2016 1:30PM','Data Entry' UNION ALL
SELECT '53265','3581','May 12 2016 12:20PM','May 12 2016 12:35PM','Submitting' UNION ALL
SELECT '53266','829','May 12 2016 12:23PM','May 12 2016 12:38PM','Submitting' UNION ALL
SELECT '53267','3931','May 12 2016 12:24PM','May 12 2016 12:42PM','Submitting' UNION ALL
SELECT '53268','829','May 12 2016 12:50PM','May 12 2016 2:09PM','Submitting' UNION ALL
SELECT '53269','3089','May 12 2016 1:09PM','May 12 2016 1:18PM','Coding' UNION ALL
SELECT '53270','3931','May 12 2016 1:14PM','May 12 2016 2:15PM','Submitting' UNION ALL
SELECT '53271','1501','May 12 2016 1:15PM','May 12 2016 1:44PM','Coding' UNION ALL
SELECT '53272','3581','May 12 2016 1:25PM','May 12 2016 1:53PM','Submitting' UNION ALL
SELECT '53273','3133','May 12 2016 1:30PM','May 12 2016 3:28PM','ACESII' UNION ALL
SELECT '53274','1501','May 12 2016 1:46PM','May 12 2016 2:03PM','Coding' UNION ALL
SELECT '53275','4707','May 12 2016 1:53PM','May 12 2016 4:26PM','Data Entry' UNION ALL
SELECT '53276','3089','May 12 2016 1:58PM','May 12 2016 2:45PM','Coding' UNION ALL
SELECT '53277','3089','May 12 2016 2:46PM','May 12 2016 3:48PM','Coding' UNION ALL
SELECT '53278','3133','May 12 2016 3:28PM','May 12 2016 4:16PM','ACESII' UNION ALL
SELECT '53279','3133','May 12 2016 4:25PM','May 12 2016 6:12PM','Data Entry' UNION ALL
SELECT '53280','4707','May 12 2016 4:28PM','May 12 2016 5:29PM','Data Entry' UNION ALL
SELECT '53281','4707','May 12 2016 5:29PM','May 12 2016 7:17PM','Data Entry' UNION ALL
SELECT '53282','4505','May 12 2016 5:32PM','May 12 2016 6:00PM','Submitting' UNION ALL
SELECT '53283','4505','May 12 2016 6:07PM','May 12 2016 6:28PM','Submitting' UNION ALL
SELECT '53284','4505','May 12 2016 7:08PM','May 12 2016 7:43PM','Submitting' UNION ALL
SELECT '53285','1501','May 12 2016 8:15PM','May 12 2016 8:53PM','Coding' UNION ALL
SELECT '53286','4511','May 12 2016 11:33PM','May 12 2016 11:42PM','Submitting' UNION ALL
SELECT '53287','4511','May 12 2016 11:42PM','May 12 2016 11:59PM','Submitting' UNION ALL
SELECT '53288','4511','May 13 2016 12:01AM','May 13 2016 1:23AM','Submitting' UNION ALL
SELECT '53289','2067','May 13 2016 5:53AM','May 13 2016 1:35PM','Coding' UNION ALL
SELECT '53290','3089','May 13 2016 6:43AM','May 13 2016 6:49AM','Coding' UNION ALL
SELECT '53291','1501','May 13 2016 6:48AM','May 13 2016 9:18AM','Coding' UNION ALL
SELECT '53292','3089','May 13 2016 6:53AM','May 13 2016 7:15AM','Coding' UNION ALL
SELECT '53293','3089','May 13 2016 7:31AM','May 13 2016 10:42AM','Coding' UNION ALL
SELECT '53294','3931','May 13 2016 9:28AM','May 13 2016 11:29AM','Submitting' UNION ALL
SELECT '53295','1501','May 13 2016 9:28AM','May 13 2016 11:25AM','Coding' UNION ALL
SELECT '53296','3669','May 13 2016 9:52AM','May 13 2016 9:52AM','Submitting' UNION ALL
SELECT '53297','3669','May 13 2016 9:52AM','May 13 2016 2:01PM','Submitting' UNION ALL
SELECT '53298','3133','May 13 2016 10:16AM','May 13 2016 12:33PM','ACESII' UNION ALL
SELECT '53299','3089','May 13 2016 10:42AM','May 13 2016 1:46PM','Coding' UNION ALL
SELECT '53300','1501','May 13 2016 11:30AM','May 13 2016 12:35PM','Coding' UNION ALL
SELECT '53301','3931','May 13 2016 11:50AM','May 13 2016 12:05PM','Submitting' UNION ALL
SELECT '53302','3931','May 13 2016 12:05PM','May 13 2016 1:46PM','Submitting' UNION ALL
SELECT '53303','3133','May 13 2016 12:36PM','May 13 2016 1:17PM','ACESII' UNION ALL
SELECT '53304','1501','May 13 2016 12:39PM','May 13 2016 2:02PM','Coding' UNION ALL
SELECT '53305','3133','May 13 2016 1:24PM','May 13 2016 3:02PM','ACESII' UNION ALL
SELECT '53306','4707','May 13 2016 1:57PM','May 13 2016 3:50PM','Data Entry' UNION ALL
SELECT '53307','3089','May 13 2016 2:19PM','May 13 2016 2:20PM','Coding' UNION ALL
SELECT '53308','3089','May 13 2016 2:20PM','May 13 2016 3:37PM','Coding' UNION ALL
SELECT '53309','3133','May 13 2016 3:02PM','May 13 2016 5:13PM','Data Entry' UNION ALL
SELECT '53310','4707','May 13 2016 3:52PM','May 13 2016 6:55PM','Data Entry' UNION ALL
SELECT '53311','1501','May 13 2016 4:21PM','May 13 2016 5:21PM','Coding' UNION ALL
SELECT '53312','4505','May 13 2016 8:45PM','May 13 2016 10:46PM','Submitting' UNION ALL
SELECT '53313','4511','May 14 2016 5:52PM','May 14 2016 8:28PM','Submitting' UNION ALL
SELECT '53314','288','May 15 2016 1:52PM','May 15 2016 3:01PM','Coding' UNION ALL
SELECT '53315','1501','May 15 2016 2:30PM','May 15 2016 2:30PM','Coding' UNION ALL
SELECT '53325','288','May 15 2016 4:01PM','May 15 2016 4:10PM','Coding' UNION ALL
SELECT '53326','288','May 15 2016 4:11PM','May 15 2016 4:12PM','Coding' UNION ALL
SELECT '53327','3089','May 16 2016 6:28AM','May 16 2016 8:37AM','Coding' UNION ALL
SELECT '53328','2067','May 16 2016 6:32AM','May 16 2016 7:41AM','Coding' UNION ALL
SELECT '53329','1501','May 16 2016 6:43AM','May 16 2016 8:07AM','Coding' UNION ALL
SELECT '53330','2067','May 16 2016 7:52AM','May 16 2016 12:34PM','Coding' UNION ALL
SELECT '53331','288','May 18 2016 8:02AM','May 18 2016 11:59PM','Coding' UNION ALL
SELECT '53332','1501','May 16 2016 8:12AM','May 16 2016 9:34AM','Coding' UNION ALL
SELECT '53333','3089','May 16 2016 8:38AM','May 16 2016 10:28AM','Coding' UNION ALL
SELECT '53334','3931','May 16 2016 9:26AM','May 16 2016 12:53PM','Submitting' UNION ALL
SELECT '53335','1501','May 16 2016 9:37AM','May 16 2016 11:01AM','Coding' UNION ALL
SELECT '53336','3669','May 16 2016 9:48AM','May 16 2016 2:23PM','Submitting' UNION ALL
SELECT '53337','3581','May 16 2016 9:48AM','May 16 2016 9:57AM','Data Entry' UNION ALL
SELECT '53338','3581','May 16 2016 9:57AM','May 16 2016 12:04PM','Submitting' UNION ALL
SELECT '53339','3133','May 16 2016 10:16AM','May 16 2016 12:13PM','ACESII' UNION ALL
SELECT '53340','3089','May 16 2016 10:31AM','May 16 2016 11:27AM','Coding' UNION ALL
SELECT '53341','1501','May 16 2016 11:03AM','May 16 2016 11:04AM','Coding' UNION ALL
SELECT '53342','1501','May 16 2016 11:04AM','May 16 2016 2:17PM','Coding' UNION ALL
SELECT '53343','3089','May 16 2016 11:30AM','May 16 2016 11:56AM','Coding' UNION ALL
SELECT '53344','3089','May 16 2016 11:59AM','May 16 2016 1:26PM','Coding' UNION ALL
SELECT '53345','3133','May 16 2016 12:24PM','May 16 2016 2:47PM','ACESII' UNION ALL
SELECT '53346','3581','May 16 2016 12:24PM','May 16 2016 1:54PM','Submitting' UNION ALL
SELECT '53347','3931','May 16 2016 12:56PM','May 16 2016 1:29PM','Submitting' UNION ALL
SELECT '53348','2067','May 16 2016 1:45PM','May 16 2016 3:46PM','Coding' UNION ALL
SELECT '53349','4707','May 16 2016 1:58PM','May 16 2016 2:02PM','Data Entry' UNION ALL
SELECT '53350','3089','May 16 2016 2:00PM','May 16 2016 2:01PM','Coding' UNION ALL
SELECT '53351','3089','May 16 2016 2:01PM','May 16 2016 3:40PM','Coding' UNION ALL
SELECT '53352','4707','May 16 2016 2:02PM','May 16 2016 5:23PM','Data Entry' UNION ALL
SELECT '53353','3133','May 16 2016 2:47PM','May 16 2016 5:55PM','Data Entry' UNION ALL
SELECT '53354','1501','May 16 2016 5:06PM','May 16 2016 5:50PM','Coding' UNION ALL
SELECT '53355','4707','May 16 2016 5:25PM','May 16 2016 7:30PM','Data Entry' UNION ALL
SELECT '53356','1501','May 16 2016 7:03PM','May 16 2016 8:08PM','Coding' UNION ALL
SELECT '53357','4511','May 16 2016 8:05PM','May 16 2016 8:07PM','Submitting' UNION ALL
SELECT '53358','4511','May 16 2016 8:07PM','May 16 2016 8:39PM','Submitting' UNION ALL
SELECT '53359','4511','May 16 2016 8:41PM','May 16 2016 8:45PM','Submitting' UNION ALL
SELECT '53360','4511','May 16 2016 8:45PM','May 16 2016 9:59PM','Submitting' UNION ALL
SELECT '53362','2067','May 17 2016 5:57AM','May 17 2016 2:01PM','Coding' UNION ALL
SELECT '53363','3089','May 17 2016 6:24AM','May 17 2016 6:38AM','Coding' UNION ALL
SELECT '53364','3089','May 17 2016 6:38AM','May 17 2016 6:45AM','Coding' UNION ALL
SELECT '53365','1501','May 17 2016 6:44AM','May 17 2016 8:54AM','Coding' UNION ALL
SELECT '53366','3089','May 17 2016 6:45AM','May 17 2016 6:49AM','Coding' UNION ALL
SELECT '53367','3089','May 17 2016 6:49AM','May 17 2016 7:26AM','Coding' UNION ALL
SELECT '53368','3089','May 17 2016 7:35AM','May 17 2016 1:34PM','Coding' UNION ALL
SELECT '53375','1501','May 17 2016 9:00AM','May 17 2016 10:00AM','Coding' UNION ALL
SELECT '53377','3931','May 17 2016 9:09AM','May 17 2016 10:18AM','Submitting' UNION ALL
SELECT '62749','3669','May 17 2016 9:48AM','May 17 2016 1:58PM','Submitting' UNION ALL
SELECT '62750','3581','May 17 2016 9:55AM','May 17 2016 11:10AM','Submitting' UNION ALL
SELECT '62751','1501','May 17 2016 10:05AM','May 17 2016 12:00PM','Coding' UNION ALL
SELECT '62752','3133','May 17 2016 10:15AM','May 17 2016 12:03PM','ACESII' UNION ALL
SELECT '62753','3931','May 17 2016 10:22AM','May 17 2016 11:04AM','Submitting' UNION ALL
SELECT '62754','829','May 17 2016 10:29AM','May 17 2016 11:46AM','Submitting' UNION ALL
SELECT '62755','3931','May 17 2016 11:05AM','May 17 2016 11:20AM','Submitting' UNION ALL
SELECT '62756','3581','May 17 2016 11:17AM','May 17 2016 11:53AM','Submitting' UNION ALL
SELECT '62757','3931','May 17 2016 11:20AM','May 17 2016 11:24AM','Submitting' UNION ALL
SELECT '62758','3931','May 17 2016 11:24AM','May 17 2016 1:19PM','Submitting' UNION ALL
SELECT '62759','829','May 17 2016 11:47AM','May 17 2016 11:47AM','Submitting' UNION ALL
SELECT '62760','1501','May 17 2016 12:03PM','May 17 2016 2:03PM','Coding' UNION ALL
SELECT '62761','829','May 17 2016 12:16PM','May 17 2016 12:34PM','Submitting' UNION ALL
SELECT '62762','3581','May 17 2016 12:16PM','May 17 2016 2:04PM','Submitting' UNION ALL
SELECT '62763','3133','May 17 2016 12:36PM','May 17 2016 2:57PM','ACESII' UNION ALL
SELECT '62764','829','May 17 2016 12:36PM','May 17 2016 2:11PM','Submitting' UNION ALL
SELECT '62765','4707','May 17 2016 1:55PM','May 17 2016 2:00PM','Data Entry' UNION ALL
SELECT '62766','4707','May 17 2016 2:00PM','May 17 2016 7:01PM','Data Entry' UNION ALL
SELECT '62767','3089','May 17 2016 2:01PM','May 17 2016 3:13PM','Coding' UNION ALL
SELECT '62768','3133','May 17 2016 2:57PM','May 17 2016 5:05PM','Data Entry' UNION ALL
SELECT '62769','1501','May 17 2016 4:41PM','May 17 2016 5:49PM','Coding' UNION ALL
SELECT '62770','1501','May 17 2016 7:17PM','May 17 2016 7:51PM','Coding' UNION ALL
SELECT '62771','4511','May 17 2016 7:59PM','May 17 2016 9:08PM','Submitting' UNION ALL
SELECT '62772','4505','May 17 2016 8:57PM','May 17 2016 10:35PM','Submitting' UNION ALL
SELECT '62773','4511','May 17 2016 9:09PM','May 17 2016 9:58PM','Submitting' UNION ALL
SELECT '62774','2067','May 18 2016 5:59AM','May 18 2016 6:13AM','Coding' UNION ALL
SELECT '62775','2067','May 18 2016 6:17AM','May 18 2016 9:10AM','Coding' UNION ALL
SELECT '62776','3089','May 18 2016 6:23AM','May 18 2016 9:12AM','Coding' UNION ALL
SELECT '62777','1501','May 18 2016 6:46AM','May 18 2016 7:27AM','Coding' UNION ALL
SELECT '62778','1501','May 18 2016 7:31AM','May 18 2016 7:31AM','Coding' UNION ALL
SELECT '62779','1501','May 18 2016 7:31AM','May 18 2016 8:06AM','Coding' UNION ALL
SELECT '62780','1501','May 18 2016 8:09AM','May 18 2016 8:37AM','Coding' UNION ALL
SELECT '62781','1501','May 18 2016 8:45AM','May 18 2016 8:46AM','Coding' UNION ALL
SELECT '62782','1501','May 18 2016 8:46AM','May 18 2016 9:17AM','Coding' UNION ALL
SELECT '62783','1501','May 18 2016 9:17AM','May 18 2016 9:41AM','Coding' UNION ALL
SELECT '62784','2067','May 18 2016 9:20AM','May 18 2016 1:17PM','Coding' UNION ALL
SELECT '62785','3089','May 18 2016 9:22AM','May 18 2016 1:36PM','Coding' UNION ALL
SELECT '62786','3931','May 18 2016 9:28AM','May 18 2016 11:35AM','Submitting' UNION ALL
SELECT '62787','829','May 18 2016 9:49AM','May 18 2016 9:51AM','Submitting' UNION ALL
SELECT '62788','3669','May 18 2016 9:51AM','May 18 2016 12:08PM','Submitting' UNION ALL
SELECT '62789','829','May 18 2016 9:57AM','May 18 2016 12:15PM','Submitting' UNION ALL
SELECT '62790','3581','May 18 2016 10:00AM','May 18 2016 12:06PM','Submitting' UNION ALL
SELECT '62791','3133','May 18 2016 10:16AM','May 18 2016 12:16PM','ACESII' UNION ALL
SELECT '62792','1501','May 18 2016 9:47AM','May 18 2016 11:40AM','Coding' UNION ALL
SELECT '62793','3931','May 18 2016 11:40AM','May 18 2016 12:02PM','Submitting' UNION ALL
SELECT '62794','1501','May 18 2016 11:47AM','May 18 2016 1:59PM','Coding' UNION ALL
SELECT '62795','3931','May 18 2016 12:02PM','May 18 2016 1:43PM','Submitting' UNION ALL
SELECT '62796','3669','May 18 2016 12:08PM','May 18 2016 2:10PM','Submitting' UNION ALL
SELECT '62797','3581','May 18 2016 12:27PM','May 18 2016 2:05PM','Submitting' UNION ALL
SELECT '62798','829','May 18 2016 12:29PM','May 18 2016 12:54PM','Submitting' UNION ALL
SELECT '62799','3133','May 18 2016 12:41PM','May 18 2016 2:02PM','ACESII' UNION ALL
SELECT '62800','829','May 18 2016 12:57PM','May 18 2016 2:13PM','Submitting' UNION ALL
SELECT '62801','2067','May 18 2016 1:42PM','May 18 2016 2:54PM','Coding' UNION ALL
SELECT '62802','4707','May 18 2016 1:58PM','May 18 2016 7:49PM','Data Entry' UNION ALL
SELECT '62803','3133','May 18 2016 2:07PM','May 18 2016 3:33PM','ACESII' UNION ALL
SELECT '62804','3089','May 18 2016 2:16PM','May 18 2016 3:54PM','Coding' UNION ALL
SELECT '62805','3133','May 18 2016 3:33PM','May 18 2016 5:01PM','Data Entry' UNION ALL
SELECT '62806','1501','May 18 2016 5:10PM','May 18 2016 5:46PM','Coding' UNION ALL
SELECT '62807','1501','May 18 2016 7:42PM','May 18 2016 8:37PM','Coding' UNION ALL
SELECT '62808','4511','May 18 2016 8:00PM','May 18 2016 10:00PM','Submitting' UNION ALL
SELECT '62809','4505','May 18 2016 8:10PM','May 18 2016 9:59PM','Submitting' UNION ALL
SELECT '62810','4505','May 18 2016 10:00PM','May 18 2016 10:08PM','Submitting' UNION ALL
SELECT '62811','2067','May 19 2016 6:28AM','May 19 2016 12:00PM','Coding' UNION ALL
SELECT '62812','3089','May 19 2016 6:30AM','May 19 2016 7:00AM','Coding' UNION ALL
SELECT '62813','1501','May 19 2016 6:38AM','May 19 2016 8:58AM','Coding' UNION ALL
SELECT '62814','3089','May 19 2016 7:04AM','May 19 2016 8:42AM','Coding' UNION ALL
SELECT '62815','3089','May 19 2016 8:42AM','May 19 2016 9:11AM','Coding' UNION ALL
SELECT '62816','1501','May 19 2016 9:06AM','May 19 2016 10:04AM','Coding' UNION ALL
SELECT '62817','3089','May 19 2016 9:11AM','May 19 2016 11:29AM','Coding' UNION ALL
SELECT '62818','3931','May 19 2016 9:30AM','May 19 2016 1:39PM','Submitting' UNION ALL
SELECT '62819','3581','May 19 2016 9:46AM','May 19 2016 11:58AM','Submitting' UNION ALL
SELECT '62820','3669','May 19 2016 9:58AM','May 19 2016 12:00PM','Submitting' UNION ALL
SELECT '62821','829','May 19 2016 10:00AM','May 19 2016 11:09AM','Submitting' UNION ALL
SELECT '62822','1501','May 19 2016 10:07AM','May 19 2016 11:07AM','Coding' UNION ALL
SELECT '62823','3133','May 19 2016 10:14AM','May 19 2016 12:26PM','ACESII' UNION ALL
SELECT '62824','1501','May 19 2016 11:14AM','May 19 2016 2:15PM','Coding' UNION ALL
SELECT '62825','829','May 19 2016 11:28AM','May 19 2016 11:41AM','Submitting' UNION ALL
SELECT '62826','3089','May 19 2016 11:35AM','May 19 2016 1:31PM','Coding' UNION ALL
SELECT '62827','829','May 19 2016 12:00PM','May 19 2016 12:44PM','Submitting' UNION ALL
SELECT '62828','3581','May 19 2016 12:27PM','May 19 2016 2:04PM','Submitting' UNION ALL
SELECT '62829','829','May 19 2016 12:52PM','May 19 2016 2:10PM','Submitting' UNION ALL
SELECT '62830','3133','May 19 2016 1:00PM','May 19 2016 3:24PM','ACESII' UNION ALL
SELECT '62831','2067','May 19 2016 1:02PM','May 19 2016 3:52PM','Coding' UNION ALL
SELECT '62832','4707','May 19 2016 1:58PM','May 19 2016 6:00PM','Data Entry' UNION ALL
SELECT '62833','3089','May 19 2016 2:06PM','May 19 2016 3:18PM','Coding' UNION ALL
SELECT '62834','3133','May 19 2016 3:24PM','May 19 2016 4:23PM','Data Entry' UNION ALL
SELECT '62835','288','May 18 2016 12:00AM','May 18 2016 11:59PM','Coding' UNION ALL
SELECT '62837','288','May 19 2016 12:00AM','May 19 2016 11:59PM','Coding' UNION ALL
SELECT '62839','1501','May 19 2016 4:38PM','May 19 2016 5:24PM','Coding' UNION ALL
SELECT '62840','4505','May 19 2016 6:56PM','May 19 2016 8:56PM','Submitting' UNION ALL
SELECT '62841','4707','May 19 2016 8:04PM','May 19 2016 8:57PM','Data Entry' UNION ALL
SELECT '62842','1501','May 19 2016 9:10PM','May 19 2016 10:11PM','Coding' UNION ALL
SELECT '62843','2067','May 20 2016 5:02AM','May 20 2016 10:17AM','Coding' UNION ALL
SELECT '62844','3089','May 20 2016 6:11AM','May 20 2016 8:26AM','Coding' UNION ALL
SELECT '62845','1501','May 20 2016 6:50AM','May 20 2016 8:40AM','Coding' UNION ALL
SELECT '62846','288','May 20 2016 12:00AM','May 20 2016 11:59PM','Coding' UNION ALL
SELECT '62847','643','May 20 2016 12:00AM','May 20 2016 11:59PM','Coding' UNION ALL
SELECT '62848','3089','May 20 2016 8:30AM','May 20 2016 8:31AM','Coding' UNION ALL
SELECT '62849','3089','May 20 2016 8:32AM','May 20 2016 8:36AM','Coding' UNION ALL
SELECT '62850','3089','May 20 2016 8:38AM','May 20 2016 8:49AM','Coding' UNION ALL
SELECT '62851','1501','May 20 2016 8:46AM','May 20 2016 8:47AM','Coding' UNION ALL
SELECT '62852','3089','May 20 2016 8:49AM','May 20 2016 12:31PM','Coding' UNION ALL
SELECT '62853','1501','May 20 2016 8:51AM','May 20 2016 9:49AM','Coding' UNION ALL
SELECT '62854','1501','May 20 2016 9:55AM','May 20 2016 11:55AM','Coding' UNION ALL
SELECT '62855','3669','May 20 2016 9:56AM','May 20 2016 2:12PM','Submitting' UNION ALL
SELECT '62856','3931','May 20 2016 10:03AM','May 20 2016 10:05AM','Submitting' UNION ALL
SELECT '62857','3931','May 20 2016 10:05AM','May 20 2016 12:30PM','Submitting' UNION ALL
SELECT '62858','3581','May 20 2016 10:06AM','May 20 2016 12:02PM','Submitting' UNION ALL
SELECT '62859','3133','May 20 2016 10:08AM','May 20 2016 12:01PM','ACESII' UNION ALL
SELECT '62860','2067','May 20 2016 10:23AM','May 20 2016 1:07PM','Coding' UNION ALL
SELECT '62861','1501','May 20 2016 11:55AM','May 20 2016 2:47PM','Coding' UNION ALL
SELECT '62862','3581','May 20 2016 12:26PM','May 20 2016 2:00PM','Submitting' UNION ALL
SELECT '62863','3089','May 20 2016 12:31PM','May 20 2016 12:32PM','Coding' UNION ALL
SELECT '62864','3089','May 20 2016 12:32PM','May 20 2016 12:47PM','Coding' UNION ALL
SELECT '62865','3931','May 20 2016 12:33PM','May 20 2016 1:16PM','Submitting' UNION ALL
SELECT '62866','3133','May 20 2016 12:42PM','May 20 2016 2:46PM','ACESII' UNION ALL
SELECT '62867','3089','May 20 2016 12:47PM','May 20 2016 1:10PM','Coding' UNION ALL
SELECT '62868','3089','May 20 2016 1:19PM','May 20 2016 1:19PM','Coding' UNION ALL
SELECT '62869','4707','May 20 2016 1:50PM','May 20 2016 1:51PM','Data Entry' UNION ALL
SELECT '62870','4707','May 20 2016 1:51PM','May 20 2016 2:29PM','Data Entry' UNION ALL
SELECT '62871','3089','May 20 2016 2:08PM','May 20 2016 3:03PM','Coding' UNION ALL
SELECT '62872','4707','May 20 2016 2:29PM','May 20 2016 6:00PM','Data Entry' UNION ALL
SELECT '62873','3133','May 20 2016 2:53PM','May 20 2016 3:05PM','ACESII' UNION ALL
SELECT '62874','3089','May 20 2016 3:03PM','May 20 2016 3:13PM','Coding' UNION ALL
SELECT '62875','3133','May 20 2016 3:05PM','May 20 2016 5:59PM','Data Entry' UNION ALL
SELECT '62876','3089','May 20 2016 3:22PM','May 20 2016 3:22PM','Coding' UNION ALL
SELECT '62877','4505','May 20 2016 6:59PM','May 20 2016 8:08PM','Submitting' UNION ALL
SELECT '62878','4505','May 20 2016 8:53PM','May 20 2016 9:56PM','Submitting' UNION ALL
SELECT '62879','288','May 21 2016 12:00AM','May 21 2016 11:59PM','Coding' UNION ALL
SELECT '62880','643','May 21 2016 12:00AM','May 21 2016 11:59PM','Coding' UNION ALL
SELECT '62881','4511','May 21 2016 2:57PM','May 21 2016 5:15PM','Submitting' UNION ALL
SELECT '62882','288','May 22 2016 12:00AM','May 22 2016 11:59PM','Coding' UNION ALL
SELECT '62883','643','May 22 2016 12:00AM','May 22 2016 11:59PM','Coding' UNION ALL
SELECT '62884','288','May 23 2016 12:00AM','May 23 2016 11:59PM','Coding' UNION ALL
SELECT '62885','643','May 23 2016 12:00AM','May 23 2016 11:59PM','Coding' UNION ALL
SELECT '62886','4707','May 23 2016 5:47PM','May 23 2016 7:30PM','Data Entry' UNION ALL
SELECT '62887','288','May 24 2016 12:00AM','May 25 2016 12:00AM','Coding' UNION ALL
SELECT '62888','643','May 24 2016 12:00AM','May 25 2016 12:00AM','Coding' UNION ALL
SELECT '62889','2067','May 24 2016 6:30AM','May 24 2016 1:03PM','Coding' UNION ALL
SELECT '62890','3089','May 24 2016 6:37AM','May 24 2016 9:00AM','Coding' UNION ALL
SELECT '62891','3089','May 24 2016 9:08AM','May 24 2016 9:24AM','Coding' UNION ALL
SELECT '62892','3089','May 24 2016 9:25AM','May 24 2016 10:57AM','Coding' UNION ALL
SELECT '62893','3931','May 24 2016 9:35AM','May 24 2016 11:08AM','Submitting' UNION ALL
SELECT '62894','829','May 24 2016 9:45AM','May 24 2016 10:08AM','Submitting' UNION ALL
SELECT '62895','3669','May 24 2016 9:49AM','May 24 2016 1:48PM','Submitting' UNION ALL
SELECT '62896','3581','May 24 2016 10:02AM','May 24 2016 11:57AM','Submitting' UNION ALL
SELECT '62897','3133','May 24 2016 10:13AM','May 24 2016 11:40AM','ACESII' UNION ALL
SELECT '62898','829','May 24 2016 10:35AM','May 24 2016 11:10AM','Submitting' UNION ALL
SELECT '62899','3089','May 24 2016 11:02AM','May 24 2016 12:24PM','Coding' UNION ALL
SELECT '62900','829','May 24 2016 11:15AM','May 24 2016 12:40PM','Submitting' UNION ALL
SELECT '62901','3931','May 24 2016 11:19AM','May 24 2016 11:41AM','Submitting' UNION ALL
SELECT '62902','3931','May 24 2016 11:41AM','May 24 2016 2:02PM','Submitting' UNION ALL
SELECT '62903','3133','May 24 2016 11:51AM','May 24 2016 12:05PM','ACESII' UNION ALL
SELECT '62904','3089','May 24 2016 12:24PM','May 24 2016 1:18PM','Coding' UNION ALL
SELECT '62905','3581','May 24 2016 12:26PM','May 24 2016 2:14PM','Submitting' UNION ALL
SELECT '62906','3133','May 24 2016 12:29PM','May 24 2016 2:44PM','ACESII' UNION ALL
SELECT '62907','829','May 24 2016 1:04PM','May 24 2016 1:35PM','Submitting' UNION ALL
SELECT '62908','829','May 24 2016 1:36PM','May 24 2016 1:58PM','Submitting' UNION ALL
SELECT '62909','4707','May 24 2016 1:53PM','May 24 2016 4:08PM','Data Entry' UNION ALL
SELECT '62910','2067','May 24 2016 1:59PM','May 24 2016 3:53PM','Coding' UNION ALL
SELECT '62911','3089','May 24 2016 2:02PM','May 24 2016 2:29PM','Coding' UNION ALL
SELECT '62912','3089','May 24 2016 2:29PM','May 24 2016 3:32PM','Coding' UNION ALL
SELECT '62913','3133','May 24 2016 2:44PM','May 24 2016 4:45PM','Data Entry' UNION ALL
SELECT '62914','3089','May 24 2016 3:32PM','May 24 2016 3:47PM','Coding' UNION ALL
SELECT '62915','4707','May 24 2016 4:11PM','May 24 2016 6:16PM','Data Entry' UNION ALL
SELECT '62916','4707','May 24 2016 7:02PM','May 24 2016 7:38PM','Data Entry' UNION ALL
SELECT '62917','4511','May 24 2016 8:01PM','May 24 2016 8:01PM','Submitting' UNION ALL
SELECT '62918','4511','May 24 2016 8:01PM','May 24 2016 9:55PM','Submitting' UNION ALL
SELECT '62919','3089','May 25 2016 6:22AM','May 25 2016 6:47AM','Coding' UNION ALL
SELECT '62920','2067','May 25 2016 6:30AM','May 25 2016 1:05PM','Coding' UNION ALL
SELECT '62921','3089','May 25 2016 6:54AM','May 25 2016 7:10AM','Coding' UNION ALL
SELECT '62922','3089','May 25 2016 7:10AM','May 25 2016 10:36AM','Coding' UNION ALL
SELECT '62923','3669','May 25 2016 9:47AM','May 25 2016 2:06PM','Submitting' UNION ALL
SELECT '62924','829','May 25 2016 9:57AM','May 25 2016 10:10AM','Submitting' UNION ALL
SELECT '62925','3581','May 25 2016 10:02AM','May 25 2016 11:59AM','Submitting' UNION ALL
SELECT '62926','3133','May 25 2016 10:13AM','May 25 2016 11:35AM','ACESII' UNION ALL
SELECT '62927','3931','May 25 2016 10:23AM','May 25 2016 12:32PM','Submitting' UNION ALL
SELECT '62928','829','May 25 2016 10:30AM','May 25 2016 11:48AM','Submitting' UNION ALL
SELECT '62929','3089','May 25 2016 10:41AM','May 25 2016 11:17AM','Coding' UNION ALL
SELECT '62930','4707','May 25 2016 10:57AM','May 25 2016 3:06PM','Data Entry' UNION ALL
SELECT '62931','3089','May 25 2016 11:22AM','May 25 2016 1:27PM','Coding' UNION ALL
SELECT '62932','3133','May 25 2016 11:44AM','May 25 2016 2:35PM','ACESII' UNION ALL
SELECT '62933','829','May 25 2016 11:49AM','May 25 2016 1:02PM','Submitting' UNION ALL
SELECT '62934','3581','May 25 2016 12:22PM','May 25 2016 2:06PM','Submitting' UNION ALL
SELECT '62935','3931','May 25 2016 12:46PM','May 25 2016 1:05PM','Submitting' UNION ALL
SELECT '62936','829','May 25 2016 1:06PM','May 25 2016 1:08PM','Submitting' UNION ALL
SELECT '62937','3931','May 25 2016 1:08PM','May 25 2016 1:16PM','Submitting' UNION ALL
SELECT '62938','829','May 25 2016 1:10PM','May 25 2016 2:12PM','Submitting' UNION ALL
SELECT '62939','3931','May 25 2016 1:18PM','May 25 2016 1:20PM','Submitting' UNION ALL
SELECT '62940','3931','May 25 2016 1:20PM','May 25 2016 1:36PM','Submitting' UNION ALL
SELECT '62941','3931','May 25 2016 1:36PM','May 25 2016 2:07PM','Submitting' UNION ALL
SELECT '62942','2067','May 25 2016 1:53PM','May 25 2016 3:19PM','Coding' UNION ALL
SELECT '62943','3089','May 25 2016 1:59PM','May 25 2016 3:12PM','Coding' UNION ALL
SELECT '62944','3133','May 25 2016 2:35PM','May 25 2016 5:04PM','Data Entry' UNION ALL
SELECT '62945','4505','May 25 2016 8:35PM','May 25 2016 10:36PM','Submitting' UNION ALL
SELECT '62946','4511','May 25 2016 9:28PM','May 25 2016 11:30PM','Submitting' UNION ALL
SELECT '62947','3089','May 26 2016 6:28AM','May 26 2016 6:31AM','Coding' UNION ALL
SELECT '62948','2067','May 26 2016 6:33AM','May 26 2016 1:02PM','Coding' UNION ALL
SELECT '62949','3089','May 26 2016 6:34AM','May 26 2016 7:20AM','Coding' UNION ALL
SELECT '62950','3089','May 26 2016 7:20AM','May 26 2016 8:58AM','Coding' UNION ALL
SELECT '62951','3089','May 26 2016 8:58AM','May 26 2016 9:06AM','Coding' UNION ALL
SELECT '62952','3089','May 26 2016 9:06AM','May 26 2016 9:22AM','Coding' UNION ALL
SELECT '62953','3089','May 26 2016 9:25AM','May 26 2016 10:47AM','Coding' UNION ALL
SELECT '62954','3931','May 26 2016 9:42AM','May 26 2016 1:34PM','Submitting' UNION ALL
SELECT '62955','3669','May 26 2016 9:49AM','May 26 2016 2:18PM','Submitting' UNION ALL
SELECT '62956','829','May 26 2016 9:59AM','May 26 2016 10:55AM','Submitting' UNION ALL
SELECT '62957','3133','May 26 2016 10:15AM','May 26 2016 12:01PM','ACESII' UNION ALL
SELECT '62958','3089','May 26 2016 10:47AM','May 26 2016 1:09PM','Coding' UNION ALL
SELECT '62959','829','May 26 2016 11:21AM','May 26 2016 11:31AM','Submitting' UNION ALL
SELECT '62960','829','May 26 2016 11:35AM','May 26 2016 11:36AM','Submitting' UNION ALL
SELECT '62961','829','May 26 2016 11:38AM','May 26 2016 11:53AM','Submitting' UNION ALL
SELECT '62962','829','May 26 2016 11:56AM','May 26 2016 12:38PM','Submitting' UNION ALL
SELECT '62963','3133','May 26 2016 12:35PM','May 26 2016 1:36PM','ACESII' UNION ALL
SELECT '62964','829','May 26 2016 12:40PM','May 26 2016 12:47PM','Submitting' UNION ALL
SELECT '62965','829','May 26 2016 12:49PM','May 26 2016 1:05PM','Submitting' UNION ALL
SELECT '62966','829','May 26 2016 1:08PM','May 26 2016 1:51PM','Submitting' UNION ALL
SELECT '62967','3931','May 26 2016 1:35PM','May 26 2016 1:35PM','Submitting' UNION ALL
SELECT '62968','2067','May 26 2016 1:41PM','May 26 2016 3:14PM','Coding' UNION ALL
SELECT '62969','3133','May 26 2016 1:54PM','May 26 2016 2:22PM','ACESII' UNION ALL
SELECT '62970','829','May 26 2016 1:54PM','May 26 2016 2:03PM','Submitting' UNION ALL
SELECT '62971','3089','May 26 2016 1:55PM','May 26 2016 3:24PM','Coding' UNION ALL
SELECT '62972','3581','May 26 2016 1:57PM','May 26 2016 5:56PM','Data Entry' UNION ALL
SELECT '62973','3133','May 26 2016 2:22PM','May 26 2016 6:03PM','Data Entry' UNION ALL
SELECT '62974','4505','May 26 2016 8:00PM','May 26 2016 10:02PM','Submitting' UNION ALL
SELECT '62975','4511','May 26 2016 9:57PM','May 26 2016 10:40PM','Submitting' UNION ALL
SELECT '62976','4511','May 26 2016 10:41PM','May 26 2016 11:41PM','Submitting' UNION ALL
SELECT '62977','3089','May 27 2016 6:28AM','May 27 2016 7:16AM','Coding' UNION ALL
SELECT '62978','2067','May 27 2016 6:31AM','May 27 2016 9:40AM','Coding' UNION ALL
SELECT '62979','3089','May 27 2016 7:16AM','May 27 2016 11:28AM','Coding' UNION ALL
SELECT '62980','3931','May 27 2016 9:36AM','May 27 2016 1:55PM','Submitting' UNION ALL
SELECT '62981','3669','May 27 2016 9:50AM','May 27 2016 12:26PM','Submitting' UNION ALL
SELECT '62982','3581','May 27 2016 9:59AM','May 27 2016 11:57AM','Submitting' UNION ALL
SELECT '62983','2067','May 27 2016 10:39AM','May 27 2016 1:25PM','Coding' UNION ALL
SELECT '62984','3089','May 27 2016 11:30AM','May 27 2016 1:21PM','Coding' UNION ALL
SELECT '62985','3581','May 27 2016 12:08PM','May 27 2016 1:03PM','Submitting' UNION ALL
SELECT '62986','3133','May 27 2016 10:18AM','May 27 2016 1:46PM','ACESII' UNION ALL
SELECT '62987','2067','May 27 2016 1:31PM','May 27 2016 3:14PM','Coding' UNION ALL
SELECT '62988','3133','May 27 2016 1:56PM','May 27 2016 2:37PM','ACESII' UNION ALL
SELECT '62989','3581','May 27 2016 1:58PM','May 27 2016 6:08PM','Data Entry' UNION ALL
SELECT '62990','3089','May 27 2016 2:04PM','May 27 2016 2:38PM','Coding' UNION ALL
SELECT '62991','3133','May 27 2016 2:37PM','May 27 2016 6:08PM','Data Entry' UNION ALL
SELECT '62992','3089','May 27 2016 2:41PM','May 27 2016 3:37PM','Coding' UNION ALL
SELECT '62993','2067','May 27 2016 3:14PM','May 27 2016 3:14PM','Coding' UNION ALL
SELECT '62994','3089','May 30 2016 6:30AM','May 30 2016 8:54AM','Coding' UNION ALL
SELECT '62995','2067','May 30 2016 6:31AM','May 30 2016 12:10PM','Coding' UNION ALL
SELECT '62996','1501','May 30 2016 6:49AM','May 30 2016 8:36AM','Coding' UNION ALL
SELECT '62997','1501','May 30 2016 8:47AM','May 30 2016 10:22AM','Coding' UNION ALL
SELECT '62998','3931','May 30 2016 9:44AM','May 30 2016 9:45AM','Submitting' UNION ALL
SELECT '62999','3931','May 30 2016 9:45AM','May 30 2016 10:05AM','Submitting' UNION ALL
SELECT '63000','3089','May 30 2016 9:46AM','May 30 2016 9:47AM','Coding' UNION ALL
SELECT '63001','3089','May 30 2016 9:47AM','May 30 2016 9:56AM','Coding' UNION ALL
SELECT '63002','3581','May 30 2016 9:49AM','May 30 2016 12:04PM','Submitting' UNION ALL
SELECT '63003','829','May 30 2016 9:50AM','May 30 2016 10:05AM','Submitting' UNION ALL
SELECT '63004','3089','May 30 2016 9:56AM','May 30 2016 10:19AM','Coding' UNION ALL
SELECT '63005','3931','May 30 2016 10:05AM','May 30 2016 2:52PM','Submitting' UNION ALL
SELECT '63006','829','May 30 2016 10:07AM','May 30 2016 12:48PM','Submitting' UNION ALL
SELECT '63007','3669','May 30 2016 10:09AM','May 30 2016 10:42AM','Submitting' UNION ALL
SELECT '63008','3089','May 30 2016 10:20AM','May 30 2016 1:04PM','Coding' UNION ALL
SELECT '63009','3133','May 30 2016 10:21AM','May 30 2016 12:11PM','ACESII' UNION ALL
SELECT '63010','1501','May 30 2016 10:27AM','May 30 2016 2:02PM','Coding' UNION ALL
SELECT '63011','3669','May 30 2016 10:49AM','May 30 2016 1:56PM','Submitting' UNION ALL
SELECT '63012','3581','May 30 2016 12:13PM','May 30 2016 1:41PM','Submitting' UNION ALL
SELECT '63013','3133','May 30 2016 12:19PM','May 30 2016 12:43PM','ACESII' UNION ALL
SELECT '63014','3133','May 30 2016 12:43PM','May 30 2016 1:01PM','Data Entry' UNION ALL
SELECT '63015','829','May 30 2016 12:49PM','May 30 2016 2:10PM','Submitting' UNION ALL
SELECT '63016','3133','May 30 2016 1:01PM','May 30 2016 2:08PM','ACESII' UNION ALL
SELECT '63017','3089','May 30 2016 1:09PM','May 30 2016 1:19PM','Coding' UNION ALL
SELECT '63018','2067','May 30 2016 1:23PM','May 30 2016 3:53PM','Coding' UNION ALL
SELECT '63019','3581','May 30 2016 1:41PM','May 30 2016 2:04PM','Data Entry' UNION ALL
SELECT '63020','4707','May 30 2016 1:56PM','May 30 2016 3:14PM','Data Entry' UNION ALL
SELECT '63021','3133','May 30 2016 2:08PM','May 30 2016 3:50PM','Data Entry' UNION ALL
SELECT '63022','3089','May 30 2016 2:09PM','May 30 2016 3:39PM','Coding' UNION ALL
SELECT '63023','3931','May 30 2016 2:52PM','May 30 2016 3:41PM','Submitting' UNION ALL
SELECT '63024','4707','May 30 2016 3:16PM','May 30 2016 6:00PM','Data Entry' UNION ALL
SELECT '63025','3931','May 30 2016 3:43PM','May 30 2016 3:43PM','Submitting' UNION ALL
SELECT '63026','3931','May 30 2016 3:46PM','May 30 2016 3:46PM','Submitting' UNION ALL
SELECT '63027','3089','May 30 2016 3:50PM','May 30 2016 3:52PM','Coding' UNION ALL
SELECT '63028','1501','May 30 2016 5:11PM','May 30 2016 5:51PM','Coding' UNION ALL
SELECT '63029','4505','May 30 2016 6:46PM','May 30 2016 7:48PM','Submitting' UNION ALL
SELECT '63030','4511','May 30 2016 8:04PM','May 30 2016 9:57PM','Submitting' UNION ALL
SELECT '63031','4505','May 30 2016 8:57PM','May 30 2016 9:41PM','Submitting' UNION ALL
SELECT '63032','3089','May 31 2016 6:28AM','May 31 2016 12:28PM','Coding' UNION ALL
SELECT '63033','1501','May 31 2016 6:54AM','May 31 2016 8:20AM','Coding' UNION ALL
SELECT '63034','2067','May 31 2016 7:16AM','May 31 2016 1:05PM','Coding' UNION ALL
SELECT '63035','1501','May 31 2016 8:32AM','May 31 2016 9:43AM','Coding' UNION ALL
SELECT '63036','829','May 31 2016 9:34AM','May 31 2016 11:27AM','Submitting' UNION ALL
SELECT '63037','1501','May 31 2016 9:50AM','May 31 2016 10:14AM','Coding' UNION ALL
SELECT '63038','3669','May 31 2016 9:58AM','May 31 2016 4:13PM','Submitting' UNION ALL
SELECT '63039','3581','May 31 2016 10:05AM','May 31 2016 12:08PM','Submitting' UNION ALL
SELECT '63040','1501','May 31 2016 10:14AM','May 31 2016 11:21AM','Coding' UNION ALL
SELECT '63041','3133','May 31 2016 10:17AM','May 31 2016 12:24PM','ACESII' UNION ALL
SELECT '63042','1501','May 31 2016 11:26AM','May 31 2016 1:28PM','Coding' UNION ALL
SELECT '63043','829','May 31 2016 11:43AM','May 31 2016 12:11PM','Submitting' UNION ALL
SELECT '63044','3931','May 31 2016 12:09PM','May 31 2016 2:05PM','Submitting' UNION ALL
SELECT '63045','829','May 31 2016 12:13PM','May 31 2016 2:26PM','Submitting' UNION ALL
SELECT '63046','3089','May 31 2016 12:28PM','May 31 2016 12:57PM','Coding' UNION ALL
SELECT '63047','3581','May 31 2016 12:33PM','May 31 2016 2:00PM','Submitting' UNION ALL
SELECT '63048','3133','May 31 2016 12:53PM','May 31 2016 1:31PM','ACESII' UNION ALL
SELECT '63049','3089','May 31 2016 12:58PM','May 31 2016 1:30PM','Coding' UNION ALL
SELECT '63050','3133','May 31 2016 1:36PM','May 31 2016 3:16PM','ACESII' UNION ALL
SELECT '63051','1501','May 31 2016 1:41PM','May 31 2016 2:17PM','Coding' UNION ALL
SELECT '63052','3089','May 31 2016 1:51PM','May 31 2016 1:51PM','Coding' UNION ALL
SELECT '63053','4707','May 31 2016 1:57PM','May 31 2016 4:18PM','Data Entry' UNION ALL
SELECT '63054','2067','May 31 2016 2:07PM','May 31 2016 6:33PM','Coding' UNION ALL
SELECT '63055','3089','May 31 2016 2:25PM','May 31 2016 5:02PM','Coding' UNION ALL
SELECT '63056','3133','May 31 2016 3:16PM','May 31 2016 3:54PM','Data Entry' UNION ALL
SELECT '63057','1501','May 31 2016 3:46PM','May 31 2016 5:54PM','Coding' UNION ALL
SELECT '63058','3133','May 31 2016 3:55PM','May 31 2016 5:01PM','Data Entry' UNION ALL
SELECT '63059','4707','May 31 2016 4:21PM','May 31 2016 7:15PM','Data Entry' UNION ALL
SELECT '63060','3669','May 31 2016 4:51PM','May 31 2016 6:20PM','Submitting' UNION ALL
SELECT '63061','3931','May 31 2016 5:00PM','May 31 2016 6:17PM','Submitting' UNION ALL
SELECT '63062','3089','May 31 2016 5:02PM','May 31 2016 5:12PM','Coding' UNION ALL
SELECT '63063','3089','May 31 2016 5:13PM','May 31 2016 6:27PM','Coding' UNION ALL
SELECT '63064','1501','May 31 2016 5:57PM','May 31 2016 6:35PM','Coding' UNION ALL
SELECT '63065','4505','May 31 2016 8:21PM','May 31 2016 10:23PM','Submitting' UNION ALL
SELECT '63066','4511','May 31 2016 9:56PM','May 31 2016 11:50PM','Submitting' UNION ALL
SELECT '63067','3089','Jun 1 2016 6:25AM','Jun 1 2016 6:25AM','Coding' UNION ALL
SELECT '63068','3089','Jun 1 2016 6:25AM','Jun 1 2016 8:32AM','Coding' UNION ALL
SELECT '63069','2067','Jun 1 2016 6:29AM','Jun 1 2016 12:33PM','Coding' UNION ALL
SELECT '63070','1501','Jun 1 2016 6:50AM','Jun 1 2016 8:49AM','Coding' UNION ALL
SELECT '63071','3089','Jun 1 2016 8:38AM','Jun 1 2016 8:44AM','Coding' UNION ALL
SELECT '63072','3089','Jun 1 2016 8:44AM','Jun 1 2016 9:43AM','Coding' UNION ALL
SELECT '63073','1501','Jun 1 2016 8:59AM','Jun 1 2016 10:46AM','Coding' UNION ALL
SELECT '63074','3089','Jun 1 2016 9:46AM','Jun 1 2016 9:51AM','Coding' UNION ALL
SELECT '63075','3089','Jun 1 2016 9:52AM','Jun 1 2016 10:12AM','Coding' UNION ALL
SELECT '63076','829','Jun 1 2016 9:54AM','Jun 1 2016 12:03PM','Submitting' UNION ALL
SELECT '63077','3581','Jun 1 2016 10:07AM','Jun 1 2016 11:57AM','Submitting' UNION ALL
SELECT '63078','3133','Jun 1 2016 10:14AM','Jun 1 2016 12:25PM','ACESII' UNION ALL
SELECT '63079','3089','Jun 1 2016 10:23AM','Jun 1 2016 10:23AM','Coding' UNION ALL
SELECT '63080','3089','Jun 1 2016 10:23AM','Jun 1 2016 11:06AM','Coding' UNION ALL
SELECT '63081','1501','Jun 1 2016 10:53AM','Jun 1 2016 11:22AM','Coding' UNION ALL
SELECT '63082','3089','Jun 1 2016 11:10AM','Jun 1 2016 11:14AM','Coding' UNION ALL
SELECT '63083','3089','Jun 1 2016 11:14AM','Jun 1 2016 1:38PM','Coding' UNION ALL
SELECT '63084','1501','Jun 1 2016 11:22AM','Jun 1 2016 12:42PM','Coding' UNION ALL
SELECT '63085','3669','Jun 1 2016 11:58AM','Jun 1 2016 2:39PM','Submitting' UNION ALL
SELECT '63086','829','Jun 1 2016 12:05PM','Jun 1 2016 1:52PM','Submitting' UNION ALL
SELECT '63087','3581','Jun 1 2016 12:24PM','Jun 1 2016 2:17PM','Submitting' UNION ALL
SELECT '63088','3133','Jun 1 2016 12:36PM','Jun 1 2016 12:43PM','ACESII' UNION ALL
SELECT '63089','1501','Jun 1 2016 12:45PM','Jun 1 2016 1:08PM','Coding' UNION ALL
SELECT '63090','3133','Jun 1 2016 12:56PM','Jun 1 2016 4:57PM','ACESII' UNION ALL
SELECT '63091','1501','Jun 1 2016 1:08PM','Jun 1 2016 1:36PM','Coding' UNION ALL
SELECT '63092','1501','Jun 1 2016 1:36PM','Jun 1 2016 1:36PM','Coding' UNION ALL
SELECT '63093','1501','Jun 1 2016 1:36PM','Jun 1 2016 2:02PM','Coding' UNION ALL
SELECT '63094','2067','Jun 1 2016 1:49PM','Jun 1 2016 3:07PM','Coding' UNION ALL
SELECT '63095','3089','Jun 1 2016 1:49PM','Jun 1 2016 1:49PM','Coding' UNION ALL
SELECT '63096','4707','Jun 1 2016 1:55PM','Jun 1 2016 6:30PM','Data Entry' UNION ALL
SELECT '63097','1501','Jun 1 2016 2:02PM','Jun 1 2016 2:07PM','Coding' UNION ALL
SELECT '63098','3089','Jun 1 2016 2:18PM','Jun 1 2016 3:32PM','Coding' UNION ALL
SELECT '63099','3089','Jun 1 2016 3:32PM','Jun 1 2016 3:32PM','Coding' UNION ALL
SELECT '63100','3133','Jun 1 2016 5:03PM','Jun 1 2016 6:05PM','Data Entry' UNION ALL
SELECT '63101','4707','Jun 1 2016 6:30PM','Jun 1 2016 8:01PM','Data Entry' UNION ALL
SELECT '63102','1501','Jun 1 2016 7:56PM','Jun 1 2016 8:30PM','Coding' UNION ALL
SELECT '63103','2067','Jun 2 2016 6:19AM','Jun 2 2016 1:03PM','Coding' UNION ALL
SELECT '63104','3089','Jun 2 2016 6:31AM','Jun 2 2016 8:54AM','Coding' UNION ALL
SELECT '63105','1501','Jun 2 2016 7:00AM','Jun 2 2016 8:46AM','Coding' UNION ALL
SELECT '63106','3089','Jun 2 2016 8:57AM','Jun 2 2016 11:56AM','Coding' UNION ALL
SELECT '63107','1501','Jun 2 2016 8:59AM','Jun 2 2016 10:43AM','Coding' UNION ALL
SELECT '63108','3669','Jun 2 2016 9:52AM','Jun 2 2016 2:19PM','Submitting' UNION ALL
SELECT '63109','3581','Jun 2 2016 9:55AM','Jun 2 2016 12:02PM','Submitting' UNION ALL
SELECT '63110','829','Jun 2 2016 10:00AM','Jun 2 2016 11:00AM','Submitting' UNION ALL
SELECT '63111','3931','Jun 2 2016 10:02AM','Jun 2 2016 10:09AM','Submitting' UNION ALL
SELECT '63112','3931','Jun 2 2016 10:09AM','Jun 2 2016 1:06PM','Submitting' UNION ALL
SELECT '63113','3133','Jun 2 2016 10:14AM','Jun 2 2016 12:24PM','ACESII' UNION ALL
SELECT '63114','1501','Jun 2 2016 10:47AM','Jun 2 2016 12:39PM','Coding' UNION ALL
SELECT '63115','829','Jun 2 2016 11:16AM','Jun 2 2016 11:27AM','Submitting' UNION ALL
SELECT '63116','829','Jun 2 2016 11:29AM','Jun 2 2016 11:34AM','Submitting' UNION ALL
SELECT '63117','3089','Jun 2 2016 11:58AM','Jun 2 2016 1:46PM','Coding' UNION ALL
SELECT '63118','829','Jun 2 2016 12:06PM','Jun 2 2016 12:33PM','Submitting' UNION ALL
SELECT '63119','3581','Jun 2 2016 12:23PM','Jun 2 2016 2:04PM','Submitting' UNION ALL
SELECT '63120','829','Jun 2 2016 12:36PM','Jun 2 2016 1:58PM','Submitting' UNION ALL
SELECT '63121','1501','Jun 2 2016 12:44PM','Jun 2 2016 2:08PM','Coding' UNION ALL
SELECT '63122','3133','Jun 2 2016 12:47PM','Jun 2 2016 2:46PM','ACESII' UNION ALL
SELECT '63123','3931','Jun 2 2016 1:13PM','Jun 2 2016 1:19PM','Submitting' UNION ALL
SELECT '63124','3931','Jun 2 2016 1:20PM','Jun 2 2016 1:28PM','Submitting' UNION ALL
SELECT '63125','4707','Jun 2 2016 1:54PM','Jun 2 2016 4:03PM','Data Entry' UNION ALL
SELECT '63126','2067','Jun 2 2016 2:01PM','Jun 2 2016 3:48PM','Coding' UNION ALL
SELECT '63127','3089','Jun 2 2016 2:34PM','Jun 2 2016 3:42PM','Coding' UNION ALL
SELECT '63128','3133','Jun 2 2016 2:46PM','Jun 2 2016 4:27PM','Data Entry' UNION ALL
SELECT '63129','3089','Jun 2 2016 3:50PM','Jun 2 2016 4:16PM','Coding' UNION ALL
SELECT '63130','4707','Jun 2 2016 4:05PM','Jun 2 2016 5:59PM','Data Entry' UNION ALL
SELECT '63131','1501','Jun 2 2016 6:12PM','Jun 2 2016 7:22PM','Coding' UNION ALL
SELECT '63132','4505','Jun 2 2016 6:36PM','Jun 2 2016 8:18PM','Submitting' UNION ALL
SELECT '63133','4511','Jun 2 2016 10:00PM','Jun 2 2016 11:12PM','Submitting' UNION ALL
SELECT '63134','4511','Jun 2 2016 11:14PM','Jun 2 2016 11:59PM','Submitting' UNION ALL
SELECT '63135','4511','Jun 3 2016 12:00AM','Jun 3 2016 12:00AM','Submitting' UNION ALL
SELECT '63136','4511','Jun 3 2016 12:00AM','Jun 3 2016 12:00AM','Submitting' UNION ALL
SELECT '63137','2067','Jun 3 2016 6:16AM','Jun 3 2016 9:12AM','Coding' UNION ALL
SELECT '63138','3089','Jun 3 2016 6:27AM','Jun 3 2016 7:57AM','Coding' UNION ALL
SELECT '63139','1501','Jun 3 2016 6:48AM','Jun 3 2016 8:33AM','Coding' UNION ALL
SELECT '63140','3089','Jun 3 2016 8:00AM','Jun 3 2016 9:43AM','Coding' UNION ALL
SELECT '63141','1501','Jun 3 2016 8:41AM','Jun 3 2016 10:33AM','Coding' UNION ALL
SELECT '63142','2067','Jun 3 2016 9:12AM','Jun 3 2016 9:14AM','Coding' UNION ALL
SELECT '63143','2067','Jun 3 2016 9:14AM','Jun 3 2016 9:29AM','Coding' UNION ALL
SELECT '63144','2067','Jun 3 2016 9:29AM','Jun 3 2016 9:32AM','Coding' UNION ALL
SELECT '63145','2067','Jun 3 2016 9:32AM','Jun 3 2016 9:39AM','Coding' UNION ALL
SELECT '63146','2067','Jun 3 2016 9:39AM','Jun 3 2016 10:48AM','Coding' UNION ALL
SELECT '63147','3089','Jun 3 2016 9:43AM','Jun 3 2016 9:43AM','Coding' UNION ALL
SELECT '63148','3089','Jun 3 2016 9:43AM','Jun 3 2016 9:54AM','Coding' UNION ALL
SELECT '63149','3089','Jun 3 2016 9:54AM','Jun 3 2016 12:15PM','Coding' UNION ALL
SELECT '63150','3581','Jun 3 2016 9:58AM','Jun 3 2016 11:53AM','Submitting' UNION ALL
SELECT '63151','3669','Jun 3 2016 10:03AM','Jun 3 2016 11:41AM','Submitting' UNION ALL
SELECT '63152','3931','Jun 3 2016 10:03AM','Jun 3 2016 10:45AM','Submitting' UNION ALL
SELECT '63153','3133','Jun 3 2016 10:10AM','Jun 3 2016 12:02PM','ACESII' UNION ALL
SELECT '63154','1501','Jun 3 2016 10:43AM','Jun 3 2016 1:53PM','Coding' UNION ALL
SELECT '63155','2067','Jun 3 2016 10:48AM','Jun 3 2016 11:03AM','Coding' UNION ALL
SELECT '63156','3931','Jun 3 2016 10:54AM','Jun 3 2016 11:35AM','Submitting' UNION ALL
SELECT '63157','2067','Jun 3 2016 11:09AM','Jun 3 2016 1:07PM','Coding' UNION ALL
SELECT '63158','3931','Jun 3 2016 11:35AM','Jun 3 2016 12:29PM','Submitting' UNION ALL
SELECT '63159','3669','Jun 3 2016 11:41AM','Jun 3 2016 12:54PM','Submitting' UNION ALL
SELECT '63160','3581','Jun 3 2016 12:18PM','Jun 3 2016 2:24PM','Submitting' UNION ALL
SELECT '63161','3089','Jun 3 2016 12:22PM','Jun 3 2016 1:19PM','Coding' UNION ALL
SELECT '63162','3931','Jun 3 2016 12:34PM','Jun 3 2016 12:38PM','Submitting' UNION ALL
SELECT '63163','3133','Jun 3 2016 12:44PM','Jun 3 2016 2:37PM','ACESII' UNION ALL
SELECT '63164','2067','Jun 3 2016 1:07PM','Jun 3 2016 1:08PM','Coding' UNION ALL
SELECT '63165','3089','Jun 3 2016 1:20PM','Jun 3 2016 1:21PM','Coding' UNION ALL
SELECT '63166','4707','Jun 3 2016 1:55PM','Jun 3 2016 6:10PM','Data Entry' UNION ALL
SELECT '63167','2067','Jun 3 2016 1:59PM','Jun 3 2016 3:16PM','Coding' UNION ALL
SELECT '63168','3089','Jun 3 2016 2:01PM','Jun 3 2016 3:20PM','Coding' UNION ALL
SELECT '63169','3133','Jun 3 2016 2:37PM','Jun 3 2016 4:28PM','Data Entry' UNION ALL
SELECT '63170','3931','Jun 4 2016 9:41AM','Jun 4 2016 11:10AM','Submitting' UNION ALL
SELECT '63171','4511','Jun 4 2016 5:20PM','Jun 4 2016 7:09PM','Submitting' UNION ALL
SELECT '63172','4505','Jun 4 2016 7:53PM','Jun 4 2016 9:45PM','Submitting' UNION ALL
SELECT '63173','1501','Jun 5 2016 6:58PM','Jun 5 2016 7:08PM','Coding' UNION ALL
SELECT '63174','2067','Jun 6 2016 6:30AM','Jun 6 2016 8:59AM','Coding' UNION ALL
SELECT '63175','3089','Jun 6 2016 6:34AM','Jun 6 2016 10:40AM','Coding' UNION ALL
SELECT '63176','1501','Jun 6 2016 6:47AM','Jun 6 2016 8:37AM','Coding' UNION ALL
SELECT '63177','1501','Jun 6 2016 8:45AM','Jun 6 2016 9:28AM','Coding' UNION ALL
SELECT '63178','2067','Jun 6 2016 9:25AM','Jun 6 2016 11:56AM','Coding' UNION ALL
SELECT '63179','1501','Jun 6 2016 9:28AM','Jun 6 2016 11:28AM','Coding' UNION ALL
SELECT '63180','3931','Jun 6 2016 9:56AM','Jun 6 2016 9:57AM','Submitting' UNION ALL
SELECT '63181','829','Jun 6 2016 9:56AM','Jun 6 2016 12:22PM','Submitting' UNION ALL
SELECT '63182','3931','Jun 6 2016 9:57AM','Jun 6 2016 9:59AM','Submitting' UNION ALL
SELECT '63183','3669','Jun 6 2016 9:59AM','Jun 6 2016 1:01PM','Submitting' UNION ALL
SELECT '63184','3931','Jun 6 2016 9:59AM','Jun 6 2016 11:15AM','Submitting' UNION ALL
SELECT '63185','3581','Jun 6 2016 10:04AM','Jun 6 2016 11:56AM','Submitting' UNION ALL
SELECT '63186','3133','Jun 6 2016 10:20AM','Jun 6 2016 12:27PM','ACESII' UNION ALL
SELECT '63187','3089','Jun 6 2016 10:40AM','Jun 6 2016 11:10AM','Coding' UNION ALL
SELECT '63188','3089','Jun 6 2016 11:10AM','Jun 6 2016 1:31PM','Coding' UNION ALL
SELECT '63189','3931','Jun 6 2016 11:27AM','Jun 6 2016 11:47AM','Submitting' UNION ALL
SELECT '63190','1501','Jun 6 2016 11:34AM','Jun 6 2016 2:00PM','Coding' UNION ALL
SELECT '63191','3931','Jun 6 2016 11:47AM','Jun 6 2016 2:03PM','Submitting' UNION ALL
SELECT '63192','829','Jun 6 2016 12:24PM','Jun 6 2016 2:06PM','Submitting' UNION ALL
SELECT '63193','2067','Jun 6 2016 12:44PM','Jun 6 2016 3:23PM','Coding' UNION ALL
SELECT '63194','3133','Jun 6 2016 1:00PM','Jun 6 2016 1:16PM','ACESII' UNION ALL
SELECT '63195','3133','Jun 6 2016 1:20PM','Jun 6 2016 1:37PM','ACESII' UNION ALL
SELECT '63196','3133','Jun 6 2016 1:37PM','Jun 6 2016 4:43PM','Data Entry' UNION ALL
SELECT '63197','4707','Jun 6 2016 1:58PM','Jun 6 2016 3:34PM','Data Entry' UNION ALL
SELECT '63198','3581','Jun 6 2016 2:07PM','Jun 6 2016 2:07PM','Submitting' UNION ALL
SELECT '63199','3089','Jun 6 2016 2:12PM','Jun 6 2016 2:23PM','Coding' UNION ALL
SELECT '63200','3089','Jun 6 2016 2:23PM','Jun 6 2016 2:28PM','Coding' UNION ALL
SELECT '63201','3089','Jun 6 2016 2:28PM','Jun 6 2016 3:52PM','Coding' UNION ALL
SELECT '63202','4707','Jun 6 2016 3:37PM','Jun 6 2016 6:00PM','Data Entry' UNION ALL
SELECT '63203','1501','Jun 6 2016 5:36PM','Jun 6 2016 6:32PM','Coding' UNION ALL
SELECT '63204','2067','Jun 7 2016 5:58AM','Jun 7 2016 9:04AM','Coding' UNION ALL
SELECT '63205','3089','Jun 7 2016 6:34AM','Jun 7 2016 8:30AM','Coding' UNION ALL
SELECT '63206','1501','Jun 7 2016 6:48AM','Jun 7 2016 8:41AM','Coding' UNION ALL
SELECT '63207','3089','Jun 7 2016 8:30AM','Jun 7 2016 12:01PM','Coding' UNION ALL
SELECT '63208','1501','Jun 7 2016 8:49AM','Jun 7 2016 10:49AM','Coding' UNION ALL
SELECT '63209','2067','Jun 7 2016 9:08AM','Jun 7 2016 12:03PM','Coding' UNION ALL
SELECT '63210','3669','Jun 7 2016 9:50AM','Jun 7 2016 2:01PM','Submitting' UNION ALL
SELECT '63211','3581','Jun 7 2016 9:51AM','Jun 7 2016 11:56AM','Submitting' UNION ALL
SELECT '63212','829','Jun 7 2016 10:01AM','Jun 7 2016 10:01AM','Submitting' UNION ALL
SELECT '63213','829','Jun 7 2016 10:01AM','Jun 7 2016 11:07AM','Submitting' UNION ALL
SELECT '63214','3931','Jun 7 2016 10:04AM','Jun 7 2016 11:59AM','Submitting' UNION ALL
SELECT '63215','3133','Jun 7 2016 10:16AM','Jun 7 2016 12:15PM','ACESII' UNION ALL
SELECT '63216','1501','Jun 7 2016 10:58AM','Jun 7 2016 11:54AM','Coding' UNION ALL
SELECT '63217','829','Jun 7 2016 11:11AM','Jun 7 2016 11:20AM','Submitting' UNION ALL
SELECT '63218','829','Jun 7 2016 11:27AM','Jun 7 2016 11:48AM','Submitting' UNION ALL
SELECT '63219','829','Jun 7 2016 11:53AM','Jun 7 2016 12:02PM','Submitting' UNION ALL
SELECT '63220','1501','Jun 7 2016 12:00PM','Jun 7 2016 2:01PM','Coding' UNION ALL
SELECT '63221','3089','Jun 7 2016 12:01PM','Jun 7 2016 1:17PM','Coding' UNION ALL
SELECT '63222','829','Jun 7 2016 12:03PM','Jun 7 2016 1:59PM','Submitting' UNION ALL
SELECT '63223','3931','Jun 7 2016 12:04PM','Jun 7 2016 12:12PM','Submitting' UNION ALL
SELECT '63224','3931','Jun 7 2016 12:12PM','Jun 7 2016 2:08PM','Submitting' UNION ALL
SELECT '63225','3581','Jun 7 2016 12:19PM','Jun 7 2016 12:50PM','Submitting' UNION ALL
SELECT '63226','3133','Jun 7 2016 12:20PM','Jun 7 2016 12:52PM','ACESII' UNION ALL
SELECT '63227','3581','Jun 7 2016 12:52PM','Jun 7 2016 1:06PM','Submitting' UNION ALL
SELECT '63228','3133','Jun 7 2016 12:59PM','Jun 7 2016 2:17PM','ACESII' UNION ALL
SELECT '63229','2067','Jun 7 2016 1:22PM','Jun 7 2016 3:47PM','Coding' UNION ALL
SELECT '63230','4707','Jun 7 2016 1:58PM','Jun 7 2016 5:57PM','Data Entry' UNION ALL
SELECT '63231','3089','Jun 7 2016 2:12PM','Jun 7 2016 2:34PM','Coding' UNION ALL
SELECT '63232','3133','Jun 7 2016 2:17PM','Jun 7 2016 3:55PM','ACESII' UNION ALL
SELECT '63233','3089','Jun 7 2016 2:35PM','Jun 7 2016 2:41PM','Coding' UNION ALL
SELECT '63234','3089','Jun 7 2016 2:41PM','Jun 7 2016 2:47PM','Coding' UNION ALL
SELECT '63235','3089','Jun 7 2016 2:48PM','Jun 7 2016 3:51PM','Coding' UNION ALL
SELECT '63236','1501','Jun 7 2016 3:27PM','Jun 7 2016 3:30PM','Coding' UNION ALL
SELECT '63237','1501','Jun 7 2016 3:30PM','Jun 7 2016 4:27PM','Coding'
June 8, 2016 at 11:28 am
That because you have your "date expressions" enclosed in quotes when inserting into the temporary table. The are never evaluated, so they never produce dates.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
June 8, 2016 at 12:09 pm
Thanks for your reply Drew but the quotes aren't stored in the tables. If we run SELECT * from #mydaterangetable WHERE tbldaterangeID =3 we get:
3Last 7 daysDATEADD(day, DATEDIFF(day, -1, getdate()) - 8, 0)DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)
Note that the quotes are not returned.
June 8, 2016 at 12:12 pm
erouse (6/8/2016)
Thanks for your reply Drew but the quotes aren't stored in the tables. If we run SELECT * from #mydaterangetable WHERE tbldaterangeID =3 we get:3Last 7 daysDATEADD(day, DATEDIFF(day, -1, getdate()) - 8, 0)DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)
Note that the quotes are not returned.
But those are just string values. How are they being used? I may have just missed it in the code you had posted.
June 8, 2016 at 12:14 pm
You will have to use dynamic sql if you want to get the values returned from those functions. As it is they are only string literals, as Lynn pointed out. To get the results they must be executed.
_______________________________________________________________
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 8, 2016 at 12:30 pm
erouse (6/8/2016)
Thanks for your reply Drew but the quotes aren't stored in the tables. If we run SELECT * from #mydaterangetable WHERE tbldaterangeID =3 we get:3Last 7 daysDATEADD(day, DATEDIFF(day, -1, getdate()) - 8, 0)DATEADD(day, DATEDIFF(day, -1, getdate()) - 1, 0)
Note that the quotes are not returned.
Quote are never stored or returned for strings. That doesn't mean that it's not a string. You think that you're storing an expression that will be evaluated. You're not. You're storing a string. If you want it to be evaluated, remove the quotes around the expression when you insert it into the table.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
June 8, 2016 at 12:33 pm
There is no need for dynamic SQL here. He's storing these values in a temporary table, and the values aren't going to change (in most cases) between when he inserts them in the table and when he needs to evaluate them, so he might as well evaluate them when he inserts them in the table.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
June 8, 2016 at 12:38 pm
drew.allen (6/8/2016)
There is no need for dynamic SQL here. He's storing these values in a temporary table, and the values aren't going to change (in most cases) between when he inserts them in the table and when he needs to evaluate them, so he might as well evaluate them when he inserts them in the table.Drew
If those functions continue to be stored in the table you would need dynamic sql. I didn't mention that storing functions like that is generally a bad idea. It would certainly be a better approach to store the actual values instead of the function to calculate it. 😉
_______________________________________________________________
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 8, 2016 at 1:09 pm
Dynamic SQL solved the problem. Thank you for all of your replies.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply