UFN_PLANNEDGIFT_ASSETS_FROMITEMLISTXML

            CREATE function dbo.UFN_PLANNEDGIFT_ASSETS_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'
                FROM @ITEMLISTXML.nodes('/ASSETS/ITEM') T(c)
            )