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...

Aaron N. Cutshall (7/29/2016)

---

First off Steve, I completely agree with you about the new ruling for the 600 mile radius. Having SQL Saturdays in close proximity back-to-back allows many...

Hugo Kornelis (7/29/2016)

---

Disclaimer: When I go to a SQL Saturday event, it is usually as a speaker, not as an attendee. I am aware that speakers have a different view...