/*===========================================================================*\ Description: SQL script which creates a list of designation sets and assigns list of designation items to them. (designation sets and items are specified in designation group spreadsheet) Created: April 2009 Last revision information: $Revision: 2 $ $Date: 28/04/09 10:16 $ $Author: Pauldavies $ \*===========================================================================*/ -- Delete the old lists if there's anything in them. DELETE FROM dbo.Taxon_Designation_Set_Item DELETE FROM dbo.Taxon_Designation_Set --Insert Taxon Designation Sets INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000000','All Designated Species (excl Northern Ireland)','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000001','All European Designated (Birds Dir, H&S, Berne, Bonn, EC CITES)','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000002','All UK Legally Protected (W&C Act, Badgers and Cons Regs)','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000003','Wildlife & Countryside Act (Sch 1, 5 & 8)','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000004','IUCN Red Lists','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000005','Biodiversity Action Plan species (2007)','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000006','Country/UK Biodiversity Lists','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000007','NI Wildlife Order','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000008','Farmland Environment Planning','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000009','Planning Legislation','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set (Taxon_Designation_Set_Key,Title,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000010','Statuses of Nationally: Rare, Notable, Scarce','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000000 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000000','SYSTEM0000000000','NBNSYS0000000001','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000001','SYSTEM0000000000','NBNSYS0000000002','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000002','SYSTEM0000000000','NBNSYS0000000009','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000003','SYSTEM0000000000','NBNSYS0000000010','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000004','SYSTEM0000000000','NBNSYS0000000011','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000005','SYSTEM0000000000','NBNSYS0000000012','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000006','SYSTEM0000000000','NBNSYS0000000013','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000007','SYSTEM0000000000','NBNSYS0000000014','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000008','SYSTEM0000000000','NBNSYS0000000015','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000009','SYSTEM0000000000','NBNSYS0000000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000010','SYSTEM0000000000','NBNSYS0000000047','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000011','SYSTEM0000000000','NBNSYS0000000051','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000012','SYSTEM0000000000','NBNSYS0000000052','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000013','SYSTEM0000000000','NBNSYS0000000053','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000014','SYSTEM0000000000','NBNSYS0000000057','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000015','SYSTEM0000000000','NBNSYS0000000058','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000016','SYSTEM0000000000','NBNSYS0000000059','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000017','SYSTEM0000000000','NBNSYS0000000060','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000018','SYSTEM0000000000','NBNSYS0000000062','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000019','SYSTEM0000000000','NBNSYS0000000063','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000020','SYSTEM0000000000','NBNSYS0000000064','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000021','SYSTEM0000000000','NBNSYS0000000065','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000022','SYSTEM0000000000','NBNSYS0000000066','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000023','SYSTEM0000000000','NBNSYS0000000067','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000024','SYSTEM0000000000','NBNSYS0000000068','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000025','SYSTEM0000000000','NBNSYS0000000088','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000026','SYSTEM0000000000','NBNSYS0000000089','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000027','SYSTEM0000000000','NBNSYS0000000090','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000028','SYSTEM0000000000','NBNSYS0000000091','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000029','SYSTEM0000000000','NBNSYS0000000095','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000030','SYSTEM0000000000','NBNSYS0000000096','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000031','SYSTEM0000000000','NBNSYS0000000097','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000032','SYSTEM0000000000','NBNSYS0000000099','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000033','SYSTEM0000000000','NBNSYS0000000100','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000034','SYSTEM0000000000','NHMSYS0020170860','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000035','SYSTEM0000000000','NHMSYS0020443050','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000036','SYSTEM0000000000','NHMSYS0020443051','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000037','SYSTEM0000000000','NHMSYS0020443052','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000038','SYSTEM0000000000','NHMSYS0020443053','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000039','SYSTEM0000000000','NHMSYS0020443054','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000040','SYSTEM0000000000','NHMSYS0020443055','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000041','SYSTEM0000000000','NHMSYS0020443056','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000042','SYSTEM0000000000','NHMSYS0020443057','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000043','SYSTEM0000000000','NHMSYS0020443060','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000044','SYSTEM0000000000','NHMSYS0020443061','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000045','SYSTEM0000000000','NHMSYS0020443062','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000046','SYSTEM0000000000','NHMSYS0020443065','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000047','SYSTEM0000000000','NHMSYS0020443066','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000048','SYSTEM0000000000','NHMSYS0020443069','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000049','SYSTEM0000000000','NHMSYS0020443071','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000050','SYSTEM0000000000','NHMSYS0020443072','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000051','SYSTEM0000000000','NHMSYS0020443073','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000052','SYSTEM0000000000','NHMSYS0020443075','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000053','SYSTEM0000000000','NHMSYS0020443076','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000054','SYSTEM0000000000','NHMSYS0020443077','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000055','SYSTEM0000000000','NHMSYS0020443078','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000056','SYSTEM0000000000','NHMSYS0020443079','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000057','SYSTEM0000000000','NHMSYS0020443080','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000058','SYSTEM0000000000','NHMSYS0020443081','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000059','SYSTEM0000000000','NHMSYS0020443082','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000060','SYSTEM0000000000','NHMSYS0020443083','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000061','SYSTEM0000000000','NHMSYS0020443084','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000062','SYSTEM0000000000','NHMSYS0020443085','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000063','SYSTEM0000000000','NHMSYS0020443086','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000064','SYSTEM0000000000','NHMSYS0020443087','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000065','SYSTEM0000000000','NHMSYS0020443089','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000066','SYSTEM0000000000','NHMSYS0020443090','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000067','SYSTEM0000000000','NHMSYS0020443091','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000068','SYSTEM0000000000','NHMSYS0020443092','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000069','SYSTEM0000000000','NHMSYS0020443094','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000070','SYSTEM0000000000','NHMSYS0020443095','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017A','SYSTEM0000000000','NBNSYS0100000018','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017B','SYSTEM0000000000','NBNSYS0100000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017C','SYSTEM0000000000','NBNSYS0100000013','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017D','SYSTEM0000000000','NBNSYS0100000014','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017E','SYSTEM0000000000','NBNSYS0100000015','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017F','SYSTEM0000000000','NBNSYS0100000022','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017G','SYSTEM0000000000','NBNSYS0100000023','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017H','SYSTEM0000000000','NBNSYS0100000024','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000001 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000071','SYSTEM0000000001','NBNSYS0000000051','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000072','SYSTEM0000000001','NBNSYS0000000052','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000073','SYSTEM0000000001','NBNSYS0000000053','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000074','SYSTEM0000000001','NBNSYS0000000057','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000075','SYSTEM0000000001','NBNSYS0000000058','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000076','SYSTEM0000000001','NBNSYS0000000059','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000077','SYSTEM0000000001','NBNSYS0000000060','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000078','SYSTEM0000000001','NBNSYS0000000062','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000079','SYSTEM0000000001','NBNSYS0000000063','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000080','SYSTEM0000000001','NBNSYS0000000064','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000081','SYSTEM0000000001','NBNSYS0000000065','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000082','SYSTEM0000000001','NBNSYS0000000088','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000083','SYSTEM0000000001','NBNSYS0000000089','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000084','SYSTEM0000000001','NBNSYS0000000090','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000085','SYSTEM0000000001','NBNSYS0000000091','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000002 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000086','SYSTEM0000000002','NBNSYS0000000001','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000087','SYSTEM0000000002','NBNSYS0000000002','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000088','SYSTEM0000000002','NBNSYS0000000009','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000089','SYSTEM0000000002','NBNSYS0000000010','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000090','SYSTEM0000000002','NBNSYS0000000011','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000091','SYSTEM0000000002','NBNSYS0000000012','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000092','SYSTEM0000000002','NBNSYS0000000013','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000093','SYSTEM0000000002','NBNSYS0000000014','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000094','SYSTEM0000000002','NBNSYS0000000015','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000095','SYSTEM0000000002','NBNSYS0000000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000096','SYSTEM0000000002','NBNSYS0000000095','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000097','SYSTEM0000000002','NBNSYS0000000096','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000098','SYSTEM0000000002','NBNSYS0000000097','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000099','SYSTEM0000000002','NHMSYS0020170860','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017I','SYSTEM0000000002','NBNSYS0100000018','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017J','SYSTEM0000000002','NBNSYS0100000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000003 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000100','SYSTEM0000000003','NBNSYS0000000001','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000101','SYSTEM0000000003','NBNSYS0000000002','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000102','SYSTEM0000000003','NBNSYS0000000009','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000103','SYSTEM0000000003','NBNSYS0000000010','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000104','SYSTEM0000000003','NBNSYS0000000011','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000105','SYSTEM0000000003','NBNSYS0000000012','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000106','SYSTEM0000000003','NBNSYS0000000013','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000107','SYSTEM0000000003','NBNSYS0000000014','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000108','SYSTEM0000000003','NBNSYS0000000015','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000109','SYSTEM0000000003','NBNSYS0000000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017K','SYSTEM0000000003','NBNSYS0100000018','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017L','SYSTEM0000000003','NBNSYS0100000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000004 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000110','SYSTEM0000000004','NHMSYS0020443053','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000111','SYSTEM0000000004','NHMSYS0020443054','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000112','SYSTEM0000000004','NHMSYS0020443055','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000113','SYSTEM0000000004','NHMSYS0020443056','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000114','SYSTEM0000000004','NHMSYS0020443057','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000115','SYSTEM0000000004','NHMSYS0020443060','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000116','SYSTEM0000000004','NHMSYS0020443061','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000117','SYSTEM0000000004','NHMSYS0020443062','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000118','SYSTEM0000000004','NHMSYS0020443065','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000119','SYSTEM0000000004','NHMSYS0020443066','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000120','SYSTEM0000000004','NHMSYS0020443069','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000121','SYSTEM0000000004','NHMSYS0020443071','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000122','SYSTEM0000000004','NHMSYS0020443072','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000123','SYSTEM0000000004','NHMSYS0020443073','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000124','SYSTEM0000000004','NHMSYS0020443075','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000125','SYSTEM0000000004','NHMSYS0020443076','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000126','SYSTEM0000000004','NHMSYS0020443077','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000127','SYSTEM0000000004','NHMSYS0020443078','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000128','SYSTEM0000000004','NHMSYS0020443079','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000129','SYSTEM0000000004','NHMSYS0020443080','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000130','SYSTEM0000000004','NHMSYS0020443081','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000131','SYSTEM0000000004','NHMSYS0020443082','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000132','SYSTEM0000000004','NHMSYS0020443083','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000133','SYSTEM0000000004','NHMSYS0020443084','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000134','SYSTEM0000000004','NHMSYS0020443085','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000135','SYSTEM0000000004','NHMSYS0020443086','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000136','SYSTEM0000000004','NHMSYS0020443087','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000137','SYSTEM0000000004','NHMSYS0020443089','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000138','SYSTEM0000000004','NHMSYS0020443090','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000139','SYSTEM0000000004','NHMSYS0020443091','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000140','SYSTEM0000000004','NHMSYS0020443092','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000141','SYSTEM0000000004','NHMSYS0020443094','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000142','SYSTEM0000000004','NHMSYS0020443095','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017M','SYSTEM0000000004','NBNSYS0100000022','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017N','SYSTEM0000000004','NBNSYS0100000023','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017O','SYSTEM0000000004','NBNSYS0100000024','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000005 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000143','SYSTEM0000000005','NHMSYS0020443050','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000006 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000144','SYSTEM0000000006','NHMSYS0020443050','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017P','SYSTEM0000000006','NBNSYS0100000013','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017Q','SYSTEM0000000006','NBNSYS0100000014','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017R','SYSTEM0000000006','NBNSYS0100000015','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000007 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000145','SYSTEM0000000007','NBNSYS0000000075','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000146','SYSTEM0000000007','NBNSYS0000000076','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000147','SYSTEM0000000007','NBNSYS0000000081','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000148','SYSTEM0000000007','NBNSYS0000000084','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000149','SYSTEM0000000007','NBNSYS0000000085','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000008 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000150','SYSTEM0000000008','NHMSYS0001910129','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000151','SYSTEM0000000008','NHMSYS0001910130','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000152','SYSTEM0000000008','NHMSYS0001910131','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000009 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000153','SYSTEM0000000009','NBNSYS0000000001','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000154','SYSTEM0000000009','NBNSYS0000000002','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000155','SYSTEM0000000009','NBNSYS0000000009','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000156','SYSTEM0000000009','NBNSYS0000000010','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000157','SYSTEM0000000009','NBNSYS0000000011','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000158','SYSTEM0000000009','NBNSYS0000000012','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000159','SYSTEM0000000009','NBNSYS0000000013','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000160','SYSTEM0000000009','NBNSYS0000000014','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000161','SYSTEM0000000009','NBNSYS0000000015','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000162','SYSTEM0000000009','NBNSYS0000000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000163','SYSTEM0000000009','NBNSYS0000000051','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000164','SYSTEM0000000009','NBNSYS0000000059','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000165','SYSTEM0000000009','NBNSYS0000000060','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000166','SYSTEM0000000009','NBNSYS0000000062','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000167','SYSTEM0000000009','NBNSYS0000000063','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000168','SYSTEM0000000009','NBNSYS0000000064','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000169','SYSTEM0000000009','NBNSYS0000000095','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000170','SYSTEM0000000009','NBNSYS0000000097','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000171','SYSTEM0000000009','NHMSYS0020170860','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017S','SYSTEM0000000009','NBNSYS0100000018','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM000000017T','SYSTEM0000000009','NBNSYS0100000017','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') --Insert Items into Taxon Designation Set SYSTEM0000000010 INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000172','SYSTEM0000000010','NBNSYS0000000047','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000173','SYSTEM0000000010','NBNSYS0000000066','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000174','SYSTEM0000000010','NBNSYS0000000067','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000175','SYSTEM0000000010','NBNSYS0000000068','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000176','SYSTEM0000000010','NBNSYS0000000099','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000177','SYSTEM0000000010','NBNSYS0000000100','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000178','SYSTEM0000000010','NHMSYS0020443071','NBNSYS0000000005',GETDATE(),1,'NBNSYS00') INSERT INTO dbo.Taxon_Designation_Set_Item (Taxon_Designation_Set_Item_Key,Taxon_Designation_Set_Key,Taxon_Designation_Type_Key,Entered_By,Entry_Date,System_Supplied_Data,Custodian) VALUES ('SYSTEM0000000179','SYSTEM0000000010','NHMSYS0020443072','NBNSYS0000000005',GETDATE(),1,'NBNSYS00')