TR_RECOGNITIONDECLINEDLEVELREASONCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_RECOGNITIONDECLINEDLEVELREASONCODE_INSERT_BBNCCODETABLEIDMAP on dbo.RECOGNITIONDECLINEDLEVELREASONCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'ef9290a7-4c7b-4d47-b0ff-a462b0ead34e', ID from inserted end