UFN_REGISTRANTDESIGNATION_AMOUNTADDSUP

        create function dbo.UFN_REGISTRANTDESIGNATION_AMOUNTADDSUP(
                @REGISTRANTID uniqueidentifier,
                @DEFAULT bit
           )
                returns bit
                with execute as caller

            as begin
                  declare @TOTALRECEIPTAMOUNT money
                  declare @SUMAMOUNT money

                  select @TOTALRECEIPTAMOUNT = coalesce((select sum(REGISTRANTREGISTRATION.RECEIPTAMOUNT) 
                    from dbo.REGISTRANTREGISTRATION 
                    where REGISTRANTREGISTRATION.REGISTRANTID = @REGISTRANTID),0)

                  select @SUMAMOUNT = coalesce((select sum(AMOUNT) 
                  from dbo.REGISTRANTDESIGNATION
                  where REGISTRANTID=@REGISTRANTID),0)

                  if @SUMAMOUNT > 0 and @TOTALRECEIPTAMOUNT > 0 and @TOTALRECEIPTAMOUNT = @SUMAMOUNT 
                     return 1;

                  return 0;
            end