>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.