title: efficient way to do multi threaded calls to sql server?
body: <p>i have an sql stored procedure that will call to TOP 1000 records from a table that function like a queue-in this table there will be more or less 30,000-40,000 records.the call to the SP takes ~4 seconds (there's an xml column) so to finish the calls it will take ~2 minutes.
  i thought to use multi threaded calls and to insert the records to a sync dictionary\list.
  did someone did that before? any efficient way to end the calls as soon as possible?
  Thanks... </p>