Thank-you for your responses everyone. The last post made me realize that perhaps I am over complicating this. I am still curious to see how my original question could be...

Basically the LAST looks for the latest YearOfIncident once it has been ranked and keeps that record. In Oracle you need to keep the min. The query may look at...

I'm sorry to be such a pain, I tried this:

SELECT MIN (ClaCaseID)

FROM (

SELECT cc.ClaCaseID, RID= DENSE_RANK() OVER (ORDER BY rl.YearOfIncident DESC) ...

The code works but it doesn't return the individual ClaCaseID's, rather a single value. I tried to add a group by clause but that didn't help, neither did adding a...

I tried your code and still no luck:

Error message I receive is:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'ClaCaseID'.

Msg 156, Level 15, State 1, Line 3

Incorrect syntax...

I received a date error so I fixed this error, it was the subtracting of two dates.

I then received the following error:

Msg 8120, Level 16, State 1, Line 1

Column...

Quick question: Can I mark this question as answered and add to the reputation of those that helped?

Thank-you everybody for your insight. ChrisM@Work your solution is exactly what I needed.

Sorry I really am a beginner:

So far I have managed to eliminate the milliseconds:

SELECT CAST(CURRENT_TIMESTAMP AS time(0))

Now I need it to round up or down to the closest hour. I...