SET @ResponseReceivedData = '<req:input service="IBSServiceCoordinator" targetnamespace="http://service.app.ibs.fic.com" operation="getExecutedDedupeResults" xmlns:req="http://request.deduperesults.xsd.ibs.com"> <context bankcode="999"> <con:supervisorcontext userid="" primarypassword="" xmlns:con="http://context.xsd.ibs.com"> </con:supervisorcontext> </context> <custdeduperesultsreqdto apprefno="81980000015582" codserialno="1" namereferencecat=" OmniRefCatID="> </custdeduperesultsreqdto> </req:input>'
;with xmlnamespaces(DEFAULT 'http://service.abc.com' ) SELECT List.y.value('(@CodSerialNo)[1]','VarChar(25)') as CodSerial FROM @ResponseReceivedData.nodes('(/input/CustResultsReqDTO)') AS List(y)
<pre>...</pre>
<
<
>
>
http://request.deduperesults.xsd.ibs.com
http://service.abc.com
custdeduperesultsreqdto
CustResultsReqDTO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)