IF EXISTS (SELECT 1 FROM [dbo].[pal_Setup] WHERE recId = 1 AND [emailSubjectPurchases] IS NULL)
UPDATE [dbo].[pal_Setup] SET emailSubjectPurchases = '{CompanyName} - New Order [{RetailerName} - {OrderNumber}]' where recId = 1;
GO

IF EXISTS (SELECT 1 FROM [dbo].[pal_Setup] WHERE recId = 1 AND [orderEmail] IS NULL)
UPDATE [dbo].[pal_Setup] SET orderEmail = 'orders@reaptech.io' where recId = 1;
GO