fnIsEmailLinked

    CREATE FUNCTION dbo.fnIsEmailLinked(@EmailID int)
RETURNS INT
AS
BEGIN
    DECLARE @IsLinked bit

    SET @IsLinked = 0

    IF EXISTS(
            SELECT NULL
            FROM Email e
            INNER JOIN EmailProjectAppeal_ListEmail epale on e.ProjectAppealListEmailID = epale.ID
            INNER JOIN EmailProjectAppeal_EmailList epael on epale.EmailProjectAppealListID = epael.ID
            INNER JOIN EmailProjectAppeal epa on epael.EmailProjectAppealID = epa.ID
            INNER JOIN EmailProject ep on epa.EmailProjectID = ep.ID
            WHERE (e.Deleted = 0 AND  epale.Deleted = 0 AND epael.Deleted = 0 AND epa.Deleted = 0 AND ep.Deleted = 0)
            AND e.ID = @EmailID AND e.[Type] = 7) --Only want to check test message others do not show
        SET @IsLinked=1

    IF EXISTS(SELECT NULL FROM Email WHERE [ID] = @EmailID AND Deleted = 0 AND NOT [Type] IN (7,8,9)) --789 = campaign mail
        SET @IsLinked = 1

    RETURN @IsLinked
END