IF EXISTS (SELECT 1 FROM [dbo].[pal_Setup] WHERE recId = 1)
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)
UPDATE [dbo].[pal_Setup] SET emailSubjectWholesalerOrder = '{CompanyName} - Purchase Order [{WholesalerName} : {OrderNumber}]' where recId = 1;
GO