Hi,
we are working with sql server 2005. My xml comes like this:
<ImportResponse xmlns="aaa:import:response:1.0" timestamp="2010-09-24T15:38:40">
<Summary failures="2" successes="3">
<Message code="-304" level="error">One or more errors have occurred while processing the
request items
</Message>
</Summary>
<Details>
<Result id="50063,123" success="false">
<Message code="-1100" level="error">Invalid field format (knect) - The Value fails meets the
requirements for this field: MaximumLength=9, Precision=0 - {3}
</Message>
</Result>
<Result id="50064,124" success="false">
<Message code="-1100" level="error">Invalid field format (knect) - The Value fails meets the requirements for this
field: MaximumLength=9, Precision=0 - {3}
</Message>
</Result>
</Details>
</ImportResponse>
I need to remove the value after ',' from Result element ID attribute. I need to do this
View Complete Post