>Hi,
>
>>>If you need ultimate performance from this query, why not rewrite it as a stored procedure. That way, the query will be saved parsed and the access plan created.
>
>Does this slow the tableupdate()?????
>John

John,

You would create or use a stored procedure in SQL Server to implement or optimize a complex or common query. In my response to the original question, they were looking for ways to speed up a query. My reply was to implement the query as a stored procedure. This would only speed up the execution time of the query, but wouldn't have any impact on the transfer of the result set to workstation.

There would be no correlation between this and a tableupdate() function. A tableupdate() would perform an operation on the result set of the stored procedure. To speed up a tableupdate() you would need to implement this also as a stored procedure.