Very good question. Obvious, but worth noting, I think, that the rounding occurs on the assignment to a datetime variable or column, NOT when doing the SELECT. In other words,...

Excellent question. Understanding how the different data types are stored/handled in SQL is so helpful when creating EFFECIENT (not just working) database design. Thanks for the review -- and looking...

Good question. Forced me back to BOL to refresh my memory.

Thanks!

Great question. Learned SEVERAL things.

The more one learns, the more one realizes how little he knows...

Great question! I also learned something....

I also read that...

Great question. I have to keep reminding myself that a boolean can actually evaluate to one of three values: TRUE, FALSE or UNKNOWN.

Deepak -- you could achieve much of this by using SQL Server's Full Text search capabilities. There's a bit of overhead, but it's much, much faster than a LIKE search...

Too bad half right doesn't count for anything...

Good question, Tom!

Outstanding question -- not only on Except/Intersect, but also on operator precedence. A great brain stretcher to get the day started.

Excellent question. Thanks!

Who can explain why the fifth option, "A on its own is a candidate key of T" is NOT true? What am I missing here?

Conrald,

I see you never received a reply to your question. I am in a similar situation and am wondering if you came up with a good solution to this.

Or...does...

In other words...what Derrick Smith just said...AND what you just concluded yourself.

After further investigation....

A more likely issue is that you're using a value from that second LEFT OUTER JOIN (CIT.Ind_Priority) in your ORDER BY clause; note that the query plan shows...