TR_PROSPECTRESEARCHREQUESTSTATUSCHANGECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTRESEARCHREQUESTSTATUSCHANGECODE_INSERT_BBNCCODETABLEIDMAP on dbo.PROSPECTRESEARCHREQUESTSTATUSCHANGECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '2b455e0c-4cf6-4f11-84c8-834b07e63d7f', ID from inserted end