>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 ???
Off the top of my head, without testing:
SELECT *
FROM myTable t1
WHERE product = ?cParm1
AND changedDate =
(SELECT product, MAX(changedDate)
FROM myTable t2
WHERE t1.product = t2.product
GROUP BY product)