I never worked with RS, but I work with MS SQL server.

I can guarantee that this syntaxe will force the server to scan the whole table to extract the information...

Seriously, you only have 5-6 seeks in there... when you should have 100% seeks. Is there any way this query can work with inner joins?

How long does it take to run this monster?

month(DateField) = @Param1 = TABLE SCAN convert to between at least.

The design seems wrong. If you have multiple owners for measures, then the owner should ONLY BE in the second table.

And for the love of [insert your god here]....

Too many views can cause problems on the long run.. and that's a very long run .

This is what I meant but since you are already doing it...

(left outer join (select ORDER_ID, DIRECTORY_ID, ID from t_MTSTM_STOP where ACTIVE = 1 and STOPTYPE_ID = 8583) SHIPSTOPTABLE on...

Run the profiler while you hit all the possible buttons and you'll see the queries being fired at the server. Don't forget to filter the queries to only yourself.

Actually it should always fail... The last where condition will always fail is the left join returns nothing on the outer table. (substring(null) = null).

Put that where condition in the...

I second that... what are your ideas?

"DATEFORMAT affects the way the input is read, if you want to change the ouput, you must convert to varchar and use one of the styles listed in the books...

Move to derived tables/joins.

Can we see the view definition?

It takes the WHOLE PK to trace back to the correct row and do the update. Access works in the same way and I don't see how sql server...

The resident genious ubiquitous spook welcomes you .

Is part of... what are the other keys? Are they also in the view??