TR_MERCHANDISEADJUSTMENTREASONCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_MERCHANDISEADJUSTMENTREASONCODE_INSERT_BBNCCODETABLEIDMAP on dbo.MERCHANDISEADJUSTMENTREASONCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select 'b1e64a3f-a3d1-499c-9872-ff1228e331d2', ID from inserted end