Check the format for DATEADD in BOL - you aren't using it correctly.

BrainDonor

mbookout (2/4/2010)

---

Thanks! But how would I get either of those to compare with the next record? I know how to do it with two date fields within the same...

And DATEDIFF - two ways to solve the same problem.

BrainDonor

Duplicate post, responses to:

http://www.sqlservercentral.com/Forums/Topic859597-146-1.aspx

Roy Ernest (2/2/2010)

---

By seeing your last post on...

Indeed it will. However, you've had to split the values yourself - originally...

I've been waiting for weeks for this one to show their head over the parapet.

BrainDonor.

No.

I will however take as long as is required to help you to work out how to write it. That is how...

In which case you need to check the right-most character of the value first, and then if that is within range you can check the numeric part.

BrainDonor.

I can't say I've ever given any thought as to why MS names things the way it does (that way lies madness), but it probably generates some type of GUID...

Paul White (1/26/2010)

---

BrainDonor (1/26/2010)

---

Steve, could you give this call a nudge - it appears to be stuck....

http://www.sqlservercentral.com/Forums/FindPost853470.aspx

The same message three times in a row - he's determined someone will write...

Steve, could you give this call a nudge - it appears to be stuck....

http://www.sqlservercentral.com/Forums/FindPost853470.aspx

The same message three times in a row - he's determined someone will write it for him.

Its called a Table Alias, and is a way of making SQL code...

Steve Jones - Editor (1/25/2010)

---

You can easily change a SELECT to an update.

Lastly, add in your SET clause where you set values.

update a

set a.SalesDate = b.SalesDate

from...

The update statement is different, but the thinking behind it that solved the previous question is very similair.

You can update a field in a table with a subquery - using...