Assign a value with a maximum date to a variable

Question

I have a table with ID and date fields, I need to assign a new 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 the variable 2011-02-02 .

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 

Answer 3

Alternativelly:

 DECLARE @yourDate DATETIME SET @yourDate = (SELECT MAX(date) FROM yourTable WHERE ID = 1);