>Assuming this to be correct, the question at hand is: Is it reasonable (maybe even 'expected'?) to require the installation of stored procedures into a customer's existing system?
>My sense tells me it IS reasonable, if only because these stored procedures can be isolated to the specific database(s)/tables relevant to my application. But I don't know how such would be viewed/accepted given the myriad of factors about which I know nothing.
>
>Your counsel is appreciated.

I think it is perfectly reasonable for a site to expect that the database you provide with your application may contains stored procedures. As you say, the SP's are contained in the db anyway.

However, you are mistaken in the 'assumtion' that you can not use multiple client generated selects with SQL server. You may have to rewrite them slightly, but it can be done.

Of course, SQLs T-SQL with correlated subqueries and derived tables/fields is much more flexible and powerfull than VFP's, and what you may not be able to do in a single select in VFP, you could do in SQL server.

HTH,
BOb