TR_MERCHANDISEPRODUCTNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_MERCHANDISEPRODUCTNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.MERCHANDISEPRODUCTNOTETYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'f19fc607-9990-46e1-bd95-3ff728e2c6ab' and TABLEENTRYID in (select ID from deleted) end