>>> Is there is no pure and perfect solution no matter what your proclivity is.
>
>You're absolutely correct. But my original message did state that it was my opinion.
>
>>> A parameterized view is not an ad-hoc query...This type of view can be optimized with SQL Prepare.
>
>From SQL Server's point of view, a VFP view is an ad-hoc query. In fact, you can see this for yourself by starting a trace in SQL Profiler. It's an interesting exercise. If the BatchUpdateCount is set to one, ODBC submits the queries using sp_executesql. If you up the BatchUpdateCount, ODBC uses sp_prepare.
>
>-Mike

Mike,

I got around to trying your suggestion, but I am seeing the query run with sp_prepare and sp_execute no matter what the number of records to batch update is set to. Am I missing something