CREATE TABLE TempEmployeeTimesheet
(
	EmployeeID BIGINT,
	StartDate DATETIME,
	EndDate DATETIME,
	TotalHours INT,
	IsCompanyUser BIT,
	UserID INT,
	DatetimeStamp DATETIME,
	EmployeeTypeID INT
)
------------------------------------------------------------------------------------
insert into TempEmployeeTimesheet
Select (select ID from Employee where SocialSecurityNo=166584825),'1/1/2015','1/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'2/1/2015','2/28/2015',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'5/1/2015','5/31/2015',222,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'6/1/2015','6/30/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'7/1/2015','7/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'8/1/2015','8/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'9/1/2015','9/30/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'10/1/2015','10/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'11/1/2014','11/30/2014',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=166584825),'12/1/2014','12/31/2014',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=179408793),'6/1/2015','6/30/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=185527979),'7/1/2015','7/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=185527979),'8/1/2015','8/31/2015',336,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=185527979),'9/1/2015','9/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=185527979),'10/1/2015','10/31/2015',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=198526159),'8/1/2015','8/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=198526159),'9/1/2015','9/30/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'1/1/2015','1/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'2/1/2015','2/28/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'3/1/2015','3/31/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'4/1/2015','4/30/2015',246,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'5/1/2015','5/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'6/1/2015','6/30/2015',282,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'8/1/2015','8/31/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'9/1/2015','9/30/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'10/1/2015','10/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'11/1/2014','11/30/2014',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'12/1/2014','12/31/2014',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244271687),'1/1/2015','1/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244271687),'6/1/2015','6/30/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244271687),'10/1/2015','10/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244271687),'12/1/2014','12/31/2014',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'1/1/2015','1/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'2/1/2015','2/28/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'3/1/2015','3/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'4/1/2015','4/30/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'5/1/2015','5/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'7/1/2015','7/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'8/1/2015','8/31/2015',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'9/1/2015','9/30/2015',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'10/1/2015','10/31/2015',336,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=261318116),'1/1/2015','1/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=261318116),'2/1/2015','2/28/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=277420394),'7/1/2015','7/31/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=277420394),'8/1/2015','8/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=279541868),'6/1/2015','6/30/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=281802109),'5/1/2015','5/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=281802109),'6/1/2015','6/30/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=281802109),'7/1/2015','7/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=281802109),'8/1/2015','8/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=281802109),'11/1/2014','11/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'5/1/2015','5/31/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'6/1/2015','6/30/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'7/1/2015','7/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'8/1/2015','8/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'9/1/2015','9/30/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'10/1/2015','10/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'1/1/2015','1/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'2/1/2015','2/28/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'3/1/2015','3/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'5/1/2015','5/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'6/1/2015','6/30/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'7/1/2015','7/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'10/1/2015','10/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'12/1/2014','12/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=313783576),'3/1/2015','3/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=323549143),'11/1/2014','11/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324402904),'1/1/2015','1/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'1/1/2015','1/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'4/1/2015','4/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'5/1/2015','5/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'6/1/2015','6/30/2015',222,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'10/1/2015','10/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'11/1/2014','11/30/2014',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=327463604),'1/1/2015','1/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=327463604),'11/1/2014','11/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=327463604),'12/1/2014','12/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=336780871),'5/1/2015','5/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=336780871),'6/1/2015','6/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=336780871),'10/1/2015','10/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=338720801),'7/1/2015','7/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341525490),'6/1/2015','6/30/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'1/1/2015','1/31/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'2/1/2015','2/28/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'3/1/2015','3/31/2015',306,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'4/1/2015','4/30/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'5/1/2015','5/31/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'6/1/2015','6/30/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'7/1/2015','7/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'8/1/2015','8/31/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'9/1/2015','9/30/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'10/1/2015','10/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'11/1/2014','11/30/2014',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'12/1/2014','12/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'1/1/2015','1/31/2015',324,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'2/1/2015','2/28/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'3/1/2015','3/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'4/1/2015','4/30/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'5/1/2015','5/31/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'6/1/2015','6/30/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'7/1/2015','7/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'8/1/2015','8/31/2015',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'9/1/2015','9/30/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'10/1/2015','10/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'11/1/2014','11/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'12/1/2014','12/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=347449180),'6/1/2015','6/30/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=347449180),'8/1/2015','8/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=347449180),'11/1/2014','11/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=350343386),'5/1/2015','5/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=350343386),'6/1/2015','6/30/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=351507611),'6/1/2015','6/30/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=351507611),'7/1/2015','7/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=351507611),'8/1/2015','8/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=352567004),'5/1/2015','5/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=352567004),'6/1/2015','6/30/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=352567004),'7/1/2015','7/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=352567004),'8/1/2015','8/31/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=352724236),'10/1/2015','10/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'1/1/2015','1/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'3/1/2015','3/31/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'4/1/2015','4/30/2015',18,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'6/1/2015','6/30/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'7/1/2015','7/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'10/1/2015','10/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=356345008),'11/1/2014','11/30/2014',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402330035),'2/1/2015','2/28/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402330035),'6/1/2015','6/30/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402330035),'7/1/2015','7/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402330035),'11/1/2014','11/30/2014',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402330035),'12/1/2014','12/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402600328),'7/1/2015','7/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402988343),'1/1/2015','1/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=402988343),'12/1/2014','12/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403089270),'8/1/2015','8/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403089270),'9/1/2015','9/30/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403089270),'10/1/2015','10/31/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403629290),'7/1/2015','7/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403629290),'10/1/2015','10/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403629290),'12/1/2014','12/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403944889),'2/1/2015','2/28/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403944889),'6/1/2015','6/30/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=403944889),'11/1/2014','11/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=405660890),'4/1/2015','4/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=406764965),'6/1/2015','6/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=407885542),'10/1/2015','10/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408044390),'1/1/2015','1/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408044390),'3/1/2015','3/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408044390),'4/1/2015','4/30/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408044390),'11/1/2014','11/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408044390),'12/1/2014','12/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'2/1/2015','2/28/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'3/1/2015','3/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'4/1/2015','4/30/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'6/1/2015','6/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'7/1/2015','7/31/2015',330,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'10/1/2015','10/31/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'1/1/2015','1/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'5/1/2015','5/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'7/1/2015','7/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'9/1/2015','9/30/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'10/1/2015','10/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'11/1/2014','11/30/2014',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'12/1/2014','12/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'1/1/2015','1/31/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'2/1/2015','2/28/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'3/1/2015','3/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'4/1/2015','4/30/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'5/1/2015','5/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'6/1/2015','6/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'7/1/2015','7/31/2015',222,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'8/1/2015','8/31/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'9/1/2015','9/30/2015',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'10/1/2015','10/31/2015',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'11/1/2014','11/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'12/1/2014','12/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=415438614),'1/1/2015','1/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=415438614),'2/1/2015','2/28/2015',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=415438614),'11/1/2014','11/30/2014',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=415438614),'12/1/2014','12/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=415492271),'6/1/2015','6/30/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=415492271),'7/1/2015','7/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'1/1/2015','1/31/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'2/1/2015','2/28/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'3/1/2015','3/31/2015',318,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'4/1/2015','4/30/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'5/1/2015','5/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'6/1/2015','6/30/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'7/1/2015','7/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=419250932),'12/1/2014','12/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=420159094),'12/1/2014','12/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'1/1/2015','1/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'4/1/2015','4/30/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'7/1/2015','7/31/2015',18,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'8/1/2015','8/31/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'10/1/2015','10/31/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'12/1/2014','12/31/2014',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'1/1/2015','1/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'2/1/2015','2/28/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'3/1/2015','3/31/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'4/1/2015','4/30/2015',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'5/1/2015','5/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'6/1/2015','6/30/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'7/1/2015','7/31/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'8/1/2015','8/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'9/1/2015','9/30/2015',354,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'10/1/2015','10/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'11/1/2014','11/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421259455),'12/1/2014','12/31/2014',42,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'1/1/2015','1/31/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'2/1/2015','2/28/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'3/1/2015','3/31/2015',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'5/1/2015','5/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'6/1/2015','6/30/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'10/1/2015','10/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421601084),'11/1/2014','11/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421921523),'1/1/2015','1/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421921523),'4/1/2015','4/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421921523),'6/1/2015','6/30/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421921523),'8/1/2015','8/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421921523),'11/1/2014','11/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=422173051),'12/1/2014','12/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'1/1/2015','1/31/2015',42,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'2/1/2015','2/28/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'3/1/2015','3/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'4/1/2015','4/30/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'5/1/2015','5/31/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'6/1/2015','6/30/2015',342,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'7/1/2015','7/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'8/1/2015','8/31/2015',306,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'9/1/2015','9/30/2015',246,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'10/1/2015','10/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=424821412),'12/1/2014','12/31/2014',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=425597821),'8/1/2015','8/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=425597821),'9/1/2015','9/30/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=425597821),'10/1/2015','10/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'1/1/2015','1/31/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'2/1/2015','2/28/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'3/1/2015','3/31/2015',222,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'4/1/2015','4/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'5/1/2015','5/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'6/1/2015','6/30/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'7/1/2015','7/31/2015',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'8/1/2015','8/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'9/1/2015','9/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'10/1/2015','10/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'11/1/2014','11/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'12/1/2014','12/31/2014',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=427081040),'9/1/2015','9/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=427081040),'10/1/2015','10/31/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=427192788),'6/1/2015','6/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=428064147),'6/1/2015','6/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=429312795),'6/1/2015','6/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=429312795),'8/1/2015','8/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=429312795),'9/1/2015','9/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=429312795),'10/1/2015','10/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431312491),'1/1/2015','1/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431312491),'5/1/2015','5/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431312491),'10/1/2015','10/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431312491),'11/1/2014','11/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431312491),'12/1/2014','12/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'1/1/2015','1/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'2/1/2015','2/28/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'3/1/2015','3/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'4/1/2015','4/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'5/1/2015','5/31/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'6/1/2015','6/30/2015',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'7/1/2015','7/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'8/1/2015','8/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'9/1/2015','9/30/2015',342,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'10/1/2015','10/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'11/1/2014','11/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431493613),'12/1/2014','12/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431537941),'6/1/2015','6/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431537941),'7/1/2015','7/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431766567),'3/1/2015','3/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431766567),'5/1/2015','5/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431766567),'9/1/2015','9/30/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431766567),'10/1/2015','10/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431766567),'11/1/2014','11/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=432397810),'6/1/2015','6/30/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=432397810),'12/1/2014','12/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=432966247),'6/1/2015','6/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433064959),'1/1/2015','1/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433064959),'2/1/2015','2/28/2015',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433064959),'3/1/2015','3/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433064959),'4/1/2015','4/30/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433135503),'4/1/2015','4/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433135503),'7/1/2015','7/31/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433135503),'8/1/2015','8/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433135503),'12/1/2014','12/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433496229),'2/1/2015','2/28/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433599286),'7/1/2015','7/31/2015',18,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433599286),'8/1/2015','8/31/2015',42,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=433657950),'1/1/2015','1/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'1/1/2015','1/31/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'2/1/2015','2/28/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'3/1/2015','3/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'4/1/2015','4/30/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'5/1/2015','5/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'6/1/2015','6/30/2015',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'7/1/2015','7/31/2015',282,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'8/1/2015','8/31/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'9/1/2015','9/30/2015',246,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'10/1/2015','10/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'11/1/2014','11/30/2014',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'12/1/2014','12/31/2014',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'1/1/2015','1/31/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'2/1/2015','2/28/2015',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'3/1/2015','3/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'4/1/2015','4/30/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'7/1/2015','7/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'9/1/2015','9/30/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'11/1/2014','11/30/2014',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434197828),'12/1/2014','12/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'1/1/2015','1/31/2015',330,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'2/1/2015','2/28/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'3/1/2015','3/31/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'4/1/2015','4/30/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'5/1/2015','5/31/2015',306,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'6/1/2015','6/30/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'7/1/2015','7/31/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'11/1/2014','11/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434233821),'12/1/2014','12/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434234825),'1/1/2015','1/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434234825),'11/1/2014','11/30/2014',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434390132),'1/1/2015','1/31/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434390132),'4/1/2015','4/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434390132),'5/1/2015','5/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434390132),'12/1/2014','12/31/2014',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'1/1/2015','1/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'2/1/2015','2/28/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'3/1/2015','3/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'4/1/2015','4/30/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'5/1/2015','5/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'6/1/2015','6/30/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'7/1/2015','7/31/2015',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'8/1/2015','8/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'9/1/2015','9/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'10/1/2015','10/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434451435),'12/1/2014','12/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'1/1/2015','1/31/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'2/1/2015','2/28/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'3/1/2015','3/31/2015',342,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'4/1/2015','4/30/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'6/1/2015','6/30/2015',318,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'7/1/2015','7/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'8/1/2015','8/31/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'9/1/2015','9/30/2015',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'10/1/2015','10/31/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'11/1/2014','11/30/2014',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'12/1/2014','12/31/2014',324,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434656037),'11/1/2014','11/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434726124),'2/1/2015','2/28/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434726124),'6/1/2015','6/30/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434726124),'10/1/2015','10/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434726124),'11/1/2014','11/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'2/1/2015','2/28/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'3/1/2015','3/31/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'4/1/2015','4/30/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'6/1/2015','6/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'7/1/2015','7/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'8/1/2015','8/31/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'9/1/2015','9/30/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'10/1/2015','10/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434801724),'11/1/2014','11/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434924036),'7/1/2015','7/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434943865),'8/1/2015','8/31/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434943865),'9/1/2015','9/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434943865),'10/1/2015','10/31/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434943865),'11/1/2014','11/30/2014',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435194136),'4/1/2015','4/30/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435194136),'5/1/2015','5/31/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435333773),'10/1/2015','10/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435470537),'5/1/2015','5/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435470537),'8/1/2015','8/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435470537),'9/1/2015','9/30/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435470537),'10/1/2015','10/31/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'1/1/2015','1/31/2015',306,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'2/1/2015','2/28/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'3/1/2015','3/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'4/1/2015','4/30/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'5/1/2015','5/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'6/1/2015','6/30/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'11/1/2014','11/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436029295),'12/1/2014','12/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436355036),'5/1/2015','5/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'1/1/2015','1/31/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'2/1/2015','2/28/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'3/1/2015','3/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'4/1/2015','4/30/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'5/1/2015','5/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'6/1/2015','6/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'7/1/2015','7/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436373620),'11/1/2014','11/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'1/1/2015','1/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'2/1/2015','2/28/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'3/1/2015','3/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'4/1/2015','4/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'6/1/2015','6/30/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'7/1/2015','7/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'8/1/2015','8/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'9/1/2015','9/30/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436417940),'12/1/2014','12/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436579249),'12/1/2014','12/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'1/1/2015','1/31/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'2/1/2015','2/28/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'3/1/2015','3/31/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'4/1/2015','4/30/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'8/1/2015','8/31/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'11/1/2014','11/30/2014',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436621069),'12/1/2014','12/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436632957),'10/1/2015','10/31/2015',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'2/1/2015','2/28/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'3/1/2015','3/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'4/1/2015','4/30/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'5/1/2015','5/31/2015',282,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'6/1/2015','6/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'7/1/2015','7/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'8/1/2015','8/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'9/1/2015','9/30/2015',342,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'10/1/2015','10/31/2015',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436900269),'1/1/2015','1/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436900269),'11/1/2014','11/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436900269),'12/1/2014','12/31/2014',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436942660),'11/1/2014','11/30/2014',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436942660),'12/1/2014','12/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436985365),'8/1/2015','8/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'1/1/2015','1/31/2015',324,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'2/1/2015','2/28/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'7/1/2015','7/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'8/1/2015','8/31/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'9/1/2015','9/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'10/1/2015','10/31/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'11/1/2014','11/30/2014',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'12/1/2014','12/31/2014',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437555853),'1/1/2015','1/31/2015',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437555853),'6/1/2015','6/30/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437555853),'7/1/2015','7/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437555853),'8/1/2015','8/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437555853),'11/1/2014','11/30/2014',18,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437555853),'12/1/2014','12/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'1/1/2015','1/31/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'2/1/2015','2/28/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'3/1/2015','3/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'4/1/2015','4/30/2015',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'5/1/2015','5/31/2015',300,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'7/1/2015','7/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'8/1/2015','8/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437678822),'12/1/2014','12/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437708167),'1/1/2015','1/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437708167),'2/1/2015','2/28/2015',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437708167),'3/1/2015','3/31/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437708167),'5/1/2015','5/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437708167),'7/1/2015','7/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437708167),'11/1/2014','11/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437817258),'8/1/2015','8/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437817258),'10/1/2015','10/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437846120),'2/1/2015','2/28/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=438949682),'2/1/2015','2/28/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=438949682),'11/1/2014','11/30/2014',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=438963382),'1/1/2015','1/31/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=438963382),'2/1/2015','2/28/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=438963382),'11/1/2014','11/30/2014',246,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=438963382),'12/1/2014','12/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439252133),'11/1/2014','11/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439494505),'1/1/2015','1/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439494505),'4/1/2015','4/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439494505),'12/1/2014','12/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439536301),'2/1/2015','2/28/2015',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439536301),'3/1/2015','3/31/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439536301),'8/1/2015','8/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439536301),'9/1/2015','9/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439536301),'10/1/2015','10/31/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439631184),'10/1/2015','10/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439730661),'11/1/2014','11/30/2014',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439885028),'2/1/2015','2/28/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439885028),'7/1/2015','7/31/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439885028),'8/1/2015','8/31/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439969907),'6/1/2015','6/30/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'1/1/2015','1/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'2/1/2015','2/28/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'3/1/2015','3/31/2015',330,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'4/1/2015','4/30/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'5/1/2015','5/31/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'6/1/2015','6/30/2015',330,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'7/1/2015','7/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'8/1/2015','8/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=442729381),'12/1/2014','12/31/2014',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'1/1/2015','1/31/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'2/1/2015','2/28/2015',336,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'3/1/2015','3/31/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'4/1/2015','4/30/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'5/1/2015','5/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'7/1/2015','7/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'8/1/2015','8/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=447709470),'11/1/2014','11/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'8/1/2015','8/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'9/1/2015','9/30/2015',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'10/1/2015','10/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'11/1/2014','11/30/2014',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'12/1/2014','12/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450784631),'12/1/2014','12/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=451739178),'1/1/2015','1/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=451739178),'2/1/2015','2/28/2015',270,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=451739178),'3/1/2015','3/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=451739178),'4/1/2015','4/30/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=451739178),'11/1/2014','11/30/2014',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=451739178),'12/1/2014','12/31/2014',282,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=453678831),'4/1/2015','4/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=453678831),'5/1/2015','5/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=453678831),'6/1/2015','6/30/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=453678831),'8/1/2015','8/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=455714323),'7/1/2015','7/31/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=455714323),'8/1/2015','8/31/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'1/1/2015','1/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'3/1/2015','3/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'4/1/2015','4/30/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'5/1/2015','5/31/2015',330,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'6/1/2015','6/30/2015',174,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'7/1/2015','7/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'8/1/2015','8/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'10/1/2015','10/31/2015',342,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=457679867),'8/1/2015','8/31/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'1/1/2015','1/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'4/1/2015','4/30/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'5/1/2015','5/31/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'6/1/2015','6/30/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'7/1/2015','7/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'8/1/2015','8/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'9/1/2015','9/30/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'10/1/2015','10/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'11/1/2014','11/30/2014',54,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'12/1/2014','12/31/2014',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459631886),'7/1/2015','7/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'1/1/2015','1/31/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'2/1/2015','2/28/2015',306,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'3/1/2015','3/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'4/1/2015','4/30/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'5/1/2015','5/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'6/1/2015','6/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'7/1/2015','7/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'8/1/2015','8/31/2015',246,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'9/1/2015','9/30/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'10/1/2015','10/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'11/1/2014','11/30/2014',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'12/1/2014','12/31/2014',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461655795),'2/1/2015','2/28/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461655795),'9/1/2015','9/30/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461655795),'10/1/2015','10/31/2015',318,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'1/1/2015','1/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'3/1/2015','3/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'4/1/2015','4/30/2015',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'6/1/2015','6/30/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'7/1/2015','7/31/2015',300,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'9/1/2015','9/30/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'10/1/2015','10/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'11/1/2014','11/30/2014',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=461706898),'12/1/2014','12/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'1/1/2015','1/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'2/1/2015','2/28/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'3/1/2015','3/31/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'4/1/2015','4/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'5/1/2015','5/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'6/1/2015','6/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'7/1/2015','7/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'8/1/2015','8/31/2015',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'10/1/2015','10/31/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'11/1/2014','11/30/2014',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463069306),'12/1/2014','12/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'1/1/2015','1/31/2015',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'2/1/2015','2/28/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'3/1/2015','3/31/2015',222,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'4/1/2015','4/30/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'5/1/2015','5/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'6/1/2015','6/30/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'7/1/2015','7/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'8/1/2015','8/31/2015',294,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'9/1/2015','9/30/2015',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'10/1/2015','10/31/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'11/1/2014','11/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=463690166),'12/1/2014','12/31/2014',258,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=464619990),'6/1/2015','6/30/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=464619990),'7/1/2015','7/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=464619990),'8/1/2015','8/31/2015',198,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=464619990),'9/1/2015','9/30/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=464619990),'10/1/2015','10/31/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'1/1/2015','1/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'2/1/2015','2/28/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'3/1/2015','3/31/2015',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'4/1/2015','4/30/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'5/1/2015','5/31/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'6/1/2015','6/30/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'7/1/2015','7/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'8/1/2015','8/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'9/1/2015','9/30/2015',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'10/1/2015','10/31/2015',240,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'11/1/2014','11/30/2014',300,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'12/1/2014','12/31/2014',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465728296),'3/1/2015','3/31/2015',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465728296),'12/1/2014','12/31/2014',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'3/1/2015','3/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'4/1/2015','4/30/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'5/1/2015','5/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'6/1/2015','6/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'11/1/2014','11/30/2014',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'12/1/2014','12/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=479963168),'5/1/2015','5/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=479963168),'6/1/2015','6/30/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=479963168),'7/1/2015','7/31/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=487848269),'11/1/2014','11/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=487848269),'12/1/2014','12/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'1/1/2015','1/31/2015',354,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'2/1/2015','2/28/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'3/1/2015','3/31/2015',138,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'4/1/2015','4/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'5/1/2015','5/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'6/1/2015','6/30/2015',360,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'7/1/2015','7/31/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'8/1/2015','8/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'9/1/2015','9/30/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'10/1/2015','10/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'11/1/2014','11/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'12/1/2014','12/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'1/1/2015','1/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'2/1/2015','2/28/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'3/1/2015','3/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'4/1/2015','4/30/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'5/1/2015','5/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'6/1/2015','6/30/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'9/1/2015','9/30/2015',24,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'10/1/2015','10/31/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'11/1/2014','11/30/2014',222,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'12/1/2014','12/31/2014',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492849146),'4/1/2015','4/30/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492849146),'8/1/2015','8/31/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492849146),'9/1/2015','9/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=493764259),'5/1/2015','5/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=493764259),'6/1/2015','6/30/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=493764259),'7/1/2015','7/31/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=493764259),'10/1/2015','10/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'1/1/2015','1/31/2015',150,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'2/1/2015','2/28/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'3/1/2015','3/31/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'4/1/2015','4/30/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'5/1/2015','5/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'6/1/2015','6/30/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'7/1/2015','7/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'8/1/2015','8/31/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'9/1/2015','9/30/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'10/1/2015','10/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'11/1/2014','11/30/2014',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'12/1/2014','12/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496720423),'1/1/2015','1/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496720423),'3/1/2015','3/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496720423),'5/1/2015','5/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496720423),'11/1/2014','11/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496788834),'8/1/2015','8/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496982026),'6/1/2015','6/30/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496982026),'7/1/2015','7/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498560117),'4/1/2015','4/30/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498560117),'5/1/2015','5/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498560117),'6/1/2015','6/30/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498560117),'7/1/2015','7/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498560117),'11/1/2014','11/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498707535),'2/1/2015','2/28/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498707535),'6/1/2015','6/30/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=498707535),'11/1/2014','11/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=557171646),'10/1/2015','10/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=572707640),'11/1/2014','11/30/2014',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'1/1/2015','1/31/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'2/1/2015','2/28/2015',288,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'3/1/2015','3/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'4/1/2015','4/30/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'10/1/2015','10/31/2015',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'11/1/2014','11/30/2014',162,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'12/1/2014','12/31/2014',348,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'2/1/2015','2/28/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'3/1/2015','3/31/2015',336,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'4/1/2015','4/30/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'5/1/2015','5/31/2015',372,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'6/1/2015','6/30/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'7/1/2015','7/31/2015',264,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'8/1/2015','8/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'9/1/2015','9/30/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'10/1/2015','10/31/2015',186,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'11/1/2014','11/30/2014',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587864140),'12/1/2014','12/31/2014',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=592466786),'1/1/2015','1/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=592466786),'5/1/2015','5/31/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=592466786),'6/1/2015','6/30/2015',120,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=592466786),'7/1/2015','7/31/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=592466786),'8/1/2015','8/31/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=632281069),'2/1/2015','2/28/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=632281069),'3/1/2015','3/31/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=632281069),'4/1/2015','4/30/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=632281069),'5/1/2015','5/31/2015',294,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=632281069),'6/1/2015','6/30/2015',42,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=644011439),'1/1/2015','1/31/2015',312,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=644011439),'2/1/2015','2/28/2015',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=644011439),'4/1/2015','4/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=644011439),'7/1/2015','7/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=644011439),'11/1/2014','11/30/2014',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=644011439),'12/1/2014','12/31/2014',66,0,2666,GETDATE(),0
-----------------------------------------------------------------------------------------------------------------------------------
 insert into TempEmployeeTimesheet
 Select (select ID from Employee where SocialSecurityNo=007646904),'11/1/2013','11/30/2013',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=233887994),'1/1/2014','1/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'11/1/2013','11/30/2013',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'12/1/2013','12/31/2013',222,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'1/1/2014','1/31/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'3/1/2014','3/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'4/1/2014','4/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'4/1/2014','4/30/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'5/1/2014','5/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=235868325),'6/1/2014','6/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=242083179),'7/1/2014','7/31/2014',294,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=242083179),'8/1/2014','8/31/2014',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=242083179),'9/1/2014','9/30/2014',234,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=242083179),'10/1/2014','10/31/2014',186,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=243889862),'5/1/2014','5/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=256857177),'11/1/2013','11/30/2013',228,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=256857177),'12/1/2013','12/31/2013',282,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=256857177),'1/1/2014','1/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=256857177),'2/1/2014','2/28/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=256857177),'3/1/2014','3/31/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=256857177),'7/1/2014','7/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'11/1/2013','11/30/2013',300,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'12/1/2013','12/31/2013',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'1/1/2014','1/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'2/1/2014','2/28/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'3/1/2014','3/31/2014',282,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'4/1/2014','4/30/2014',270,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=277420394),'5/1/2014','5/31/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=281802109),'1/1/2014','1/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=281802109),'2/1/2014','2/28/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=281802109),'3/1/2014','3/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=281802109),'4/1/2014','4/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=281802109),'10/1/2014','10/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=283649599),'1/1/2014','1/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=283649599),'2/1/2014','2/28/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=283649599),'3/1/2014','3/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=283649599),'4/1/2014','4/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=299608823),'6/1/2014','6/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=299608823),'11/1/2013','11/30/2013',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=304586997),'11/1/2013','11/30/2013',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=312627354),'1/1/2014','1/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=312627354),'2/1/2014','2/28/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=312627354),'4/1/2014','4/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=312627354),'8/1/2014','8/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=312627354),'9/1/2014','9/30/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=312627354),'10/1/2014','10/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=313783576),'5/1/2014','5/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=313783576),'6/1/2014','6/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=323549143),'1/1/2014','1/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=323549143),'4/1/2014','4/30/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=323549143),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324402904),'1/1/2014','1/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324402904),'2/1/2014','2/28/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'1/1/2014','1/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'2/1/2014','2/28/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'3/1/2014','3/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'4/1/2014','4/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'6/1/2014','6/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'7/1/2014','7/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'9/1/2014','9/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'10/1/2014','10/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'11/1/2013','11/30/2013',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=324403432),'12/1/2013','12/31/2013',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=327463604),'10/1/2014','10/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=328624752),'8/1/2014','8/31/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'1/1/2014','1/31/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'2/1/2014','2/28/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'3/1/2014','3/31/2014',210,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'4/1/2014','4/30/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'5/1/2014','5/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'6/1/2014','6/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'7/1/2014','7/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'8/1/2014','8/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'9/1/2014','9/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'10/1/2014','10/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'11/1/2013','11/30/2013',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=341660814),'12/1/2013','12/31/2013',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=342601106),'8/1/2014','8/31/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'1/1/2014','1/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'2/1/2014','2/28/2014',300,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'3/1/2014','3/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'4/1/2014','4/30/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'5/1/2014','5/31/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'6/1/2014','6/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'7/1/2014','7/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'8/1/2014','8/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'9/1/2014','9/30/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'10/1/2014','10/31/2014',252,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'11/1/2013','11/30/2013',348,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=346461441),'12/1/2013','12/31/2013',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=347449180),'7/1/2014','7/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=347449180),'8/1/2014','8/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=347449180),'10/1/2014','10/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=349400659),'1/1/2014','1/31/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=349400659),'2/1/2014','2/28/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=350343386),'10/1/2014','10/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=355605052),'5/1/2014','5/31/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=359745231),'3/1/2014','3/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=359745231),'6/1/2014','6/30/2014',300,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=359745231),'7/1/2014','7/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=388941665),'6/1/2014','6/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=400316772),'2/1/2014','2/28/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=400316772),'8/1/2014','8/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=400686640),'2/1/2014','2/28/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=400686640),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=402707547),'11/1/2013','11/30/2013',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=402707547),'12/1/2013','12/31/2013',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=402988343),'1/1/2014','1/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=402988343),'2/1/2014','2/28/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=402988343),'3/1/2014','3/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403629290),'1/1/2014','1/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403629290),'2/1/2014','2/28/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403629290),'6/1/2014','6/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403629290),'10/1/2014','10/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403629290),'12/1/2013','12/31/2013',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403944889),'1/1/2014','1/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403944889),'2/1/2014','2/28/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403944889),'7/1/2014','7/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=403944889),'10/1/2014','10/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=404407175),'11/1/2013','11/30/2013',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=405191929),'5/1/2014','5/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=405191929),'6/1/2014','6/30/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=406688152),'1/1/2014','1/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=406688152),'12/1/2013','12/31/2013',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408044390),'2/1/2014','2/28/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408044390),'6/1/2014','6/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408044390),'8/1/2014','8/31/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408044390),'12/1/2013','12/31/2013',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408137063),'5/1/2014','5/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408137063),'6/1/2014','6/30/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408137063),'7/1/2014','7/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408137063),'8/1/2014','8/31/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408137063),'9/1/2014','9/30/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408137063),'10/1/2014','10/31/2014',258,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408456931),'8/1/2014','8/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408470146),'11/1/2013','11/30/2013',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408470146),'12/1/2013','12/31/2013',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408470146),'3/1/2014','3/31/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=408470146),'5/1/2014','5/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=409889476),'4/1/2014','4/30/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=409889476),'8/1/2014','8/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'1/1/2014','1/31/2014',228,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'2/1/2014','2/28/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'3/1/2014','3/31/2014',240,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'6/1/2014','6/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'7/1/2014','7/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'8/1/2014','8/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'9/1/2014','9/30/2014',228,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'10/1/2014','10/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=410660642),'11/1/2013','11/30/2013',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'2/1/2014','2/28/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'3/1/2014','3/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'4/1/2014','4/30/2014',228,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'5/1/2014','5/31/2014',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'6/1/2014','6/30/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'7/1/2014','7/31/2014',324,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'8/1/2014','8/31/2014',234,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'9/1/2014','9/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'10/1/2014','10/31/2014',324,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'11/1/2013','11/30/2013',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=411702977),'12/1/2013','12/31/2013',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=415438614),'11/1/2013','11/30/2013',186,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=415438614),'12/1/2013','12/31/2013',222,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=415438614),'5/1/2014','5/31/2014',294,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=415438614),'6/1/2014','6/30/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=415438614),'9/1/2014','9/30/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=415438614),'10/1/2014','10/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=420159094),'9/1/2014','9/30/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=420159094),'10/1/2014','10/31/2014',114,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421130865),'6/1/2014','6/30/2014',126,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421130865),'7/1/2014','7/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421130865),'8/1/2014','8/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421130865),'9/1/2014','9/30/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421259455),'5/1/2014','5/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421259455),'7/1/2014','7/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421259455),'8/1/2014','8/31/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421259455),'9/1/2014','9/30/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421259455),'10/1/2014','10/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'11/1/2013','11/30/2013',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'12/1/2013','12/31/2013',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'1/1/2014','1/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'2/1/2014','2/28/2014',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'3/1/2014','3/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'4/1/2014','4/30/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'5/1/2014','5/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'6/1/2014','6/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'7/1/2014','7/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'8/1/2014','8/31/2014',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421601084),'10/1/2014','10/31/2014',174,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421921523),'4/1/2014','4/30/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421921523),'5/1/2014','5/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421921523),'6/1/2014','6/30/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421921523),'8/1/2014','8/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421921523),'9/1/2014','9/30/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=421921523),'10/1/2014','10/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=424821412),'7/1/2014','7/31/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=424821412),'8/1/2014','8/31/2014',126,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=424821412),'10/1/2014','10/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=425312247),'3/1/2014','3/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=425312247),'4/1/2014','4/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=425578349),'7/1/2014','7/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=425578349),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=425578349),'10/1/2014','10/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'11/1/2013','11/30/2013',174,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'12/1/2013','12/31/2013',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'1/1/2014','1/31/2014',186,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'2/1/2014','2/28/2014',174,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'3/1/2014','3/31/2014',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'4/1/2014','4/30/2014',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'4/1/2014','4/30/2014',126,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'5/1/2014','5/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'6/1/2014','6/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'7/1/2014','7/31/2014',174,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'8/1/2014','8/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'9/1/2014','9/30/2014',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426319727),'10/1/2014','10/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426864605),'10/1/2014','10/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426982078),'12/1/2013','12/31/2013',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=426982078),'1/1/2014','1/31/2014',354,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=427192788),'1/1/2014','1/31/2014',294,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=427192788),'2/1/2014','2/28/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=427192788),'3/1/2014','3/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=427192788),'4/1/2014','4/30/2014',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=427358124),'6/1/2014','6/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=428064147),'4/1/2014','4/30/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=428064147),'7/1/2014','7/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=428195448),'1/1/2014','1/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=428195448),'11/1/2013','11/30/2013',312,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=428195448),'12/1/2013','12/31/2013',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=429312795),'12/1/2013','12/31/2013',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=429410595),'8/1/2014','8/31/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=429410595),'9/1/2014','9/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431312491),'1/1/2014','1/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431312491),'2/1/2014','2/28/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431312491),'3/1/2014','3/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431312491),'10/1/2014','10/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431312491),'12/1/2013','12/31/2013',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431493371),'6/1/2014','6/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'2/1/2014','2/28/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'4/1/2014','4/30/2014',228,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'5/1/2014','5/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'6/1/2014','6/30/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'7/1/2014','7/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'8/1/2014','8/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'9/1/2014','9/30/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'10/1/2014','10/31/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=431766567),'11/1/2013','11/30/2013',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=432397810),'4/1/2014','4/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=432397810),'5/1/2014','5/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433135503),'11/1/2013','11/30/2013',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433135503),'12/1/2013','12/31/2013',54,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433135503),'1/1/2014','1/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433135503),'2/1/2014','2/28/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433135503),'4/1/2014','4/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433135503),'6/1/2014','6/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433235174),'11/1/2013','11/30/2013',198,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433235174),'12/1/2013','12/31/2013',174,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433235174),'1/1/2014','1/31/2014',186,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433235174),'2/1/2014','2/28/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433278693),'4/1/2014','4/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433579657),'11/1/2013','11/30/2013',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=433969192),'7/1/2014','7/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434028758),'11/1/2013','11/30/2013',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434028758),'12/1/2013','12/31/2013',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434028758),'1/1/2014','1/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434028758),'6/1/2014','6/30/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434133236),'7/1/2014','7/31/2014',210,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434133236),'8/1/2014','8/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434133236),'9/1/2014','9/30/2014',234,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434219786),'7/1/2014','7/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'12/1/2013','12/31/2013',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'1/1/2014','1/31/2014',174,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'2/1/2014','2/28/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'3/1/2014','3/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'4/1/2014','4/30/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'5/1/2014','5/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'6/1/2014','6/30/2014',210,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'7/1/2014','7/31/2014',270,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'8/1/2014','8/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'9/1/2014','9/30/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434233821),'10/1/2014','10/31/2014',270,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434234825),'7/1/2014','7/31/2014',246,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434234825),'8/1/2014','8/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434234825),'10/1/2014','10/31/2014',330,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434336404),'8/1/2014','8/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434390132),'9/1/2014','9/30/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434390132),'10/1/2014','10/31/2014',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434656037),'7/1/2014','7/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434656037),'8/1/2014','8/31/2014',240,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434656037),'9/1/2014','9/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434656037),'10/1/2014','10/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'1/1/2014','1/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'2/1/2014','2/28/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'3/1/2014','3/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'4/1/2014','4/30/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'5/1/2014','5/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'6/1/2014','6/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'10/1/2014','10/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'11/1/2013','11/30/2013',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434726124),'12/1/2013','12/31/2013',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434801724),'8/1/2014','8/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434801724),'9/1/2014','9/30/2014',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434801724),'10/1/2014','10/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=434943865),'10/1/2014','10/31/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435194136),'5/1/2014','5/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435333773),'4/1/2014','4/30/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435470537),'8/1/2014','8/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435470537),'9/1/2014','9/30/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435470537),'10/1/2014','10/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435986634),'5/1/2014','5/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=435986634),'6/1/2014','6/30/2014',54,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'4/1/2014','4/30/2014',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'5/1/2014','5/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'6/1/2014','6/30/2014',270,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'7/1/2014','7/31/2014',354,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'8/1/2014','8/31/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'9/1/2014','9/30/2014',270,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436029295),'10/1/2014','10/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436355036),'8/1/2014','8/31/2014',114,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436355036),'9/1/2014','9/30/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'11/1/2013','11/30/2013',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'12/1/2013','12/31/2013',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'1/1/2014','1/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'2/1/2014','2/28/2014',114,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'3/1/2014','3/31/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'4/1/2014','4/30/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'5/1/2014','5/31/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'6/1/2014','6/30/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'7/1/2014','7/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'8/1/2014','8/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'9/1/2014','9/30/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436373620),'10/1/2014','10/31/2014',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436433506),'8/1/2014','8/31/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436470174),'10/1/2014','10/31/2014',114,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436621069),'12/1/2013','12/31/2013',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436621069),'6/1/2014','6/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436621069),'8/1/2014','8/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436621069),'9/1/2014','9/30/2014',324,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436621069),'10/1/2014','10/31/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'1/1/2014','1/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'2/1/2014','2/28/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'3/1/2014','3/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'4/1/2014','4/30/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'5/1/2014','5/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'6/1/2014','6/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'7/1/2014','7/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'9/1/2014','9/30/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'10/1/2014','10/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'11/1/2013','11/30/2013',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436900269),'12/1/2013','12/31/2013',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436985365),'12/1/2013','12/31/2013',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436985365),'4/1/2014','4/30/2014',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436985365),'5/1/2014','5/31/2014',54,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=436985365),'6/1/2014','6/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'1/1/2014','1/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'2/1/2014','2/28/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'3/1/2014','3/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'4/1/2014','4/30/2014',348,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'5/1/2014','5/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'6/1/2014','6/30/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'7/1/2014','7/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'8/1/2014','8/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'9/1/2014','9/30/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'10/1/2014','10/31/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'11/1/2013','11/30/2013',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437061095),'12/1/2013','12/31/2013',324,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'1/1/2014','1/31/2014',54,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'2/1/2014','2/28/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'3/1/2014','3/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'4/1/2014','4/30/2014',114,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'5/1/2014','5/31/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'6/1/2014','6/30/2014',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'7/1/2014','7/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437170252),'8/1/2014','8/31/2014',258,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437414958),'8/1/2014','8/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437555853),'9/1/2014','9/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437555853),'10/1/2014','10/31/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437708167),'9/1/2014','9/30/2014',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437708167),'10/1/2014','10/31/2014',234,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437800194),'11/1/2013','11/30/2013',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437846120),'7/1/2014','7/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437847916),'1/1/2014','1/31/2014',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=437847916),'2/1/2014','2/28/2014',306,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438591609),'11/1/2013','11/30/2013',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438949682),'3/1/2014','3/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438949682),'3/1/2014','3/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438949682),'4/1/2014','4/30/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438949682),'5/1/2014','5/31/2014',186,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438949682),'8/1/2014','8/31/2014',150,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438949682),'9/1/2014','9/30/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438963382),'5/1/2014','5/31/2014',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438963382),'6/1/2014','6/30/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=438963382),'10/1/2014','10/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439252133),'6/1/2014','6/30/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439252133),'7/1/2014','7/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439252133),'8/1/2014','8/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439252133),'10/1/2014','10/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439747123),'3/1/2014','3/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439747123),'4/1/2014','4/30/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439884658),'7/1/2014','7/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439885028),'7/1/2014','7/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439885028),'9/1/2014','9/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439969907),'4/1/2014','4/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439969907),'5/1/2014','5/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=439969907),'12/1/2013','12/31/2013',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=442729381),'7/1/2014','7/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'1/1/2014','1/31/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'2/1/2014','2/28/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'3/1/2014','3/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'4/1/2014','4/30/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'5/1/2014','5/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'6/1/2014','6/30/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'7/1/2014','7/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'8/1/2014','8/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=447709470),'10/1/2014','10/31/2014',186,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=450654719),'2/1/2014','2/28/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=450654719),'3/1/2014','3/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=450654719),'4/1/2014','4/30/2014',18,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=450654719),'4/1/2014','4/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=450654719),'5/1/2014','5/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=450654719),'6/1/2014','6/30/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=451739178),'8/1/2014','8/31/2014',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=451739178),'9/1/2014','9/30/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=451739178),'10/1/2014','10/31/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'1/1/2014','1/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'4/1/2014','4/30/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'5/1/2014','5/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'6/1/2014','6/30/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'7/1/2014','7/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'9/1/2014','9/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'10/1/2014','10/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'11/1/2013','11/30/2013',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=453678831),'12/1/2013','12/31/2013',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455411170),'11/1/2013','11/30/2013',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455411170),'12/1/2013','12/31/2013',138,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455411170),'1/1/2014','1/31/2014',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455411170),'2/1/2014','2/28/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455411170),'3/1/2014','3/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'1/1/2014','1/31/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'2/1/2014','2/28/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'3/1/2014','3/31/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'4/1/2014','4/30/2014',222,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'5/1/2014','5/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'6/1/2014','6/30/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'7/1/2014','7/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=455432508),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=456870476),'10/1/2014','10/31/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=457679867),'8/1/2014','8/31/2014',66,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=457679867),'9/1/2014','9/30/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=458906599),'4/1/2014','4/30/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=458906599),'5/1/2014','5/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=458906599),'6/1/2014','6/30/2014',258,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=458906599),'7/1/2014','7/31/2014',102,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=458906599),'8/1/2014','8/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'11/1/2013','11/30/2013',42,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'12/1/2013','12/31/2013',282,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'1/1/2014','1/31/2014',294,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'2/1/2014','2/28/2014',198,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'3/1/2014','3/31/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'4/1/2014','4/30/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'5/1/2014','5/31/2014',294,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'6/1/2014','6/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'7/1/2014','7/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'8/1/2014','8/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'9/1/2014','9/30/2014',282,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=459787874),'10/1/2014','10/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=460614299),'7/1/2014','7/31/2014',252,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=460614299),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=460614299),'9/1/2014','9/30/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=460614299),'10/1/2014','10/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461655795),'10/1/2014','10/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'1/1/2014','1/31/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'2/1/2014','2/28/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'3/1/2014','3/31/2014',306,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'4/1/2014','4/30/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'5/1/2014','5/31/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'6/1/2014','6/30/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'7/1/2014','7/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'8/1/2014','8/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'9/1/2014','9/30/2014',300,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'10/1/2014','10/31/2014',114,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'11/1/2013','11/30/2013',324,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=461706898),'12/1/2013','12/31/2013',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'1/1/2014','1/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'2/1/2014','2/28/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'3/1/2014','3/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'4/1/2014','4/30/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'5/1/2014','5/31/2014',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'6/1/2014','6/30/2014',294,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'7/1/2014','7/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'8/1/2014','8/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'9/1/2014','9/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463069306),'10/1/2014','10/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'4/1/2014','4/30/2014',54,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'5/1/2014','5/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'6/1/2014','6/30/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'7/1/2014','7/31/2014',246,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'8/1/2014','8/31/2014',198,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'9/1/2014','9/30/2014',288,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=463690166),'10/1/2014','10/31/2014',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'1/1/2014','1/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'2/1/2014','2/28/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'3/1/2014','3/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'4/1/2014','4/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'5/1/2014','5/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'6/1/2014','6/30/2014',318,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'7/1/2014','7/31/2014',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'8/1/2014','8/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'9/1/2014','9/30/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'10/1/2014','10/31/2014',240,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'11/1/2013','11/30/2013',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465172532),'12/1/2013','12/31/2013',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'1/1/2014','1/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'3/1/2014','3/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'4/1/2014','4/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'7/1/2014','7/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'8/1/2014','8/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'11/1/2013','11/30/2013',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=465728296),'12/1/2013','12/31/2013',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'1/1/2014','1/31/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'2/1/2014','2/28/2014',216,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'3/1/2014','3/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'4/1/2014','4/30/2014',168,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'5/1/2014','5/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'6/1/2014','6/30/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'7/1/2014','7/31/2014',108,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'8/1/2014','8/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'9/1/2014','9/30/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'10/1/2014','10/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=469585301),'12/1/2013','12/31/2013',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=487848269),'8/1/2014','8/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=487848269),'9/1/2014','9/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'1/1/2014','1/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'2/1/2014','2/28/2014',336,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'3/1/2014','3/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'4/1/2014','4/30/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'5/1/2014','5/31/2014',276,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'6/1/2014','6/30/2014',264,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'7/1/2014','7/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'8/1/2014','8/31/2014',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'9/1/2014','9/30/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'10/1/2014','10/31/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'11/1/2013','11/30/2013',348,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=488509001),'12/1/2013','12/31/2013',372,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=492849146),'11/1/2013','11/30/2013',30,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=492849146),'2/1/2014','2/28/2014',6,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=492849146),'3/1/2014','3/31/2014',78,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=492849146),'5/1/2014','5/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=492849146),'7/1/2014','7/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=492849146),'8/1/2014','8/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=493764259),'1/1/2014','1/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=493764259),'2/1/2014','2/28/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=493764259),'7/1/2014','7/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=493764259),'8/1/2014','8/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=493764259),'11/1/2013','11/30/2013',24,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=493764259),'12/1/2013','12/31/2013',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'4/1/2014','4/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'5/1/2014','5/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'6/1/2014','6/30/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'7/1/2014','7/31/2014',252,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'8/1/2014','8/31/2014',162,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'9/1/2014','9/30/2014',240,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=494482094),'10/1/2014','10/31/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=496720423),'5/1/2014','5/31/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=496720423),'8/1/2014','8/31/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=496720423),'9/1/2014','9/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=496720423),'10/1/2014','10/31/2014',36,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'1/1/2014','1/31/2014',90,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'2/1/2014','2/28/2014',54,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'3/1/2014','3/31/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'4/1/2014','4/30/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'5/1/2014','5/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'6/1/2014','6/30/2014',60,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'7/1/2014','7/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'9/1/2014','9/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'11/1/2013','11/30/2013',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498560117),'12/1/2013','12/31/2013',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=498707535),'7/1/2014','7/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=569239336),'10/1/2014','10/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=572707640),'1/1/2014','1/31/2014',132,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=572707640),'5/1/2014','5/31/2014',144,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=572707640),'6/1/2014','6/30/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=572707640),'7/1/2014','7/31/2014',48,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=572707640),'8/1/2014','8/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587038869),'11/1/2013','11/30/2013',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587038869),'1/1/2014','1/31/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587520677),'1/1/2014','1/31/2014',72,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587520677),'2/1/2014','2/28/2014',156,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587520677),'3/1/2014','3/31/2014',12,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587520677),'4/1/2014','4/30/2014',180,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587520677),'8/1/2014','8/31/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'2/1/2014','2/28/2014',192,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'4/1/2014','4/30/2014',120,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'6/1/2014','6/30/2014',96,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'7/1/2014','7/31/2014',300,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'8/1/2014','8/31/2014',84,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'9/1/2014','9/30/2014',360,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=587864140),'10/1/2014','10/31/2014',204,0,2666,GETDATE(),0 UNION ALL 
 Select (select ID from Employee where SocialSecurityNo=644011439),'10/1/2014','10/31/2014',480,0,2666,GETDATE(),0 
 --------------------------------------------------------------------------------------------------------------------------------
 insert into TempEmployeeTimesheet
