UFN_AUCTIONITEM_GETPURCHASEPRICE

            CREATE function dbo.UFN_AUCTIONITEM_GETPURCHASEPRICE
            (
                @AUCTIONITEMID uniqueidentifier
            )
            returns money
            as begin
                declare @PURCHASEPRICE money = 0;

                select
                    @PURCHASEPRICE = case
                                        when AUCTIONITEM.TYPECODE = 0 then
                                            (select sum(REVENUESPLIT.AMOUNT)
                                            from dbo.AUCTIONITEMPURCHASE
                                            left join dbo.REVENUESPLIT on AUCTIONITEMPURCHASE.PURCHASEID = REVENUESPLIT.ID
                                            where AUCTIONITEMPURCHASE.AUCTIONITEMID = @AUCTIONITEMID)
                                        else
                                            (select sum(AMOUNT) 
                                                from dbo.AUCTIONITEM [PACKAGEITEM]
                                                left join dbo.AUCTIONITEMPURCHASE [ITEMPURCHASE] on PACKAGEITEM.ID = [ITEMPURCHASE].AUCTIONITEMID
                                                left join dbo.REVENUESPLIT [SPLIT] on [ITEMPURCHASE].PURCHASEID = [SPLIT].ID
                                                where [PACKAGEITEM].PACKAGEID = @AUCTIONITEMID)
                                        end
                from dbo.AUCTIONITEM
                where AUCTIONITEM.ID = @AUCTIONITEMID

                return @PURCHASEPRICE
            end