Den 2011-07-06 23:33 skrev jclichthouse såhär:

> > Why can't you build the XML parsing stage into the app instead of into
> > the stored procedure? Basically, you would be moving part of the SP
> > logic into the app, which should be entirely possible, unless the SP is
> > used by app code that is not possible to change. Is this the case?
>
> I have move the processing to the nested sp because i do not know the
> amount of numbers i need to process . The amount of number is not static.
> Lets say if have 50 numbers how should i handle this? On this moment i
> only have one DB call.
> I do not say that I know it all, this is the way I learned it. If i know
> a other way to handle the dynamic amount of numbers i can change the
> code. Some more info is needed or link link to a example. All is welcome.

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
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64