Tricky but I got it! I acutally had a similar situation recently where I had flubbed the date parameters so this was still freshly burned into my memory! 😀

Great Monday question!

Nice question, thanks!

Thanks for the question. Replication and mirroring are topics I need to read up on more.

Nice question, thanks!

SQLRNNR (9/19/2011)

I think they...

Ah, Thanks Jason. I'll check that out.

Any idea as to why they would allow this behavior in a join? Seems to me like it would actually introduce more confusion than convenience.

I, like some others, got the question right for the wrong reason. I focused on the date declaration in the parameters and only caught the renaming of the sub-query columns...

Thanks for the question. I've never done partition switching before so I learned something new.

Nice question, thanks

Glad I checked the discussion here! Feeling much better about getting it wrong when I was really right. Thanks for the question anyways.

Interesting stuff. Thanks for the question.

Nice question. I have only worked with a case sensitive SQL DB once so I don't usually keep collation in mind.

Nice question. Happy Friday everyone.