select UniformGroupID, price from UniformPrice where (datename(YEAR, CONVERT (datetime,EffectiveDate, 103))='2012' and datename(MONTH, CONVERT (datetime,EffectiveDate, 103))='October') between (datename(YEAR, CONVERT (datetime,CloseDate, 103)='2999' and datename(MONTH, CONVERT (datetime,CloseDate, 103))='December')
SELECT UniformGroupID, price FROM UniformPrice WHERE CONVERT (datetime,EffectiveDate, 103) BETWEEN '1/10/2012' AND '31/12/2999' AND CONVERT (datetime,CloseDate, 103) BETWEEN '1/10/2012' AND '31/12/2999'
SELECT UniformGroupID, price FROM UniformPrice WHERE DATEPART(yyyy,EffectiveDate) BETWEEN '2012' AND '2999' AND DATEPART(mm,CloseDate) BETWEEN '10' AND '12'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)