不服老外不行,还是人家实在,贴出来的源码绝对能运行,找了两个晚上找到的。佩服佩服,那些翻译的,每一个能完整的运行,哎。下面是sql
CREATE TABLE [dbo].[Employee](
[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](50),
[LastName] [varchar](50),
[SupervisorID] [int] NULL,
CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
(
[EmployeeID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
GO
ALTER TABLE [dbo].[Employee] WITH CHECK ADD CONSTRAINT [FK_Employee_Employee] FOREIGN KEY([SupervisorID])
REFERENCES [dbo].[Employee] ([EmployeeID]);
TRUNCATE TABLE Employee;
SET IDENTITY_INSERT Employee ON
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(21, 'Arrigoni','Ellen',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(22,'Beilby','Paige Denise',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(32,'Bell','Ken James',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(45,'Campbell','Scott Richard',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(91,'Chen','Hueyfang',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(93,'Figaro','Christopher Michael',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(113,'Fitzgerald','Joseph OConnor',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(201,'Heriveaux','Marlange',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(301,'MacKenzie','Davin S',null);
INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(311,'Brien','Kelsey Leigh',null);
SET IDENTITY_INSERT Employee OFF;
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sarfatti','Aaron Joseph',null);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wu','Ichan John',null);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Xia','Diwei',null);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhao','Jingjing',null);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Abbas','Anees Fatima',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Adams','Philip Lance',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Allen','Adrienne N',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Allen','Philip Michael',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Altilio','Michael',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Amspacher','Gregory Robert',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Anderson','David Michael',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Anger','Amelie Huimei',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ashby','John J.',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Au','Chanel Roxanna',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Au','Wai Kong',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ausiello','Kristin Ann',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Avery','Hans',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Badley','Roger Kenneth',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Bagla','Vikash',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Baillargeon','Michelle C',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Basha','Paul Frederick',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Bazile','Max Husani',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Beauchesne','Francois Montpetit',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Berube','Pierre-Luc',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Boehme','Joshua',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Boundy','Kris Dawnlyn',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Brisson','Edith',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Brown','Robert Wayne',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Burningham','Bryan Paul',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Burris','Donald Hugh',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Byrd','Matthew Russel',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Campbell','Brian Alexander',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Carlson','Karen Denise',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Charline Dizon',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Chia Khow',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Hau-Chung',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Ho Lun',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Ka Shing',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Ka Yip',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chang','SeungHwan',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chao','Paojung',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chaudhry','Nikita',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Chongyang',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Hong',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Irawati',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Sheng-Hsien',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Shun',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Wan-Yu',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheng','Huiyu',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheong','Bevan Y S',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheung','Carin',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheung','Geoffrey C',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chim','Grace Wai Sze',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chin','Chang-Han',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chow','Jeany',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chow','Khong Tic',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Christensen','Issac Merrill',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Christy','Ilene E',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Christy','Karen',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chu','Wendy',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chua','Samuel Teik Kiong',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chung','Ho Yin',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Clark','Michael E',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Coe','Adam James',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Comeau-Tougas','Etienne',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Conroy','Kelly Riehl',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Corona','Jonas',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Coulombe','Diane',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Covalle','Matthew Allen',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Curran','Ron Alan',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dai','Rui',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dealmeida','Arthur Craig',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dhulipala','Deepti',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Didier','Matthew Lee',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dion','Valerie',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dodd','Heidi Lynn',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dooley','Brent Alan',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dorr','Nate H',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Doyle','Michael Andrew IV,',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dwyer','Brandon John',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ellis','Amanda Senules',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ellis','Claudia',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Enriquez','Keith H',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Etheridge','Andrew Christian',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Etlinger','Benjamin Herman',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fan','Taylor',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fang','Wilson',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fast','Trevor James',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fausey','Jeffrey John',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Filshtein','Teresa Jenica',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('France','Andrew Edson',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fraser','Andrew James',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fredrickson','Tricia Ann',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fries','John William',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fung','Chui Ying',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gabriel','Joseph',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gao','Jie',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gao','Yang',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Garneau','Michael',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gesink','Gary James',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gingerich','Adam Michael',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gould','Susan Yvonne',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gupta','Puja',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hale','Christopher Allen',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Han','Zhongxian',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hardy','Amber Kay',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Harshman','Michael John',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hassan','Raza',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hayes','Richard Laurent',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hess','Laura Vignati',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hickok','Lauren Elizabeth',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hixon','Sarah C',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hoge','Bryan Kenneth',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Honett','Stephanie Grace',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Howard','Jason David',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hsu','Chi-Pu',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hsu','Chiukao',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hu','Yungui',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Huang','Ying',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hubbard','Mindy',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hung','Kenneth Lik Hang',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hung','Kian Teong',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Iwamoto','Todd Akira',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jiang','Dazhi',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jin','Jenny',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jin','Yueqi (Alec)',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jobe','Elizabeth Anne',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jong','Peter Cy',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Junt','Don',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kabala','Joel C',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kao','Nicole',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kassam','Salim Shiraz',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Khor','Kahhoa',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kim','Hwa-Young',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kim','Jihyun',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kim','Joseph M.',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kimball','Jacob A',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kong','Weifeng',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Koumoulis','Mirjam',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kouri','Justin Vahe',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kriausakul','Navarat',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kroening','Jason Gerald',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kwan','Pui-Yin',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kwok','Chau Mo',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kwok','Johnathan Pak Wai',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lai','Kim Fung',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lalumiere','Michel',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lam','Ho Ying Ellen',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lam','Melissa I',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lamm','Elizabeth Ann',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lang','Jessica May',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lannan','Dustin William',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lantagne','Kathie',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lapeyre','Francois',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Larson','Michael John',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lau','Phooi Wan',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Laurence Bourassa','Yannick',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lavoie','Lisa',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Law','Chi Hong',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lawton','Linda Barker',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lazarus','Saul',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Kin Hoe',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Mandy Hoi Man',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Michelle Keum',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Su Meng',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Taik-Ki',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Leida','Johann K',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Levinsky','Marc R',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Chen',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Chun Yu Matthew',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Dongsheng',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Fengchun',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Hongyi',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Hua',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Xinyan',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Xinyu X',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Yanli',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Zheng',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Zhigang John',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lian','Xiu',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lim','Yih Chen',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lin','Chia Ju',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lin','Tsung Yu',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lin','Yijing',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lipperman','Brody D',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Dong',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Jianxun',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Pak-Hay Patrick',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Xiaofang',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lo','Keith Joe Ye',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lokken','Patrick William',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Long','Jeffrey Ryan',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Long','Jun',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lu','Chien-Hung',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lu','Ziyao',201);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Luo','Mian',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('MacMurdy','Michael',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Majeed','Rizwan',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Maloney','Matthew Ryan',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Maltais','Maxime',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Man','Angie Rho-Nung',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Marks','Nathaniel Andrew',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('McBane','Roderick James',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Minute','Eric John',91);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Morehead','Lynn M',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Morris','Michael',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Motsiopoulos','Christos',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Murray','Timothy Kevin',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nadeau Roy','Melanie',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nee','Stephanie Wan-Jung Wang',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ng','Pui Wai',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nguyen','Hoan Thi Ngoc',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nolan','Thomas',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Noonan','Valerie Ann',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Notaristefano','Amanda Jean',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ofori','Ernest Ntim',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Olberding','Kevin William',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Orr','William Breckenridge',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Owens','John Philip',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Paquet','Marie-Andree',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Patel','Amee Y',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Patota','Timothy Jason',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Pearce','Marissa Simone',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Pesarek','Brad Michael',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ponorovskaya','Olga',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Popatia','Yasmin Akberali',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Qi','Jinning',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Qi','Youquan',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Qian','Aiping',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Quock','Cathy Wemie',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rachakonda','Bindavi',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rakowski','Brian J',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rao','Smita Ramdas',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rasmussen','Jonathan William',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rawlins','Marisa',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Renfrew','Jessica Erin',91);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Romano','Christine Lynne',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sakhrani','Paul Vashi',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Santay','Kavita',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sapochak','Jonathan Andrew',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Schenck','Robert Tarlton',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Schopfer','Mark Louis',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Schweickert','Estellene Mischelle',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sequeira','Nancy Salgado',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Shafer','Garrett C',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Shewarega','Meron',91);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Simonelli','Brad Lee',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Slowinska','Jowita',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Smith','Glenn Stanley',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Southwell','Andrew Lee',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Spencer','John A',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Stecklein','Daniel',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Steinbrunner','David James',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Steinshouer','Jared B',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sudwerts','Ephraim',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sui','Difei',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Svara','Frank Richard',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Symonds','Mark Andrew',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tackmann','Andrew Richard',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tam','Nga Yau',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tess','Andrew Steven',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tharnish','Sarah Marie',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Theisen','Tyler Jay',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Thomas','Kemba',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Thomas','Stephen Paul',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Thoo','Kwan-Ji Jeannie',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Treetipbut','Pataraporn',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tremblay','Jean-Francois',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Trexler','Weston Dean',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Trinrud','Christopher Walter',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Trivedi','Aditya Dushyant',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tsai','Ching-Fang',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tsang','ChiFai',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Turner','Andrew Frederick',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Vahid','Reza',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Verghis','Raina Rachel',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Vincent','Adrian',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Vulpio','Laura M',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Jingyan',91);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Ning',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Tianjiao',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Xiaolu',21);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wei Chong','Lai',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Weise','Mary Katherine',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wen','Jiajia',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wen','Victoria',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Widmer','Alisa Johnson',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('WONG','Man Hong',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wong','Maria Wing Kei',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wong','Ngai Keung',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wu','Chingfeng',301);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wu','Li',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Xiao','Chunfang',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Xiao','Meng',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yang','Su',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yeung','Hon Keung',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yiu','Terence Tin Hang',32);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yuen','Kim Hung Jackie',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhang','Chu',22);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhang','Ning',311);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhang','Peng',93);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zheng','Chunmei',45);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhuang','Yuelin',113);
INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zou','Hui',113);