GSquared (12/11/2012)

---

Change the "o.entered_date <> '2012-12-11 06:35:55.120'" to a simple less-than. Should be "o.entered_date < '2012-12-11 06:35:55.120'". "<" not "<>". You want the next one reverse date...

I believe the following will do what you need...

SELECT TOP 1

o.name, MAX(o.entered_date) as date

FROM

...

This is a pretty crazy proc (new job and I was given a list of long-running queries and told to see if I could speed any up). I saw...

That's a fair question.

I don't know that I can prove it 100%. What I can say, though, is that I can monitor disk space for the better part of...

Well, I finally got everything to work. As I said before, I completely misunderstood the ROW_NUMBER function. Once I had that done, I was able to get the...

Much, much closer. Still a couple things to work out, but now I understand how ROW_NUMBER works. I completely misunderstood it before.

CREATE TABLE deed (deed_id INT IDENTITY(1,1), deed_name VARCHAR(25))

GO

INSERT INTO deed (deed_name) VALUES ('Deed F')

INSERT INTO deed (deed_name) VALUES ('Deed C')

INSERT INTO deed (deed_name) VALUES ('Deed I')

INSERT INTO deed (deed_name) VALUES...

I did look into ROW_NUMBER as an option. I could use it to return the correct rows, but the application needs the actual value as well.

Excellent!

I knew I had to be missing something, but could not figure out what it was.