JimS-Indy (8/28/2012)

---

I am a shadow IT warrior. Unlike most, I have a long (30+yrs) background and high respect for the principles that undergird IT. I exist (and am well-paid for...

Didn't know about the 1000 value limit, but did correctly discern the question was about that limit. As I never use that many explicit values (usually paste them into a...

That's probably the best benefit of QotD. You get people posting questions about...

Made the same assumption. Since I had never implicitly converted like this,...

Hugo, when I was in school, everyone tried to copy off my paper. Had you...

Hugo Kornelis (8/17/2012)

---

I appreciate the amount of research that went into this question and I think it has a good educational value, but I don't think a QotD is the...

Nice question. Thanks for the contribution. Never thought of truncating a temp table. But, it reminded me about limitations of this feature.

Samith, thanks for contributing! Always interesting, and potentially contentious, when NULLs are brought up. But, good to keep thinking of them.

Excellent question. I particularly like questions, like this one, that highlight areas where the behavior is not as one might think, or is different than you might find in other...

Sometimes things are just that easy. After last week, I'm glad to get this week off to a good start. Bless you for you QotD contribution.

Of course it will. I spent a...

Thanks for an easy one. I was thinking of you (Stanley) this week, due to your sig line:

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to...

I appreciate this type of question. Thanks for posting. Yeah, there were typos. But, I dropped my halo this week too. :hehe:

Edited to correct spelling error - clicked post when...

SQLRNNR (8/7/2012)

---

If that is indeed the case, then I...

Thomas Abraham (8/7/2012)

+2 - This question has GOTCHA written all over it. While I admit I should have been more careful in reading the question, the question title and the...