UFN_PLANNEDGIFTADDITION_GETASSETS_FROMITEMLISTXML

          CREATE function dbo.UFN_PLANNEDGIFTADDITION_GETASSETS_FROMITEMLISTXML
          (
            @ITEMLISTXML xml
          ) returns table as
          return 
          (
            select
              T.c.value('(ADDRESSID)[1]','uniqueidentifier') AS 'ADDRESSID',
              case when T.c.exist('./ASSETHOLDERS/ITEM') = 1 then T.c.query('(ASSETHOLDERS)[1]') else null end AS 'ASSETHOLDERS',
              T.c.value('(ASSETTYPECODEID)[1]','uniqueidentifier') AS 'ASSETTYPECODEID',
              T.c.value('(ASSETVALUATIONMETHODCODEID)[1]','uniqueidentifier') AS 'ASSETVALUATIONMETHODCODEID',
              T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
              T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID',
              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('(ORGANIZATIONCOSTBASIS)[1]','money') AS 'ORGANIZATIONCOSTBASIS',
              T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
              T.c.value('(ORGANIZATIONVALUE)[1]','money') AS 'ORGANIZATIONVALUE',
              T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
              T.c.value('(TRANSACTIONCOSTBASIS)[1]','money') AS 'TRANSACTIONCOSTBASIS',
              T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
              T.c.value('(TRANSACTIONVALUE)[1]','money') AS 'TRANSACTIONVALUE',
              T.c.value('(VALUATIONSOURCE)[1]','nvarchar(200)') AS 'VALUATIONSOURCE',
              T.c.value('(VALUE)[1]','money') AS 'VALUE'
            from @ITEMLISTXML.nodes('/ASSETS/ITEM') T(c)
          )