spGetEmailList_UserDefined

      CREATE PROCEDURE [dbo].[spGetEmailList_UserDefined]
      @EmailListID int,
      @RecordIds xml

      as

        if @EmailListID > 0
            SELECT euf.[ID]
            ,[EmailListID]
            ,[EmailDisplayName]
            ,euf.[EmailAddress]
           ,[Enabled]
            ,Case isNull(elgs.HasOpted, 1) when 0 then cast(1 as bit) else cast(0 as bit) end as [GlobalOptOut] 
            FROM [dbo].[EmailList_UserDefined] euf
            inner join @RecordIds.nodes('/ids/id') IDS(ID) on IDS.ID.value('@i', 'int') = euf.ID
            LEFT JOIN EmailList_GlobalSubscription elgs on elgs.EmailAddress = euf.EmailAddress 
            WHERE EmailListID = @EmailListID
        else        
            SELECT euf.[ID]
            ,[EmailListID]
            ,[EmailDisplayName]
            ,euf.[EmailAddress]
           ,[Enabled]
            ,Case isNull(elgs.HasOpted, 1) when 0 then cast(1 as bit) else cast(0 as bit) end as [GlobalOptOut] 
            FROM [dbo].[EmailList_UserDefined] euf
            inner join @RecordIds.nodes('/ids/id') IDS(ID) on IDS.ID.value('@i', 'int') = euf.ID
            LEFT JOIN EmailList_GlobalSubscription elgs on elgs.EmailAddress = euf.EmailAddress