Change the INNER JOINS to WHERE clauses. For whatever reason, the query engine takes longer to process joins than it takes to process the same results from a where statement.
Just a thought.
>This view is currently taking about
2.5 minutes to load.
>Can anyone help me speed up this select/view?
*snip*
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao