Check if yo have objects created with the option "with schemabinding"

also check if you have foreign keys on it.

From the original thread :

where t1.f2 = 'blah' and t3.f1 is null

This query Explains almost ideally, 3 index seeks , bookmark lookup, 2 nested loops, filter, done.  Each tables...

Why 0 for week 3?

Why 1 = 2 vs 0 = 1 if I may ask??

Can you give us some input data and the required output (please try to cover all cases so we can formulate a complete solution).

I think it's time for one more... of each .

Thanx, this is what I was searching for in that solution .

And the extract to spreadsheet would look like what??

Let me put this in a perspective you can understand.

Read this (48 articles) :

http://www.sqlservercentral.com/articles/articleList.asp?categoryid=37

Then this (no clue how many but like 100) :

http://www.sql-server-performance.com/articles_performance.asp

Then those 10 will come...

I would tend to agree, but since sql server is not needed at the moment and that maybe the access application may be used in a context where sql server...

Lol, good luck.  In the mean time maybe someone else will have something else to propose.

How does the case proceed differently than the if in this case??

Just a start... 'cause I don't think you can alter the datatype when in a fk relation unless you change both, which requires dropping the relation, altering the columns and...

I don't see why I wouldn't be usin sql server for this. It's exactly why it was created.  Unless there's some hidden information that can't be seen by anyone except...

Not that I know of.  I've never had to use 'em explicitly.  But it can be usefull to mark the end of something.  Anyone else got a better explaination?