...insert yourtable(valuedate,[name],Exec_date,amount,Amounttype)
values('2006-03-28','Julian','2006-04-03 10:05:32.843',224,'USD')
select top 1 * from yourtable
where valuedate in (select max(valuedate) from yourtable
group by [name],Amounttype
having...