USP_DEFAULTDESCRIPTION_UPDATEFROMXML

      CREATE procedure dbo.USP_DEFAULTDESCRIPTION_UPDATEFROMXML
      (
        @XML xml,
        @CHANGEAGENTID uniqueidentifier,
        @CHANGEDATE datetime
      )
      as
      begin
          set nocount on;

        update PDACCOUNTSTRUCTURE
        set DEFAULTDESCRIPTIONSEQUENCE = 0,
        DEFAULTDESCRIPTIONLENGTH = ''
        where ID not in (select ID from dbo.UFN_DEFAULTDESCRIPTION_FROMITEMLISTXML(@XML))

        update PDACCOUNTSTRUCTURE 
              set DEFAULTDESCRIPTIONSEQUENCE = tmp.DEFAULTDESCRIPTIONSEQUENCE,
        DEFAULTDESCRIPTIONLENGTH = tmp.DEFAULTDESCRIPTIONLENGTH,
          CHANGEDBYID = @CHANGEAGENTID,
          DATECHANGED = @CHANGEDATE
          from PDACCOUNTSTRUCTURE 
        inner join dbo.UFN_DEFAULTDESCRIPTION_FROMITEMLISTXML(@XML) as tmp on PDACCOUNTSTRUCTURE.ID = tmp.ID
      end