Nils Gustav Stråbø (3/6/2012)
I don't complain about the functionality of that specific view, I'm just being an annoying pedantic 😀 Every QOTD has one.
However, if you were really pedantic, you would have realized that the phrasing of the question is: "Which table/view contains a row ...", not "Which table/view returns a row ...". The WHERE clause only affects what the view returns, not what it (or the underlying table) contains.
(So the true pedantic post would have stated that a view never contains rows, unless it is an indexed view. And it would have included a whiney remark about demanding back the oh so precious points that you were robbed off)
PS: To John Hanrahan - please take this comment as I intended it, as a stab to the annoying pedantic that, indeed, appears to be inevitable on the QotD topics. I did in fact enjoy this question very much, and I think it is an excellent question. I hope to see more questions from you in the future.