SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- =============================================
CREATE TRIGGER [dbo].[SetChildrenInactive]
   ON  [dbo].[Contacts] 
   AFTER INSERT, UPDATE
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
 SET NOCOUNT ON;
 UPDATE ProjectContacts
	SET DoNotContact=1
	FROM ProjectContacts c
		INNER JOIN inserted i 
		ON c.ContactID=i.ContactID 
		INNER JOIN Projects p 
		ON c.ProjectID=p.ProjectID 
	WHERE (p.Authorized IS NULL OR p.Authorized=0) AND i.DoNotContact=1
END
GO