Masoud psp
New Member
I have a stored SQL procedure, which has declared xml variable with this kind of structure\[code\]<a> <b>4</b> <b>18</b> <b>2</b></a>\[/code\]I need to do something like \[code\]UPDATE a SET b=b-1 WHERE b>@MyIntVariable\[/code\] for this XML data. What is the best way to do it in MS Transact SQL?