insert into Employees (EmpID, EmpFirst, EmpLast, WareHouseID, SSN, DOB, StartDate, EndDate, Address, City, State, ZIP, PositionID, Memo, Phone, Cell, Salary, HourlyRate, Review)
values
('1','David','Bowers','WA-1','154003785','1985-09-12','1998-01-22',null,'10124 Metropolitan Drive','Seattle','WA','98117','1',null,'2062465132','2065754321','72,000.00',null,null),
('2','Robert','Iko','WA-1','705246513','1994-12-16','2006-12-15	',null,'698 Round Mountain','Seattle','WA','98124','7',null,'2065472315','2064875312','59,500.00',null,'2007-06-15'),
('3','Virginia','Sanchez','WA-1','724568132','1988-10-24','2004-06-10',null,'201 River Road','Spokane','WA','99215','2','Emergency contact for alarm company','5093451687','5096348732','48,500.00',null,'2007-12-15'),
('4','Eric','Behrens','WY-1','956346120','1995-02-14','2005-09-12','2006-02-15','21 Adrian Way','Jackson Hole','WY','83005','3',null,'3075461272','3075763154',null,'12.50',null),
('7','Brian','Castillo','OR-1','923546124','1990-08-14','2001-06-14	',null,'52 Denton Drive #49','Portland','OR','97205','3',null,'5035742742','5035647154',null,'12.75','2008-06-14'),
('8','Cynthia','Cox','OR-1','854230000','1985-10-06','2006-12-30',null,'1515 Patterson Road','Portland','OR','97210','2',null,'5032412423','5035496113','50,000.00',null,'2007-06-30'),
('9','John','Maestas','WA-1','487002468','1995-11-24','2001-11-15',null,'5506 Beach Street West','Spokane','WA','99216','4','Speaks fluent Spanish','5096741543','5093782312','42,500.00',null,'2007-11-01'),
('10','Mark','Cumberland','OR-1','705435126','1996-07-30','2002-10-01','2006-03-15','16542 Angus Road #280','Portland','OR','97206','6',null,'5032486453','5032786424',null,'12.25',null),
('11','Darnell','Colmenero','WA-1','723549785','1997-04-05','2002-09-02',null,'6000 Balcones Drive','Seattle','WA','98113','3',null,'2063475354','2063547215',null,'15.00','2008-09-15'),
('12','James','Lu','WY-1','709564321','1999-12-31','2005-02-24',null,'5003 Mallard Avenue #587','Jackson Hole','WY','83001','2','Speaks fluent Chinese','3076784513','3072468732','48,500.00',null,'2007-02-24'),
('13','Barry','Orosco','WA-1','723246875','1989-07-04','2006-03-21','2006-05-15','2001 Kenosha Pass','Spokane','WA','99216','5',null,'5093451357','5093575166',null,'9.75',null),
('14','Richard','Hargadon','WA-1','984651372','1991-03-01','2006-07-15',null,'901 Great Oaks Cove','Seattle','WA','98154','6',null,'2063547987','2063541287',null,'10.50','2007-08-15'),
('15','John','Nader','WY-1','905346755','1992-04-24','2001-08-01',null,'321 Sturgis	Jackson Hole','WY','83001','3',null,'3075467135','3072468731',null,'11.25','2008-08-01'),
('16','George','Medrano','WA-1','546570000','1994-04-10','2006-10-15',null,'3987 NW 87th Street #8','Seattle','WA','98124','6',null,'2063412024','2063241200',null,'11.25','2008-10-15'),
('17','Rachel','Goodman','OR-1','978451342','1997-06-21','2004-11-03',null,'9876 Parker Street','Portland','OR','97204','5','On maternity leave through 12/2008','5032415756','5032175613',null,'12.75','2008-01-15'),
('18','Shayla','Anderson','WA-1','926543210','1988-09-28','2003-09-24',null,'4321 Barton Cliff Drive','Seattle','WA','98124','6',null,'2063214571','2063218756',null,',12.50','2008-09-15'),
('19','Alfonso','Ozmun','WA-1','946532100','1990-05-30','2005-06-15',null,'510 Immanuel Avenue','Seattle','WA','98126','5',null,'2063124024','2062497513',null,'12.00','2008-02-28'),
('20','Sophia','Nunis','WA-1','987451372','1989-12-12','2006-10-20',null,'5471 Wyoming Springs Way','Spokane','WA','99214','6',null,'5093478992','5098973246',null,'12.00','2008-01-15'),
('21','Dora	','Nettles','WA-1','723246512','1988-10-14',',2002-10-21',null,'24 Frontier Trail NE','Seattle','WA','98123','3',null,'2067546512','2065795462',null,'14.75','2008-02-15'),
('22','Kristina','Romano','WA-1','704513547','1997-06-20','2001-05-20',null,'8 Anderson Loop','Seattle','WA','98113','4',null,'2062449876','2062748648','45,000.00',null,'2008-05-01')
;