Had to guess. Reasoned that change tracking would require a PK. How else would you know what was changed? Thanks for the question.

Rich Weissler (7/5/2013)

---

Thomas Abraham (7/4/2013)

---

Thanks for the question Steve. However, in the spirit of harmonic international relations, I propose that we extend the same courtesy to other countries: August 1st...

Thanks for the question Steve. However, in the spirit of harmonic international relations, I propose that we extend the same courtesy to other countries: August 1st for Switzerland, October 28...

Patibandla (7/2/2013)

---

What if i define @s-2 as BIGINT

Can you give me a real time scenario as in this operator would be useful. i am just a bit curious as i...

Didn't notice the boxes were, well, boxes. So only selected one answer, which appears to be only half the correct answer.

Thanks for the question. BTW, do you get jokes at...

Jeff Moden (5/25/2013)

---

Thak you very much for the feedback and for stopping by. I hope you're talking about the "Nested Replace" solution and not the one in the article....

Stumbled across this thread with a Google search. (Amazing how all paths lead 'home'.)

The elegance of the solution to this problem in SQL is amazing. Got a warm glow when...

I envision a day when people will cite HKOL instead of BOL.

Nicely posed and explained. I suspected the BETWEEN might cause a problem, but went for the wrong answer anyway.

I lost those two very valuable points, delaying my retirement by at...

Toni-256719 (5/13/2013)

---

There is a syntax error in the select statement.

I assumed this was another one of those "trick" questions.

If you're going to submit a QOTD, you do need...

I too found the question clear. Excellent question, and well posed.

Thank you for you contribution. More please.

Thanks for the question. In general, I don't favor questions the require 57 answers to be evaluated. However, this one was OK as the code involved wasn't too complex.

Nice idea, not so nice implementation.

It occurs to me that most of us will labor on a question by ourselves, not getting much input, sometimes producing a question that...

Thank you for the effort and question. I agree that the question could have been written more clearly/shorter, but you are on the right track. Please submit more questions.