TR_PROSPECTRESEARCHREQUESTREASONCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTRESEARCHREQUESTREASONCODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTREASONCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '4303839e-1bed-41a0-981f-b67a73afda7b', ID from inserted end