sql - group date range with specific range -

sql - group date range with specific range -

i know there's lots of grouping in date range. i've looked in internet. one's saw hard wired range. say,

case when [date] between '2014-1-1' , '2014-3-30' 1 when [date] between '2014-4-1' , '2014-6-30' 2 -- , on end

that covers year 2014, right? if need cover next 4 years or so. need manually set in query? or there way cover next coming years?

in specific, need grouping records range. aug jan (group 1) , feb july (group 2)

any help appreciated. thanks!

use month()

case when month([date]) between 2 , 7 2 else 1 end

sql sql-server tsql