How to get response from stored procedure before it finishes?
9
votes
4
answers
5472
views
I need to return partial result (as simple select) from a Stored procedure before it is finished.
Is it possible to do that?
If yes, how to do that?
If not, any workaround?
EDIT: I have several parts of the procedure. In the first part I calculate several string. I use them later in the procedure to make addtional operations. The problem is that string is needed by the caller as soon as possible. So I need to calculate that string and pass it back (somehow, from a select for example) and then continue to work. The caller gets its valuable string much more quickly.
**Caller** is a Web Service.
Asked by Bogdan Bogdanov
(1163 rep)
Mar 18, 2016, 05:24 PM
Last activity: Oct 6, 2016, 04:37 PM
Last activity: Oct 6, 2016, 04:37 PM