Kevin,
Why wouldn't you just scan your cursor and send subsequent queries to the SQL invoice table using the criteria in the first query. You could build a text string for your WHERE statement that included the parameters of all customers in the cursor if you wanted to get all child records in one query. I am not aware of how you create a stored procedure thru VFP on a SQL Server. There may be a way but I have never looked into it. I would think that the overhead of creating the stored procedure coupled with its execution would be more consuming than the above alternative.
Bill
>Bill,
>
>Thanks for responding. However, I may not have asked my question clearly.
>
>I'll try to ask it differently...in the same way that SQLEXEC will return a VFP cursor, can I PASS a cursor to a stored procedure?
>
>Again, in the example I gave, a user may select a handful of accounts and items...or they could pick hundreds. Obviously, I can't pass a character string containing every account/item key, but I haven't figured out how to 'pass' 2 cursors (containing the selected accts/items) to SQL Server so that a stored procedure could query against a back-end invoice table.
>
>Kevin
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!