TR_PURPOSERECIPIENTSTATUSCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_PURPOSERECIPIENTSTATUSCODE_INSERT_BBNCCODETABLEIDMAP on dbo.PURPOSERECIPIENTSTATUSCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '73be7686-4386-4bbf-a1a5-6d2f47fab32f', ID from inserted end