0

My XML is like below.

 <TDBUIData xmlns="http://www.somedomain.com/pace/r2.4/v1">
  <FileCreationDate>2014-07-18T13:21:48.507</FileCreationDate>
  <TDBUIDataList xmlns="">
    <PaceJobNumber>3898646894</PaceJobNumber>
    <TaskData>
      <TaskCode>Secon</TaskCode>
      <TaskAssigneeForecastFinishDate>07/16/2014</TaskAssigneeForecastFinishDate>
      <ActualFinishDate>01/01/2000</ActualFinishDate>
    </TaskData>
  </TDBUIDataList>
<TDBUIDataList xmlns="">
    <PaceJobNumber>11331313232</PaceJobNumber>
    <TaskData>
      <TaskCode>Secod</TaskCode>
      <TaskAssigneeForecastFinishDate>07/16/2014</TaskAssigneeForecastFinishDate>
      <ActualFinishDate>01/21/2000</ActualFinishDate>
    </TaskData>
  </TDBUIDataList>
</TDBUIData>

I need to remove xmlns="" attribute from all TDBUIDataList tags.

I am using this query, But its just not working.

DECLARE @XML XML            
;WITH XMLNAMESPACES (DEFAULT 'http://www.somedomain.com/pace/r2.4/v1' )                 
Select @XML=(SELECT  GETDATE() AS FileCreationDate, CONVERT(XML,@paceXML)       
FOR XML PATH('TDBUIData'))

SET @XML.modify('delete (/TDBUIData/TDBUIDataList/@xmlns[.=""])[1]')
SELECT @XML
Improve this question
5
  • To start, you'll need to specify the namespace in your delete query. Nothing will match /TDBUIData as it is in a different namespace. Commented Jul 18, 2014 at 8:33
  • can you specify some example...?? Commented Jul 18, 2014 at 8:46
  • This is Invalid flagging. provided answer seems to ask different issue and answers provided below are different then question by just reading question .My question was not supposed to mark as duplicate stackoverflow.com/questions/5345746/… Commented Jul 18, 2014 at 9:15
  • You are mistaken. The question is fundamentally the same. Commented Jul 18, 2014 at 9:40
  • Correct, Fundamental is the same...But none of their answer provide answer to my question...You could go through all the answers given and then verify that... Commented Jul 18, 2014 at 9:51
Related questions
2325
How do you parse and process HTML/XML in PHP?
1169
How can I parse XML and get instances of a particular node attribute?
1322
What does <![CDATA[]]> in XML mean?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.