CREATE TABLE #UKHolidayDates (
dtDate DATETIME NOT NULL PRIMARY KEY,
chDescription VARCHAR(255) NOT NULL
)
INSERT #UKHolidayDates (dtDate, chDescription)
SELECT '01 Jan 1990', 'New Year''s Day' UNION ALL
SELECT '13 Apr 1990', 'Good Friday' UNION ALL
SELECT '16 Apr 1990', 'Easter Monday' UNION ALL
SELECT '07 May 1990', 'Early May Bank Holiday' UNION ALL
SELECT '28 May 1990', 'Spring Bank Holiday' UNION ALL
SELECT '27 Aug 1990', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1990', 'Christmas Day' UNION ALL
SELECT '26 Dec 1990', 'Boxing Day' UNION ALL
SELECT '01 Jan 1991', 'New Year''s Day' UNION ALL
SELECT '29 Mar 1991', 'Good Friday' UNION ALL
SELECT '01 Apr 1991', 'Easter Monday' UNION ALL
SELECT '06 May 1991', 'Early May Bank Holiday' UNION ALL
SELECT '27 May 1991', 'Spring Bank Holiday' UNION ALL
SELECT '26 Aug 1991', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1991', 'Christmas Day' UNION ALL
SELECT '26 Dec 1991', 'Boxing Day' UNION ALL
SELECT '01 Jan 1992', 'New Year''s Day' UNION ALL
SELECT '17 Apr 1992', 'Good Friday' UNION ALL
SELECT '20 Apr 1992', 'Easter Monday' UNION ALL
SELECT '04 May 1992', 'Early May Bank Holiday' UNION ALL
SELECT '25 May 1992', 'Spring Bank Holiday' UNION ALL
SELECT '31 Aug 1992', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1992', 'Christmas Day' UNION ALL
SELECT '28 Dec 1992', 'Boxing Day' UNION ALL
SELECT '01 Jan 1993', 'New Year''s Day' UNION ALL
SELECT '09 Apr 1993', 'Good Friday' UNION ALL
SELECT '12 Apr 1993', 'Easter Monday' UNION ALL
SELECT '03 May 1993', 'Early May Bank Holiday' UNION ALL
SELECT '31 May 1993', 'Spring Bank Holiday' UNION ALL
SELECT '30 Aug 1993', 'Summer Bank Holiday' UNION ALL
SELECT '27 Dec 1993', 'Christmas Day' UNION ALL
SELECT '28 Dec 1993', 'Boxing Day' UNION ALL
SELECT '03 Jan 1994', 'New Year''s Day' UNION ALL
SELECT '01 Apr 1994', 'Good Friday' UNION ALL
SELECT '04 Apr 1994', 'Easter Monday' UNION ALL
SELECT '02 May 1994', 'Early May Bank Holiday' UNION ALL
SELECT '30 May 1994', 'Spring Bank Holiday' UNION ALL
SELECT '29 Aug 1994', 'Summer Bank Holiday' UNION ALL
SELECT '26 Dec 1994', 'Boxing Day' UNION ALL
SELECT '27 Dec 1994', 'Christmas Day' UNION ALL
SELECT '02 Jan 1995', 'New Year''s Day' UNION ALL
SELECT '14 Apr 1995', 'Good Friday' UNION ALL
SELECT '17 Apr 1995', 'Easter Monday' UNION ALL
SELECT '01 May 1995', 'Early May Bank Holiday' UNION ALL
SELECT '29 May 1995', 'Spring Bank Holiday' UNION ALL
SELECT '28 Aug 1995', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1995', 'Christmas Day' UNION ALL
SELECT '26 Dec 1995', 'Boxing Day' UNION ALL
SELECT '01 Jan 1996', 'New Year''s Day' UNION ALL
SELECT '05 Apr 1996', 'Good Friday' UNION ALL
SELECT '08 Apr 1996', 'Easter Monday' UNION ALL
SELECT '06 May 1996', 'Early May Bank Holiday' UNION ALL
SELECT '27 May 1996', 'Spring Bank Holiday' UNION ALL
SELECT '26 Aug 1996', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1996', 'Christmas Day' UNION ALL
SELECT '26 Dec 1996', 'Boxing Day' UNION ALL
SELECT '01 Jan 1997', 'New Year''s Day' UNION ALL
SELECT '28 Mar 1997', 'Good Friday' UNION ALL
SELECT '31 Mar 1997', 'Easter Monday' UNION ALL
SELECT '05 May 1997', 'Early May Bank Holiday' UNION ALL
SELECT '26 May 1997', 'Spring Bank Holiday' UNION ALL
SELECT '25 Aug 1997', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1997', 'Christmas Day' UNION ALL
SELECT '26 Dec 1997', 'Boxing Day' UNION ALL
SELECT '01 Jan 1998', 'New Year''s Day' UNION ALL
SELECT '10 Apr 1998', 'Good Friday' UNION ALL
SELECT '13 Apr 1998', 'Easter Monday' UNION ALL
SELECT '04 May 1998', 'Early May Bank Holiday' UNION ALL
SELECT '25 May 1998', 'Spring Bank Holiday' UNION ALL
SELECT '31 Aug 1998', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 1998', 'Christmas Day' UNION ALL
SELECT '28 Dec 1998', 'Boxing Day' UNION ALL
SELECT '01 Jan 1999', 'New Year''s Day' UNION ALL
SELECT '02 Apr 1999', 'Good Friday' UNION ALL
SELECT '05 Apr 1999', 'Easter Monday' UNION ALL
SELECT '03 May 1999', 'Early May Bank Holiday' UNION ALL
SELECT '31 May 1999', 'Spring Bank Holiday' UNION ALL
SELECT '30 Aug 1999', 'Summer Bank Holiday' UNION ALL
SELECT '27 Dec 1999', 'Christmas Day' UNION ALL
SELECT '28 Dec 1999', 'Boxing Day' UNION ALL
SELECT '31 Dec 1999', 'Millenium Bank Holiday' UNION ALL
SELECT '03 Jan 2000', 'New Year''s Day' UNION ALL
SELECT '21 Apr 2000', 'Good Friday' UNION ALL
SELECT '24 Apr 2000', 'Easter Monday' UNION ALL
SELECT '01 May 2000', 'Early May Bank Holiday' UNION ALL
SELECT '29 May 2000', 'Spring Bank Holiday' UNION ALL
SELECT '28 Aug 2000', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2000', 'Christmas Day' UNION ALL
SELECT '26 Dec 2000', 'Boxing Day' UNION ALL
SELECT '01 Jan 2001', 'New Year''s Day' UNION ALL
SELECT '13 Apr 2001', 'Good Friday' UNION ALL
SELECT '16 Apr 2001', 'Easter Monday' UNION ALL
SELECT '07 May 2001', 'Early May Bank Holiday' UNION ALL
SELECT '28 May 2001', 'Spring Bank Holiday' UNION ALL
SELECT '27 Aug 2001', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2001', 'Christmas Day' UNION ALL
SELECT '26 Dec 2001', 'Boxing Day' UNION ALL
SELECT '01 Jan 2002', 'New Year''s Day' UNION ALL
SELECT '29 Mar 2002', 'Good Friday' UNION ALL
SELECT '01 Apr 2002', 'Easter Monday' UNION ALL
SELECT '06 May 2002', 'Early May Bank Holiday' UNION ALL
SELECT '03 Jun 2002', 'Extra bank holiday to mark Queen Elizabeth''s Golden Jubilee in 2002' UNION ALL
SELECT '04 Jun 2002', 'Spring Bank Holiday (moved from 27th May for Golden Jubilee of Elizabeth II)' UNION ALL
SELECT '26 Aug 2002', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2002', 'Christmas Day' UNION ALL
SELECT '26 Dec 2002', 'Boxing Day' UNION ALL
SELECT '01 Jan 2003', 'New Year''s Day' UNION ALL
SELECT '18 Apr 2003', 'Good Friday' UNION ALL
SELECT '21 Apr 2003', 'Easter Monday' UNION ALL
SELECT '05 May 2003', 'Early May Bank Holiday' UNION ALL
SELECT '26 May 2003', 'Spring Bank Holiday' UNION ALL
SELECT '25 Aug 2003', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2003', 'Christmas Day' UNION ALL
SELECT '26 Dec 2003', 'Boxing Day' UNION ALL
SELECT '01 Jan 2004', 'New Year''s Day' UNION ALL
SELECT '09 Apr 2004', 'Good Friday' UNION ALL
SELECT '12 Apr 2004', 'Easter Monday' UNION ALL
SELECT '03 May 2004', 'Early May Bank Holiday' UNION ALL
SELECT '31 May 2004', 'Spring Bank Holiday' UNION ALL
SELECT '30 Aug 2004', 'Summer Bank Holiday' UNION ALL
SELECT '27 Dec 2004', 'Christmas Day' UNION ALL
SELECT '28 Dec 2004', 'Boxing Day' UNION ALL
SELECT '03 Jan 2005', 'New Year''s Day' UNION ALL
SELECT '25 Mar 2005', 'Good Friday' UNION ALL
SELECT '28 Mar 2005', 'Easter Monday' UNION ALL
SELECT '02 May 2005', 'Early May Bank Holiday' UNION ALL
SELECT '30 May 2005', 'Spring Bank Holiday' UNION ALL
SELECT '29 Aug 2005', 'Summer Bank Holiday' UNION ALL
SELECT '26 Dec 2005', 'Boxing Day' UNION ALL
SELECT '27 Dec 2005', 'Christmas Day' UNION ALL
SELECT '02 Jan 2006', 'New Year''s Day' UNION ALL
SELECT '14 Apr 2006', 'Good Friday' UNION ALL
SELECT '17 Apr 2006', 'Easter Monday' UNION ALL
SELECT '01 May 2006', 'Early May Bank Holiday' UNION ALL
SELECT '29 May 2006', 'Spring Bank Holiday' UNION ALL
SELECT '28 Aug 2006', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2006', 'Christmas Day' UNION ALL
SELECT '26 Dec 2006', 'Boxing Day' UNION ALL
SELECT '01 Jan 2007', 'New Year''s Day' UNION ALL
SELECT '06 Apr 2007', 'Good Friday' UNION ALL
SELECT '09 Apr 2007', 'Easter Monday' UNION ALL
SELECT '07 May 2007', 'Early May Bank Holiday' UNION ALL
SELECT '28 May 2007', 'Spring Bank Holiday' UNION ALL
SELECT '27 Aug 2007', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2007', 'Christmas Day' UNION ALL
SELECT '26 Dec 2007', 'Boxing Day' UNION ALL
SELECT '01 Jan 2008', 'New Year''s Day' UNION ALL
SELECT '21 Mar 2008', 'Good Friday' UNION ALL
SELECT '24 Mar 2008', 'Easter Monday' UNION ALL
SELECT '05 May 2008', 'Early May Bank Holiday' UNION ALL
SELECT '26 May 2008', 'Spring Bank Holiday' UNION ALL
SELECT '25 Aug 2008', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2008', 'Christmas Day' UNION ALL
SELECT '26 Dec 2008', 'Boxing Day' UNION ALL
SELECT '01 Jan 2009', 'New Year''s Day' UNION ALL
SELECT '10 Apr 2009', 'Good Friday' UNION ALL
SELECT '13 Apr 2009', 'Easter Monday' UNION ALL
SELECT '04 May 2009', 'Early May Bank Holiday' UNION ALL
SELECT '25 May 2009', 'Spring Bank Holiday' UNION ALL
SELECT '31 Aug 2009', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2009', 'Christmas Day' UNION ALL
SELECT '28 Dec 2009', 'Boxing Day' UNION ALL
SELECT '01 Jan 2010', 'New Year''s Day' UNION ALL
SELECT '02 Apr 2010', 'Good Friday' UNION ALL
SELECT '05 Apr 2010', 'Easter Monday' UNION ALL
SELECT '03 May 2010', 'Early May Bank Holiday' UNION ALL
SELECT '31 May 2010', 'Spring Bank Holiday' UNION ALL
SELECT '30 Aug 2010', 'Summer Bank Holiday' UNION ALL
SELECT '27 Dec 2010', 'Christmas Day' UNION ALL
SELECT '28 Dec 2010', 'Boxing Day' UNION ALL
SELECT '03 Jan 2011', 'New Year''s Day' UNION ALL
SELECT '22 Apr 2011', 'Good Friday' UNION ALL
SELECT '25 Apr 2011', 'Easter Monday' UNION ALL
SELECT '29 Apr 2011', 'Special bank holiday for the Royal Wedding' UNION ALL
SELECT '02 May 2011', 'Early May Bank Holiday' UNION ALL
SELECT '30 May 2011', 'Spring Bank Holiday' UNION ALL
SELECT '29 Aug 2011', 'Summer Bank Holiday' UNION ALL
SELECT '26 Dec 2011', 'Christmas Day' UNION ALL
SELECT '27 Dec 2011', 'Boxing Day' UNION ALL
SELECT '02 Jan 2012', 'New Year''s Day' UNION ALL
SELECT '06 Apr 2012', 'Good Friday' UNION ALL
SELECT '09 Apr 2012', 'Easter Monday' UNION ALL
SELECT '07 May 2012', 'Early May Bank Holiday' UNION ALL
SELECT '04 Jun 2012', 'Spring Bank Holiday (moved from 28th May)' UNION ALL
SELECT '05 Jun 2012', 'Special bank holiday to mark Queen Elizabeth''s Diamond Jubilee' UNION ALL
SELECT '27 Aug 2012', 'Summer Bank Holiday' UNION ALL
SELECT '25 Dec 2012', 'Christmas Day' UNION ALL
SELECT '26 Dec 2012', 'Boxing Day'
go
SELECT * FROM #UKHolidayDates