TR_DESIGNATIONREPORT1CODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_DESIGNATIONREPORT1CODE_INSERT_BBNCCODETABLEIDMAP on dbo.DESIGNATIONREPORT1CODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '73520db9-f211-4a62-874f-62a58b06fecc', ID from inserted end