TR_STATE_INSERT_BBNCCODETABLEIDMAP

CREATE trigger TR_STATE_INSERT_BBNCCODETABLEIDMAP on dbo.STATE after insert not for replication
as begin
    insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) 
        select 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E', ID from inserted
end