Subject Re: process XML in stored procedure
Author jclichthouse
>If your SP can parse the XML and insert the extracted info into a temp
>table, then an app can also be made to parse the XML and insert the
>extracted info the same temp table. This will require multiple db calls
>(one insert per item/row), but is this really a problem? Why?
>
>Kjell
Thanks for the input,

I will try to understand the way of thinking you give to me. Okay lets say that with this app the extra network traffic is no problem. To understand how you would work with this I will need to ask for some more info, this way of working is new for me.

- Is the temp table a normal table you just use to store the numbers or are you using a global temporary table?
- Lets say there a 4 users processing nummbers. How do you know what rows to use?
I ask this to get a other view on the use of this table.

Edwin