I am having fun here.

I tried to create an indexed view on data from a view. It said that it could not index my view because the view I was drawing data from was not index. I though I would make my own view using the same tables.

The tables from the original view are on a super secret remote server, that would probably involve some heavy duty disciplinary action if I tried to create my own view from tables on this server.

Any Suggestions?

Thanks
Jim