UFN_PLANNEDGIFT_ASSETS_2

            create function dbo.UFN_PLANNEDGIFT_ASSETS_2(@PLANNEDGIFTID uniqueidentifier)
            returns table
            as return
                select 
                    ID,
                    ASSETTYPECODEID,
                    DESCRIPTION,
                    VALUE,
                    COSTBASIS,
                    ASSETVALUATIONMETHODCODEID,
                    VALUATIONSOURCE,
                    ADDRESSID,
                    SEQUENCE,
                    dbo.UFN_PLANNEDGIFT_ASSETHOLDERS_TOITEMLISTXML(ID) ASSETHOLDERS,
                    BASECURRENCYID,
                    ORGANIZATIONVALUE,
                    ORGANIZATIONCOSTBASIS,
                    ORGANIZATIONEXCHANGERATEID,
                    TRANSACTIONVALUE,
                    TRANSACTIONCOSTBASIS,
                    TRANSACTIONCURRENCYID,
                    BASEEXCHANGERATEID
                from
                    dbo.PLANNEDGIFTASSET
                where
                    PLANNEDGIFTID=@PLANNEDGIFTID