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?


.