Hi ttds,
Your Query is not so clear .
/*
Assuming Table name as tblPrice and Date Column to be colDate
*/
1) Incase if you want output as maximum price within 2 weeks
Select max(Price) from tblPrice
where colDate between Dateadd (dd,-14,getdate()) and getdate();
2) In case you want datewise max price as output
Select max(Price),colDate from tblPrice
where colDate between Dateadd (dd,-14,getdate()) and getdate()
group by colDate