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

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.

Edwin