>On regular dbf tables, I will sometimes do this in a method:
>
>

>Select sum(qty*price) from JobItems Into Array laTotal
>
>return Nvl(laTotal, 0)
>

>
>Now that I am working on moving my data to SQL Server, I need to know how I can you make a SPT Sql call and have it pull something back into an array like the above?
>
>
>.

See this sample in Help

* Create temp stored procedure with OUTPUT parameter and call it.
   SQLEXEC(m.lnConn, "CREATE PROCEDURE #MyProc @outparam int OUTPUT AS;
      SELECT @outparam=100")
   SQLEXEC(m.lnConn, "exec #myProc ?@lnOutput")
   ? m.lnOutput

So, if you don't want to use the cursor, you can use output parameter to return your result. I think using one record cursor is fine and simple.

If you insist on using array, you would need to do COPY TO array after getting your cursor.