UFN_REGISTRATIONPACKAGE_GETRECEIPTAMOUNT

                create function dbo.UFN_REGISTRATIONPACKAGE_GETRECEIPTAMOUNT
                (
                    @ID uniqueidentifier
                )
                returns money
                with execute as caller
                as
                begin
                    declare @RECEIPTAMOUNT money;
                    select
                        @RECEIPTAMOUNT = coalesce(sum(EVENTPRICE.RECEIPTAMOUNT), 0)
                    from
                        dbo.REGISTRATIONPACKAGEPRICE
                        left join dbo.EVENTPRICE on REGISTRATIONPACKAGEPRICE.EVENTPRICEID = EVENTPRICE.ID
                    where
                        REGISTRATIONPACKAGEPRICE.REGISTRATIONPACKAGEID = @ID;
                    return @RECEIPTAMOUNT;
                end