You can use a CTE to get the max date from the table with the SH code along with the cartid and then join that to your other data.

with mycte...

I do agree with the = and try to use it, precisely because complex code becomes hard to read when the name is buried far to the right of...

The sixth one should have had brackets. That's been corrected. However, I missed a few since there could be no joiner (=/AS) in there, so it's probably more like 12....

Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html

tim.mckay (9/1/2015)

---

Just my two cents, but this points to a defect in client management. A strong project manager, business analyst and systems analyst should be able to nail...

julienchappel 38298 (8/31/2015)

---

Hi Steve, did you proof read this article before posting it. I got used to from you brilliant ideas, samples and solutions to follow, but this latest effort...

Not sure if I'll be in town, so I'm hoping Yahoo treats me fair.

Eric M Russell (9/1/2015)

---

Hi Steve,

What makes software and database estimating so difficult, even more so than legal defense or medical procedures, is that the client is telling us not only...

Joel Ewald (9/1/2015)

---

I think changing scope and situations occur in every industry and the entire reason we are paid is because as professionals we deal with it.

When you are billing...

xsevensinzx (9/1/2015)

---

I'm not really seeing the connection between the first linked stories in the first paragraph.

A solution--which is what the doctor is aiming to apply--is totally different than the benefit...

Is it me, or is the runner loafing from third?

http://m.mlb.com/video/topic/6479266/v434180983/nyybos-bradley-jr-makes-catch-throws-out-bird

We had a similar play this weekend. Hard grounder to deep short, and the runner on third goes at the...

That's a good analogy.

You can add tables in your update statement and join them, as shown here:

update table1

set x = y

from table 2

where table1.pk = table2.fk

Since many of you find issues and problems and answer them, maybe a few of you would want to submit some questions of the day?

http://www.sqlservercentral.com/Contributions/New/Question

Ed Wagner (8/31/2015)

---

SQLRNNR (8/31/2015)

---

Luis Cazares (8/31/2015)

---

Brandie Tarvin (8/31/2015)

---

I am planning to upgrade at least one of my machines. Haven't decided if it'll be the 8.1 or 7. But I'm waiting...