I have a problem, Im updating some rows in SQL server via SQLXML updategrams. But the thing is, i need to do a lookup from 2 other tables before doing the update.
Is there a way to put a query inside the before tag, and use those values in the after tag?
something like this...
Code:
<updg:before>select .... </updg:before><updg:after>use values from before</updg:after>