select * from table where (Year >= 2013 and Month >=4) AND (Year <= 2014 and Month <=3)
select SUM(amt) from ( sELECT SUM(amount) amt FROM test1 WHERE ([month]>=3 and [year]=2013) union select sum(amount) amt from test1 where ([month]<=3 and [year]=2014) ) test
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)