I think it's more like...

L' Eomot Inversé (8/22/2013)

---

Hugo Kornelis (8/22/2013)

---

So where does all the confusion with "unknown" come from? (To my surprise, I see that even Tom, a man I normally agree with on...

Dave62 (8/22/2013)

---

I can see why this creates confusion with concatenation. People in the "unknown" camp will have difficulty concatenating an unknown value with a known value. In contrast,...

This reply has been left deliberately emoticon-less

See?

I can do it!

Dave62 (8/22/2013)

---

I've been building databases since I started working with PFS File in the 1980's. :w00t:

It seems like there is a literal meaning for NULL, which is "unknown", and a...

Woohoo! More points for me!

(so why am I still not on the #1 spot, eh?)

:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D

:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D

(just to show that...

Maybe you should specify WHERE in...

Heh! I've seen demo's of DQS, and of all the adjectives one could use to describe it, "pretty" would be pretty...

Mike Dougherty-384281 (8/19/2013)

---

I think I'll continue with the belief that "return" belongs at the end of a procedure. If I ever see anyone in my group using return in...

So, can someone here tell me what exactly the point (pun not intended) of this question is supposed to be?

Stevenna1 (8/8/2013)

---

But in this case, the solution to fix the "issue" was this (sic).

If we share the where clause from NOT EXISTS to EXISTS it will...

sestell1 (8/8/2013)

---

crussell-931424 (8/8/2013)

---

Interesting. I didn't realize that nullif is really a case statement and that any function would then get executed multiple times. Of course in this case the function...

Stevenna1 (8/8/2013)

---

Ok Hugo, My last point, because the Qotd, I agree, its nice to see challenging things.

But the answer; Simply changing the SQL to Exists makes the...

Stevenna1 (8/8/2013)

---

Hugo, Conventions & parsing aside. Are we to believe that someone would write something so convoluted to demonstrate Exists/Not Exists Syntax ( select(1=1))

I mean it doesn't even...

Stevenna1 (8/8/2013)

---

Am I missing something here ?

The query has a BUG in it it has nothing to do with 1=1

Declare @customer Table ( ID int

...