spGetEmailList_GlobalSubscription

    CREATE PROCEDURE [dbo].[spGetEmailList_GlobalSubscription]
        @EmailAddress as nvarchar(255),
        @GetAllOptOut as bit

        AS

        if @GetAllOptOut = 1
            begin
                SELECT [ID], [EmailAddress], [HasOpted] FROM [EmailList_GlobalSubscription]
                WHERE HasOpted = 0
            end
        else
            begin
                SELECT [ID], [EmailAddress], [HasOpted] FROM [EmailList_GlobalSubscription]
                WHERE [EmailAddress] = @EmailAddress
            end