Assign value with max date to variable

Question

I have table with fields ID and date, I need to assign newest date to a variable where id is some number.

So if I have dates 2011-01-01 and 2011-02-02 where ID = 1, I need to assign 2011-02-02 to a variable.

Answer 1

DECLARE @MAXDATE DATETIME

SELECT @MAXDATE = MAX(DateVal)
FROM YourTable
WHERE ID = @ID

Answer 2

SELECT @Variable = Date
FROM YourTable
WHERE ID = 1
ORDER BY Date