TR_MERCHANDISEADJUSTMENTREASONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_MERCHANDISEADJUSTMENTREASONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.MERCHANDISEADJUSTMENTREASONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'b1e64a3f-a3d1-499c-9872-ff1228e331d2' and TABLEENTRYID in (select ID from deleted) end