SELECT MAX(Price) FROM myTable WHERE DateDiff(ww, OrderDate, getDate()) < 2
SELECT MAX(Price) FROM myTable WHERE OrderDate BETWEEN '2012-12-12' AND '2012-11-28'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)