Sample Header Ad - 728x90

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