Look at line 15, you are using two variables to represent your filter dates, but the string representation doesn't include the single quotes ' ' around the date. So...

Sorry, no. 0 is the correct answer, as each element of this question is a statement, not a query.

As above, BOL defines a query as a request for data,...

No - clustered indexes deliberately omitted as often these will be wrapped up with your CREATE TABLE scripts (i.e. when using CREATE TABLE myTable ( this INT PRIMARY KEY )...

That's new to me - hopefully this will be useful though! There's a few functions and things coming in with 2012 which seem ... well a bit 'non-relational'. ...

My apologies Koen, it wasn't an insult to your code, but mine. And you have a point, yes - SQL Server should be sorting out the date format rather...

Ignore my post above. Running this you get:

[font="Courier New"] Msg 1046, Level 15, State 1, Line 2

Subqueries are not allowed in this context. Only scalar expressions...

I'm sure there's a better way of doing this but my first instinctive thought would be to use a CASE statement as a computed column here.

I.e. something like:

DECLARE @dateTable TABLE...

Thanks for a good question, I know about STUFF for replacing parts of strings but thought the '0' for the length parameter formed part of a trick question (i.e. insert...

Good question, thanks!

I agree with other posters on this thread that this is a badly-executed question. Picking two arbitrary values with inconsistent results without explaining the rules governing the rounding by...

Dammit, a trick question. Annoying when the theme of QoTW is to avoid these in usual cases!

Learned something new though, so thanks!

If something looks too good (simple) to be...

Thank you for an informative introduction into applying data mining models.

This was a great question and I learned something new.

I do, however have a question of my own. I was under the impression that due to the internal timekeeping...

Excellent question, thanks very much. Have a good week.

I'm...