spAddUpdate_EmailList_GlobalSubscription

        CREATE PROCEDURE [dbo].[spAddUpdate_EmailList_GlobalSubscription]
        @EmailAddress nvarchar(255),
        @HasOpted bit

        as

        IF EXISTS(SELECT ID FROM [EmailList_GlobalSubscription] WHERE EmailAddress = @EmailAddress)
            BEGIN
                UPDATE [dbo].[EmailList_GlobalSubscription] 
                SET EmailAddress = @EmailAddress, HasOpted = @HasOpted
                WHERE EmailAddress = @EmailAddress
            END
        ELSE
            BEGIN
                INSERT INTO [dbo].[EmailList_GlobalSubscription]
                   ([EmailAddress]
                   ,[HasOpted])
                VALUES
                   (@EmailAddress
                   ,@HasOpted)
            END