TR_PROSPECTRESEARCHREQUESTSOURCECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTRESEARCHREQUESTSOURCECODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTSOURCECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '88966cbf-bfac-44cd-88b9-9bb1ea0de491', ID from inserted end