>In this case, no UDFs
>
>This is a view based on another view.

Ahh, why didn't you say so? :-)

You've run into one of the many reasons that you should try avoiding building views based on views. The first thing I should ask you is... why? Nearly all of the time I see someone do this, they could have done the same thing with a single view. If you owuld like, post the SQL to both of your views here, and we'll see how we can fix the situation...