Yes, it would be a total rewrite to get away from XML because sproc b expects it in that format and does a lot of complex processing with it in...

I don't understand that last question. I suppose I could store all of the data in temp tables and then perform my processing, but I don't see how that...

I perform initial processing using OPENXML on the text variable. Then I need to modify format a bit to get it ready to be passed to sproc b. ...

Because the code does so much database manipulation (inserts and updates) that it would have to call stored procedures hundreds of times if I parsed through in the Web Service.

...

these sprocs are used to support a set of web services that take a long xml string as input from the web service and then perform some logic and output...

Because I use Stored Procedure B from serveral different stored procedures - not just from Stored Procedure A. It is a very long complex stored procedure.

quote:

---

I am afraid you have to accept the third way and live with it.

But the third way doesn't work to solve...