Select (select ID from Employee where SocialSecurityNo=166584825),'11/1/2015','11/30/2015',210,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'11/1/2015','11/30/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=242083179),'11/1/2015','11/30/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=408137063),'11/1/2015','11/30/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=421130865),'11/1/2015','11/30/2015',6,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=425597821),'11/1/2015','11/30/2015',90,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=426319727),'12/1/2015','12/31/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=427081040),'12/1/2015','12/31/2015',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434133236),'11/1/2015','11/30/2015',228,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434391177),'12/1/2015','12/31/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434391177),'12/1/2015','12/31/2015',78,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434634132),'11/1/2015','11/30/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435310075),'11/1/2015','11/30/2015',96,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=435333773),'11/1/2015','11/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436632957),'11/1/2015','11/30/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'11/1/2015','11/30/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=436761300),'12/1/2015','12/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437817258),'12/1/2015','12/31/2015',126,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439519452),'11/1/2015','11/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'11/1/2015','11/30/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=450654719),'12/1/2015','12/31/2015',114,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=456870476),'11/1/2015','11/30/2015',234,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'11/1/2015','11/30/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=458906599),'12/1/2015','12/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=459787874),'12/1/2015','12/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=557171646),'11/1/2015','11/30/2015',30,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=557171646),'12/1/2015','12/31/2015',102,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=185527979),'11/1/2015','11/30/2015',216,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=244434105),'11/1/2015','11/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=299608823),'11/1/2015','11/30/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'11/1/2015','11/30/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=312627354),'12/1/2015','12/31/2015',66,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'11/1/2015','11/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=324403432),'12/1/2015','12/31/2015',48,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=341660814),'11/1/2015','11/30/2015',276,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=346461441),'11/1/2015','11/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=410660642),'11/1/2015','11/30/2015',192,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'11/1/2015','11/30/2015',144,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=411702977),'12/1/2015','12/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=431537941),'12/1/2015','12/31/2015',132,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=434726124),'11/1/2015','11/30/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=437061095),'11/1/2015','11/30/2015',282,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=439631184),'11/1/2015','11/30/2015',36,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=465172532),'11/1/2015','11/30/2015',168,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=469585301),'11/1/2015','11/30/2015',60,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'11/1/2015','11/30/2015',252,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=488509001),'12/1/2015','12/31/2015',204,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=492543104),'12/1/2015','12/31/2015',72,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=493764259),'11/1/2015','11/30/2015',12,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'11/1/2015','11/30/2015',108,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=494482094),'12/1/2015','12/31/2015',156,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=496720423),'11/1/2015','11/30/2015',180,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587571007),'12/1/2015','12/31/2015',84,0,2666,GETDATE(),0 UNION ALL 
Select (select ID from Employee where SocialSecurityNo=587589794),'11/1/2015','11/30/2015',60,0,2666,GETDATE(),0
------------------------------------------------------------------------------------------------------------------------------------
-- CURSOR TO UPDTE RECORD IF RECORD EXIST AND TO INSERT IF IT DOESN'T

