Scenario 2 doesn't have a NOT IN in the original statement...I believe it belongs here:

select DISTINCT Name

from Production.Product

where ProductID IN (Select ProductID from Purchasing.ProductVendor

...

Glad to hear the system thinks for its authors...LOL

OK, so I didn't think the second statement was true, and apparantly it is...

That isn't my problem with the question, my problem is (as stated before) authors don't know how...

We need to define a column that will contain externally provided identifiers. Their

(1) length will vary from seven to ten characters

(2) all English letters

(3) both upper and lower case...

In computer science, a B-tree is a tree data structure that keeps data sorted and allows searches, insertions, deletions, and sequential access in logarithmic amortized time. The B-tree is a...

http://msdn.microsoft.com/en-us/library/ms187366.aspx

SQL Server 2008 Books Online (August 2009)

@@DBTS (Transact-SQL)

"Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in...

I too answered 'no' based upon the example...perhaps the example shouldn't have been given and just the question asked, but if you ran the given statement, it would certainly fail...

That is good to know the next time I want to:

A.) Convert an interger to a varchar then

B.) Convert that varchar to a smaller varchar then

C.) Cast...

None of the Above???

I received this as my results:

1899-12-31 00:00:00.000

Did the question change over time, too?

if you have ever worked with localization, the answer is clearly nchar(1)...

We were unable to get any of these remedies to work. What we ended up doing (on a 64-bit Server - may have been the Jet Driver problem to...