Guess that'll only happen once it is deprecated and was really purged out of the product. Which didn't happen in 2012 although I kind of expected it. At least the...

I noticed. Fixed now.

I like this reply to JC

Edit: Fixed the URL.

I presume this was just an example to illustrate your point, but overall, what was it you were trying to do? Get the top 3 Custumors' IDs, ordered by CustumorID...

You beat me to is Luis

Magnificent, Gail! Have a good party tonight!

CELKO (6/25/2012)

---

Jan Van der Eecken (6/25/2012)

---

Unless they coded ISNULL(a,b) as a wrapper around COALESCE(x1,x2,...,xn), which I would probably have done, just from a maintainability point of view. Then ISNULL should...

Unless they coded ISNULL(a,b) as a wrapper around COALESCE(x1,x2,...,xn), which I would probably have done, just from a maintainability point of view. Then ISNULL should actually be slower due to...

GSquared (6/25/2012)

---

Nah. It's a perfectly good question.

Another thing to keep in mind about IsNull vs Coalesce is that Coalesce is ISO-standard SQL, and has some slight advantages because of...

Don't take the word BIT in your mouth. JC is watching!

Just think about it.

You go to a grocery market and see this nice bucket of tomatoes (they are like in a heap) and say "I want them all". So the...

COALESCE allows an unlimited number of parameters and returns the value of the first expression, evaluated from left to right, that is not NULL.

See BOL on MSDN

I totally agree with Gail (who doesn't), but the assumption is that they, the temp tables...

---

L' Eomot Inversé (6/20/2012)

---

Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would...

Evil Kraig F (6/18/2012)

---

Jan Van der Eecken (6/18/2012)

---

Evil Kraig F (6/18/2012)

---

LOL, at this point, either is acceptable. 😉 :w00t:...