do like thisUPDATE tSET AccountName = AcctName,AccountNumber = AcctNo,TxnType = TType,TxnAmount = TAmt,TxnDate = CONVERT(datetime,TDate,126)FROM(SELECT m.n.value('(./AccountName)[1]','varchar(20)') AS AccntName,m.n.value('(./AccountNumber)[1]','int') AS AccntNo,m.n.value('(./AccountName)[1]','varchar(20)') AS AccntName,m.n.value('(./TxnType)[1]','varchar(20)') AS TType,m.n.value('(./TxnAmount)[1]','decimal(10,2)') AS TAmt,m.n.value('(./TxnDate)[1]','varchar(30)') AS TDate,AccountName,AccountNumber,TxnType,TxnAmount,TxnDate FROM [Transactions] tnCROSS APPLY TxnData.nodes('/Transaction')m(n))t
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs