RE: Can I create a SQL Cursor out of a DS Array

Thanks for the reply Michael! A stored Proc is exactly what I am trying to write: The question is how to make it return multiple Result Sets for cases where the data is not available as straight SQL Cursors. The question I was asking was whether there was a way to create a cursor from something other than a typical "select x, y, z from myfile" clause...
On Thu, 17 Oct 2013 12:19:45, Michael Schutte <mschutte369@xxxxxxxxx>wrote:
This might not be the suggestion you want, but can accomplish what you want
using a Stored Procedure. All cursors open on the return from a procedure
return as their own result set.





The information contained in this electronic communication and any accompanying document is confidential, may be
attorney-client privileged, and is intended only for the use of the addressee. It is the property of Ryder System,
Inc. Unauthorized use, disclosure or copying of this communication, or any part of it, is strictly prohibited and
may be unlawful. If you have received this communication in error, please notify the sender immediately by return
email, and destroy this communication and all copies of it, including all attachments. Electronic communication
may be susceptible to data corruption, interception and unauthorized tampering and Ryder disclaims all liability
of any kind for such actions or any consequences that may arise directly or indirectly therefrom.