Lowell, thanks for your suggestions, I'm going to apply them to my test environment and I'll report later if these fixes will solve my concurrency problem.

@gbritton:

Thanks for your suggestions.

Let me clarify that performance issue is not related to the stored procedure itself (that runs well); is the .NET report application that runs slowly when multiple users try to produce different report almost simultaneously.

Birby