Very cool. I'd love to see you write more details about how things actually went and what items you needed to change.

LastPass had an issue, but not incredibly unsecure. The issue was patched quickly.

It's not game over if your password manager is compromised. It's no worse than if you have other...

You are welcome. Hope you solve it. Let us know what works.

yes, your query is correct. Take out the subquery, like this:

( SELECT max(a2.TransactionEffDate)

FROM CodeChangesdata AS a2

WHERE a2.CodingNumber = 5

...

butcherking13 (7/29/2016)

---

I live in NW Louisiana and don't have a problem traveling to SQL Saturday.

This year I drove to:

Nashville(560 miles)

Atlanta(595 miles)

Pensacola(463 miles)

Houston(241 miles).

I will drive to Baton Rouge( 261 miles...

You need to grant rights in a database for the login. I don't know what rights are needed.

You can run this to create the user:

CREATE USER Bob FOR LOGIN BOB

...

The login is not mapped to a user with rights in the hospital database. This has been set as the default database for the login, but without rights in the...

The subquery is a correlated subquery. It's attempting to get the min, or max, value for the AdjustmentType and using that to limit the results. It looks like you are...

A tiny fraction

Bias is certainly there, but hopefully the data helps you sort out where you have bias, and where you have experience that matters.

I know it isn't simple, but as Anders...

Hugo Kornelis (7/29/2016)

---

Steve Jones - SSC Editor (7/29/2016)

---

I don't like limiting events, even in close proximity, to enable speakers to go to both. Make a choice. I always contact one...

I understand, and I am sorry for having made...

Tony++ (7/29/2016)

---

My local SQLSat in Minneapolis (Minnesota USA) is fantastic & I get to every one.

I've been able to time my work at the company plant so I can attend...

DelaDebbie (7/29/2016)

---

I haven't been to any (didn't know there was such a thing until I saw it mentioned in today's email), but I have been to a couple of SharePoint...

epfingsten (7/29/2016)

---

Unfortunately I have never been to a SQLSaturday. I live in Cincinnati and it looks like the closest ones to me have been in Columbus, which is about a...