I have a table that contains a series of MatchDates, i.e:
I need to add another column for the Season the match was played in.
The Season would be 2011-12 if the Match Date was between 1-Oct-2011 to 31-Mar-2012
The Season would be 2012 if the Match Date was between 1-Apr-2012 to 30-Sep-2012
Apart from manually setting up update satements for the past 200 years, is there a quick and easy way to automate this?