Select * from Orders2 where quarter([OrderDate]) >= 1 AND year([OrderDate]) >= 2010 and quarter([OrderDate])<=12 and year([OrderDate]) <= 2011
SELECT DATEPART(quarter, OrderDate) --OR SELECT DATEPART(qq, OrderDate) --OR SELECT DATEPART(q, OrderDate)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)