DECLARE @EmployeeID BIGINT
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
DECLARE @TotalHours INT
DECLARE @IsCompanyUser BIT
DECLARE @UserID INT
DECLARE @DatetimeStamp DATETIME
DECLARE @EmployeeTypeID INT

DECLARE @MyCursor CURSOR
SET @MyCursor = CURSOR FAST_FORWARD
FOR
SELECT EmployeeID,StartDate,EndDate,TotalHours,IsCompanyUser,UserID,DatetimeStamp,EmployeeTypeID 
FROM   TempEmployeeTimesheet 
OPEN @MyCursor
FETCH NEXT FROM @MyCursor
INTO @EmployeeID,@StartDate,@EndDate,@TotalHours,@IsCompanyUser,@UserID,@DatetimeStamp,@EmployeeTypeID
WHILE @@FETCH_STATUS = 0
BEGIN
	IF EXISTS(SELECT * from EmployeeInOutTimings WHERE EmployeeID=@EmployeeID AND DATEDIFF(DAY,@StartDate,StartDate)=0 AND DATEDIFF(DAY,@EndDate,EndDate)=0 )
	BEGIN
		UPDATE EmployeeInOutTimings
		SET TotalHours=@TotalHours
		WHERE EmployeeID=@EmployeeID AND DATEDIFF(DAY,@StartDate,StartDate)=0 AND DATEDIFF(DAY,@EndDate,EndDate)=0
	END
	ELSE
	BEGIN
		INSERT INTO EmployeeInOutTimings(EmployeeID,StartDate,EndDate,TotalHours,IsCompanyUser,UserID,DatetimeStamp,EmployeeTypeID)
		SELECT @EmployeeID,@StartDate,@EndDate,@TotalHours,@IsCompanyUser,@UserID,@DatetimeStamp,@EmployeeTypeID
	END
 
FETCH NEXT FROM @MyCursor
INTO @EmployeeID,@StartDate,@EndDate,@TotalHours,@IsCompanyUser,@UserID,@DatetimeStamp,@EmployeeTypeID
END
CLOSE @MyCursor
DEALLOCATE @MyCursor
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
DROP TABLE TempEmployeeTimesheet

