What does your stored procedure look like?

Phillip

>This might be a stupid question, but...
>
>Let's say I have an invoice history file in SQL Server. I also have a VFP front-end that allows someone to select accounts and products to query/report against.
>
>So the user picks 10 accounts and 3 items to report on. (Though the user could just as easily pick 100 accounts and 100 items.) This list could be stored in a set of arrays, or in a cursor, DBF, recordset, etc.
>
>How would I 'get' this list of 10 accounts and 3 items to a SQL Server Stored Procedure, so that a SP could query the invoice history file and return the results?
>
>Sorry if this question is so basic, but there's just so much about visibility, architecture of this stuff that I'm trying to learn.
>
>Also, is anyone aware of VFP sample code for working with stored procedures in SQL Server?
>
>Thanks in advance,
>Kevin