--0-1922223931-978529972=:49409
Content-Type: text/plain; charset=us-ascii


  Without of course knowing the code it is not easy to answer this one. I 
don't know whther there is any roll back  going on etc. It may be that 
although data is available it might be aborted etc. However As you 
probably know you can include multiple selects within your procs and 
iterate through these. I think that if you included selects at the 
appropriate point then you could review records (after the first part) as 
the proc continued with the remaining.

  Leif.Johnson@s... wrote: 

I have a SQL Server 6.5 stored procedure that has to do a lot of processing
to prepare data for subsequent queries the ASP client may make. However,
early in the process I have all the data I need for the initial response.
In my testing, the data does not seem to be available until the stored
procedure completely finishes. Is there a way to return the recordset and
continue the data preparation as a separate process?

TIA,

- Leif



---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com