fnGetNextAppealForDupSearch

        CREATE FUNCTION [dbo].[fnGetNextAppealForDupSearch]()
            RETURNS INT
            As

            BEGIN
                DECLARE @AppealID int

                SELECT TOP 1 @AppealID = [ID] FROM EmailProjectAppeal WHERE DuplicateSearchStatus = 1

                RETURN ISNULL(@AppealID,0)
            END