fnAppealEmailListIsLinked

        CREATE FUNCTION [dbo].[fnAppealEmailListIsLinked]
            (    
            @EmailListID int,
            @EmailType tinyint
            )
            RETURNS bit
            AS
            BEGIN
            DECLARE @IsLinked bit
            SET @IsLinked=0
            IF EXISTS (
                SELECT TOP 1 e.[ID] 
                FROM [dbo].[Email] e
                INNER JOIN [dbo].Email_EmailList eel ON eel.EmailID = e.[ID]
                WHERE eel.EmailListID = @EmailListID
                AND e.[deleted] = 0
                AND e.[type] = @EmailType
                )
                SET @IsLinked=1
            RETURN @IsLinked
            END