TR_DECEASEDSOURCECODE_INSERT_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_DECEASEDSOURCECODE_INSERT_BBNCCODETABLEIDMAP on dbo.DECEASEDSOURCECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '35bcd1f6-a60b-473e-a950-a4b8f0f55cc7', ID from inserted end