TR_PLANNEDGIFTDESCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_PLANNEDGIFTDESCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.PLANNEDGIFTDESCATEGORYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '64e2e18b-fdbb-43c2-ada3-c3cbd60caf24' and TABLEENTRYID in (select ID from deleted) end