Hello and welcome to the forums!

If all you're after is to get the most recent date from ep.ReviewDate, this should suffice:

SELECT MAX(ep.ReviewDate)

FROM table_name ep;

If you want to get...

Allow me to cast my vote for Luis's second approach. I use the same approach myself when i need to de-dupe data. It divides the work into two...

What SSMS is saying is that you have a query running and closing SSMS will abort it. If you have a query that takes a long time to run,...

Jeff Moden (8/5/2014)

---

Eirikur Eiriksson (8/4/2014)

---

Jeff Moden (8/4/2014)

---

Eirikur Eiriksson (8/4/2014)

---

Koen Verbeeck (8/4/2014)

---

I am afraid I have left it...

The single most important piece of advice I can give you is to test it on a test system before doing it in production.

The first reason is a trust issue....

I did something almost identical several years ago (over FTP, not SFTP) using batch files to do an mget and then delete them. The problem I saw was that...

Cute. I think they left out a couple of things. My favorite is responding to the statement from users "The internet is down" in the middle of the...

Thanks for the question. Honestly, I used inline assignment so much that I didn't even give it a second look. The += however, I had to look three...

Eirikur Eiriksson (8/4/2014)

---

I'm relying on...

I don't see a question, but it is definitely a stack trace from .NET. Looks to me like a login doesn't have permission to do something against INFORMATION_SCHEMA.Columns. ...

SQLRNNR (8/4/2014)

---

djj (8/4/2014)

---

Found this from Paul S. Randal of SQLskills.com:

"Here's the rule: if my 14-yr old smart daughter could find the answer on Google from your question, you'd shouldn't ask...

ALZDBA (8/4/2014)

---

Koen Verbeeck (8/4/2014)

---

ALZDBA (8/4/2014)

---

Koen Verbeeck (8/4/2014)

---

Weird issue here.

I have a rather large DWH query. For testing purposes I singled out one single ID.

But sometimes the query returned 1 row,...

So early in...

Good way to start the week. I'm one of those who read the question and found it obvious, but had to re-read it because of the point value. ...

Boat