I'm trying to replace values from the below xml in sql server. It's bit complex due to namespace I guess. Can anyone please help me?After the update the tag should look like - Removed
Below is the sample xml -
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Header>
<Action xmlns="http://schemas.microsoft.com/ws/2005/05/addressing/none" s:mustUnderstand="1">http://tempuri.org/updateTaskContent</Action>
</s:Header>
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<updateTaskContent xmlns="http://www.test.com.au/services">
<Transaction xmlns="http://www.test.com.au/XMLSchema/Task/Update">
<taskToUpdateTransactionBody>
<TransactionContentDetails>
<TransactionIdentifier>AU8735645</TransactionIdentifier>
<TransactionCode>updateTask</TransactionCode>
<TransactionData>
<taskToUpdate>
<TaskToUpdateDetails>
<TaskIdentifier>tREF53453434</TaskIdentifier>
<PTObjectionReportResponse>
<Document>
<DocumentType>Test Specification</DocumentType>
<DocumentName>TestDoc1.pdf</DocumentName>
<DocumentData>Test123456</DocumentData>
</Document>
<Document>
<DocumentType>Test Amend Specification</DocumentType>
<DocumentName>TestDoc3.pdf</DocumentName>
<DocumentData>Test098764546</DocumentData>
</Document>
<Document>
<DocumentType>Test Objection Response</DocumentType>
<DocumentName>TestDoc56.pdf</DocumentName>
<DocumentData>hfgfgfgfggfgfgf</DocumentData>DocumentData>
</Document>
</PTObjectionReportResponse>
</TaskToUpdateDetails>
</taskToUpdate>
</TransactionData>
</TransactionContentDetails>
</taskToUpdateTransactionBody>
</Transaction>
</updateTaskContent>
</s:Body>
</s:Envelope>