What Iwas Bornready said! Not nice posting a trick question on a Friday.

Got it wrong because the wording of the question implied that it was tricky. But, it was actually the obvious answer.

I'm looking forward to reading this once it is completed. I hope Steve will highlight it when it's actually available.

I would recommend Courageous. I also saw Moneyball with my wife and enjoyed it, although the book was better.

Good question. I missed the note even though it is highlighted. :blush:

Hugo,

Excellent explanation. Thank you!

Steve

I also didn't want to just run the code to get the question, so I converted July 1, 2010 and January 1, 2010 to integers in Excel. Excel calls these...

Actually, if you read carefully, an index on a computed column CAN include multiple rows and columns from other tables. As long as one of the following four conditions are...

Thanks, Paul. That was the part that I missed that caused the misunderstanding on my part. I got in my head that we were starting @i at 0.9, but we're...

Actually, we're doing the exact same thing here. This was the original query:

while @i <> 1

begin

declare @a table(a int)

set @rc = @i +...

Very good question. I discovered that whether or not 0.9 + 0.1 <> 1 is not consistent I guess depending on sequence. If you execute the following in SQL Server...

By the way, this feature is documented. From MSDN (http://msdn.microsoft.com/en-us/library/ms173887.aspx): SQL Server Management Studio hosts a version of Microsoft Internet Explorer. This Web browser allows you to browse...

Thanks for a good question. For some reason, I was thinking that what would be inserted would be the deletion of the table.

Like others, I answered A because it returned "the expected output": NULL. Option C returns an error:

Msg 208, Level 16, State 1, Line 1

Invalid...

Steve and Co.,

A belated Merry Christmas! I'm glad you were able to take the day off.

Happy New Year!

Steve