UFN_REGISTRATIONPACKAGE_GETAMOUNT

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