Hi,

SQL2K

I have been using stored procedures to return result sets to VFP Front end cursors. It works very well. But - since I'm always looking for a better or faster way to do things, I want to consider using either SQL Server Views (NOT VFP Remote Views!) or possibly UDF() to return my result sets to my cursors - which may as simple as "select * from table", or as complex as 10-12 level inner/left joins using dynamic SQL and passed in where clauses.

Any comments as to advantage (if any) of SQL views or UDF or stored procs?

TIA,