Тогда так:
SELECT TOP 1 @MyName=name from MyTable where ID=@MyID ORDER BY [TIME] DESC