>Hi
>Found that NOEXPAND required enterprise and indexed view. But our customer might not. Any alternative way?
>
>thank you
The other suggestion I may give you is to use temp tables instead of the view.
If it's not broken, fix it until it is.
My Blog