TR_HOUSEHOLDINCOMEESTIMATECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_HOUSEHOLDINCOMEESTIMATECODE_INSERT_BBNCCODETABLEIDMAP on dbo.HOUSEHOLDINCOMEESTIMATECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '0c76002c-8524-43e9-9faf-3cfbb07803e3', ID from inserted end