Thanks all -

I'll look a little closer at some of your suggestions.

I'll post again if I find anything..

- Mike

Thanks all -

I'll look a little closer at some of your suggestions.

I'll post again if I find anything..

- Mike

I posted this (perhaps more appropriately) on the T-SQL forum as well, but wanted to note some of my new findings..

I have some good news but also a continuation of...

Sorry, tried that one too - with no success.

However, I have some good news but also a continuation of the Grand Puzzle.

I had previously dropped and recreated...

Thanks - I have also tried that as well - with no result.  However, as I understand it - the only difference between UNION and the UNION ALL clauses is...

Sorry, I should have already said that I had Updated the Statistics on all tables involved in the query in the view.

I have also dropped, and recreated the empty PH2007...