Oh, PS:...

> Prior to the last email I explained what the static's were and how I got 9
> million fetches and it boils down to how the query optimizer is optimizing
> the plan on a left join.
>
>
>
> If a view could take parameters I would use a view but this is dynamic
> report data and hard coding dates is not an option with 5,000 users.

Obviously, it _would_ make sense to execute a procedure
only once if the input parameters don't change...

But I don't know if this is possible, considering the SUSPEND
and all.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com