TR_STATE_INSERT_BBNCCODETABLEIDMAP (Trigger)

                
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