Not sure how to title or ask this really. Say I am getting a result set like this on a join of two tables, one contains the `Id` (C), the other contains the `Rating` and `CreatedDate` (R) with a foreign key to the first table:

```
-----------------------------------
| C.Id | R.Rating | R.CreatedDate |
-----------------------------------
| 2    | 5        | 12/08/1981    |
| 2    | 3        | 01/01/2001    |
| 5    | 1        | 11/11/2011    |
| 5    | 2        | 10/10/2010    |

```

I want this result set (the newest ones only):

```
-----------------------------------
| C.Id | R.Rating | R.CreatedDate |
-----------------------------------
| 2    | 3        | 01/01/2001    |
| 5    | 1        | 11/11/2011    |

```

This is a very large data set, and my methods (I won't mention which so there is no bias) is very slow to do this. Any ideas on how to get this set? It doesn't necessarily have to be a single query, this is in a stored procedure. 

Thank you!