title: IN SQL Server how to list high and low season
body: <p>For a database SQL Server 2008 I have a list of dates that are either in the high season, top price, or in the low season, low price.</p>
  <p>We have only three types of duration of stay for which it is relevant, week Monday till Monday, midweek Monday till Friday, or weekend Friday till Monday.</p>
  <p>Is it possible to say in a range that it belongs to the high season or low?
  On this moment we have just a list of all possible dates and in which season it belongs.</p>