Wow, that isn't a simple query is it :)
Nothing seems obvious does it.
And if you re-create the view then you get the same execution plan as
running the select directly?
I think you'll need someone much more knowledgeable than me helping.
Hope you get it sorted! I'd only be trying different
Thomas
I am having trouble with column name case sensitivity with linked tables
in SQL Server 2005.
Example. The column name in SQL Server is RecordDate in the table
SecurityMaster
I create a linked table as:
create linked table if not exists
L_SecurityMaster(
