Den 2011-07-07 00:30 skrev jclichthouse såhär:

> >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?
> >
> 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.

Sorry, no experience with the temp table stuff. Better ask in a new
thread, since many competent people may miss it in this "old" thread.

But in general, you could use any table and key the temp data with a
generator or something like that.

Or, you could have your app convert the XML into a string that's easier
to parse in the SP, and go ahead with the same approach as before.

Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64