UFN_PLANNEDGIFT_ASSETS_2_FROMITEMLISTXML

            create function dbo.UFN_PLANNEDGIFT_ASSETS_2_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            ) returns table as
            return
            (
                select
                T.c.value('(ADDRESSID)[1]','uniqueidentifier') AS 'ADDRESSID',
                T.c.value('(ASSETTYPECODEID)[1]','uniqueidentifier') AS 'ASSETTYPECODEID',
                T.c.value('(ASSETVALUATIONMETHODCODEID)[1]','uniqueidentifier') AS 'ASSETVALUATIONMETHODCODEID',
                T.c.value('(COSTBASIS)[1]','money') AS 'COSTBASIS',
                T.c.value('(DESCRIPTION)[1]','nvarchar(1000)') AS 'DESCRIPTION',
                T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
                T.c.value('(VALUATIONSOURCE)[1]','nvarchar(200)') AS 'VALUATIONSOURCE',
                T.c.value('(VALUE)[1]','money') AS 'VALUE',
                case when T.c.exist('./ASSETHOLDERS/ITEM') = 1 then T.c.query('(ASSETHOLDERS)[1]') else null end AS 'ASSETHOLDERS',
                T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
                T.c.value('(ORGANIZATIONVALUE)[1]','money') AS 'ORGANIZATIONVALUE',
                T.c.value('(ORGANIZATIONCOSTBASIS)[1]','money') AS 'ORGANIZATIONCOSTBASIS',
                T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
                T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
                T.c.value('(TRANSACTIONVALUE)[1]','money') AS 'TRANSACTIONVALUE',
                T.c.value('(TRANSACTIONCOSTBASIS)[1]','money') AS 'TRANSACTIONCOSTBASIS',
                T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID'
                FROM @ITEMLISTXML.nodes('/ASSETS/ITEM') T(c)
            )