Paul White NZ (9/3/2010)

---

Hugo,

I really want to break this down to a simple point which I hope everyone can agree on:

"The single requirement for Quirky Update is that rows get...

Are you...

Though I am very happy to see a question on a relatively new and very valuable option, I am a bit disappointed that the answers are debatable.

It all depends on...

Jeff Moden (2/7/2010)

---

Sorry this took longer than expected. Ah... looking back at the original post, I remember. What this proves is that my explanation as to why it...

Jeff Moden (9/2/2010)

---

No one has yet observed out-of-sequence updates if they've met ALL the rules. That's been since the earliest versions of Sybase and all versions, hot fixes, CU's,...

Well, yes and no.

It is...

boudinov (9/2/2010)

---

Hi Jeff,

I bet we would love to see "groupings on repeated data such as "Start/Stop" indications over time (although there is a clever way to solve that which will...

If you add the missing letter N (CONVERT), it does work. It is an explicit conversion from datetime to varchar format, using the yyyy/mm/dd format...

No, you are making a logic...

Oleg Netchaev (9/1/2010)

---

Hugo's script looks somewhat unusual because it uses some varchar value which is guaranteed to be dateformat independent valid datetime value (YYYYMMDD is always translated correctly regardless of...

Correct. That was April 14, and it was similar but not...

webrunner (9/1/2010)

---

DECLARE @a INT

DECLARE @b DATETIME

SET @a = @b

The above code executed successfully for me in SQL 2005 but gave the error listed in the answer when I ran it...

Dave62 (9/1/2010)

---

SELECT DATEADD(day, DATEDIFF(day, '20100101', CURRENT_TIMESTAMP), '20100101');

The only thing I don't like about this method is the hard-coded string. I suppose a dynamic expression could replace it but it...

I don't think so. I think the author wanted to convey that implicit conversion from...

Chris Cradock (9/1/2010)

---

I'm not attempting to say HAVING without GROUP BY is invalid, and yes adding MAX(col2) to the selected columns I would then expect the behaviour you describe (and...