UFN_REGISTRANT_GETTARGETFUNDRAISING

       CREATE function dbo.UFN_REGISTRANT_GETTARGETFUNDRAISING
       (  
        @ID uniqueidentifier  
       )   
       returns money   
       with execute as caller  
       as  
       begin  
        declare @returnFMMoney money  

        SET @returnFMMoney = (SELECT TOP 1 FG.TARGETFUNDRAISING FROM FAFREGISTRATIONTYPEGOAL FG, REGISTRANTREGISTRATION RR 
        WHERE RR.REGISTRANTID =  @ID
        AND RR.EVENTPRICEID = FG.EVENTPRICEID 
        AND FG.REGTYPEGOALCODE = 0)

        IF @returnFMMoney IS NULL
            SET @returnFMMoney = 0

        return @returnFMMoney
       end