IF EXISTS (SELECT 1 FROM Reference.NotificationChannel WHERE ChannelName LIKE '%email%')
UPDATE Reference.NotificationTemplate
SET NotificationChannelId = (SELECT TOP 1 ID FROM Reference.NotificationChannel WHERE ChannelName LIKE '%email%')
WHERE NotificationChannelId IS NULL
AND MasterTemplateId IS NOT NULL
GO