>In SQL Server, What would be my Statement to retreive a record with the latest date ?
>
>Someting Like This : Select * From MyTable Where Product = ?Parm1 And ???ChangedDate Is The Latest ???
>
>Thanks for your help
Select * From mytable Where product = ?Parm1
And ChangeDate In
(Select Max(ChangeDate)
From mytable
Where product = ?Parm1)
Insanity: Doing the same thing over and over and expecting different results.