If you're just seeing if the customerid exists in the other table shouldn't this be an EXISTS clause? No need to return the results of the subquery just see...

There are all sorts of wrong with that code, but only one that actually stops it from executing.

Nice one!

With this set of original data, it's not really doing much, since all the ID-s are different, so the inner SELECT will effectively yield the original table, and the...

Except you didn't really. Somehow you changed what I answered, from what is now the correct answer to the answer initially marked as correct.

I'm thinking both the answer and explanation got a bit lost in translation...

You can remove the TOP  or the WITH CHECK option. Either will do the trick, as well as removing both.

Disappointed!

The way this question is asked it would be 11 hours, but I do get the confusion: that's what happens when British people try to Americanize the question, LOL....

We wait until the...

17-7 = 10, and then some minutes. Given that billing is per started hour, I'd venture that the available answers fall short.

I'm not even going to begin trying to figure out what the question is. My guess is at least half the text is missing.

There are two results that can...

The correct answer to this will depend on the setting of ANSI_NULL_DFLT_ON, since the NULLability of the CHAR column isn't specified.

The question is asked clearly: "What is the limit for rows in a Table Valued Constructor?". The documentation states that there is a limit. So there is nothing left...

A table valued constructor is only limited to 1000 rows when used directly as a source for an insert statement. When used to create a derived table there is no...