UFN_EVENTQUALIFICATIONSTATUS

            CREATE function dbo.UFN_EVENTQUALIFICATIONSTATUS
            (
                @EVENTID uniqueidentifier
            )
            returns nvarchar(25)
            with execute as caller
            as begin
                declare @FOUND bit;

                set @FOUND = 0

                select
                    @FOUND = 1
                from
                    dbo.GIFTAIDDISQUALIFIEDBYEVENT
                where
                    ID = @EVENTID;

        select 
          @FOUND = 1 
        from 
          dbo.GIFTAIDDISQUALIFIEDBYAPPEAL 
        where 
          ID = (select APPEALID from dbo.EVENT where ID = @EVENTID);

                if @FOUND = 1
                    return 'Not qualified';

                return 'Qualified';
            end