UFN_PLANNEDGIFT_ASSETS_TOITEMLISTXML

            CREATE function dbo.UFN_PLANNEDGIFT_ASSETS_TOITEMLISTXML
            (
                @PLANNEDGIFTID uniqueidentifier
            ) returns xml as
            begin
                return (
                    select
                        PGA.ID,
                        PGA.ADDRESSID, 
                        PGA.ASSETTYPECODEID,
                        PGA.ASSETVALUATIONMETHODCODEID,
                        PGA.COSTBASIS,
                        PGA.DESCRIPTION,
                        PGA.SEQUENCE,
                        PGA.VALUATIONSOURCE,
                        PGA.VALUE,
                        (
                            select 
                                ID, PLANNEDGIFTASSETID, HOLDERCONSTITUENTID
                            from
                                dbo.PLANNEDGIFTASSETHOLDER PGAH
                            where
                                PGAH.PLANNEDGIFTASSETID = PGA.ID
                            for xml raw('ITEM'), type, elements, binary base64
                        ) ASSETHOLDERS
                    from
                        dbo.PLANNEDGIFTASSET PGA
                    where
                        PGA.PLANNEDGIFTID = @PLANNEDGIFTID
                    order by 
                        SEQUENCE
                    for xml raw('ITEM'), type, elements, root('ASSETS'), BINARY BASE64
                )
            end