>>You've completely missed the point. I'm simulating a thousand users hitting the server to run 1000 queries. Each of them calling a stored procedure is worse than if they ran the query directly.
>>
>
>I agree that sometimes it is more convenient and as efficient to use dynamic SQL. But my test results using your code show the stored proc is 20% faster.
>
>>Your test would be like all of the queries being cached and returned to one user.
>>
>
>>There are times when a stored procedure can be beneficial, but this isn't one of them.
>>
>
>That was my point in the "Speed" thread. You have one user generating 1000's of calls to the database server when you could probably handle it with one call to a stored proc.

Since I don't have a thousand pcs to test with, what else can I do? It is not a valid test to wrap the 1000 calls in an sp.