title: How to begin viewing/handling query results before the execution ends in SQL Server?
body: <p>I have a SQL query which returns a large result set and it takes over a minute for the query to finish execution.</p>
  <p>I was wondering if it is possible to start getting the data partially before the execution ends.</p>
  <p>My intention is to handle the data partially in a parallel foreach loop in C#.</p>
  <p>Any ideas?</p>
  <p>Thanks</p>