SET QUOTED_IDENTIFIER ON

GO

-- Add Roger Hutchinson to the Mill 2 shift-report recipient list (To).
-- Idempotent: only appends if not already present, preserves existing recipients.
UPDATE M2.EmailRecipientsResources
SET EmailRecipients = EmailRecipients + ';Roger.Hutchinson@steeldynamics.com'
WHERE Resource = 'SHIFT_REPORT'
  AND EmailRecipients NOT LIKE '%Roger.Hutchinson@steeldynamics.com%';
GO

