Microsoft-SQL-ServerThe following T-SQL script defines list of all dutch holidays (public non working day in Holland) ( feestdagenĀ in Nederland). From Plansis – Enjoy!

DECLARE @dt AS DATE

SET @dt=’2013-01-01′

SELECT CASE
WHEN @dt IN ( ‘2002-01-01′,’2002-03-29′,’2002-03-31′,’2002-04-01′,’2002-04-30′,’2002-05-05′,’2002-05-09′,’2002-05-19′,’2002-05-20′,’2002-12-25′,’2002-12-26′,’2002-12-31′,’2003-01-01′,’2003-04-18′,’2003-04-20′,’2003-04-21′,’2003-04-30′,’2003-05-05′,’2003-05-29′,’2003-06-08′,’2003-06-09′,’2003-12-25′,’2003-12-26′,’2003-12-31′,’2004-01-01′,’2004-04-09′,’2004-04-11′,’2004-04-12′,’2004-04-30′,’2004-05-05′,’2004-05-20′,’2004-05-30′,’2004-05-31′,’2004-12-25′,’2004-12-26′,’2004-12-31′,’2005-01-01′,’2005-03-25′,’2005-03-27′,’2005-03-28′,’2005-04-30′,’2005-05-05′,’2005-05-05′,’2005-05-15′,’2005-05-16′,’2005-12-25′,’2005-12-26′,’2005-12-31′,’2006-01-01′,’2006-04-14′,’2006-04-16′,’2006-04-17′,’2006-04-30′,’2006-05-05′,’2006-05-25′,’2006-06-04′,’2006-06-05′,’2006-12-25′,’2006-12-26′,’2006-12-31′,’2007-01-01′,’2007-04-06′,’2007-04-08′,’2007-04-09′,’2007-04-30′,’2007-05-05′,’2007-05-17′,’2007-05-27′,’2007-05-28′,’2007-12-25′,’2007-12-26′,’2007-12-31′,’2008-01-01′,’2008-03-21′,’2008-04-23′,’2008-04-24′,’2008-04-30′,’2008-05-05′,’2008-05-01′,’2008-05-11′,’2008-05-12′,’2008-12-25′,’2008-12-26′,’2008-12-31′,’2009-01-01′,’2009-04-10′,’2009-04-12′,’2009-04-13′,’2009-04-30′,’2009-05-05′,’2009-05-21′,’2009-05-31′,’2009-06-01′,’2009-12-25′,’2009-12-26′,’2009-12-31′,’2010-01-01′,’2010-04-02′,’2010-04-04′,’2010-04-05′,’2010-04-30′,’2010-05-05′,’2010-05-13′,’2010-05-23′,’2010-05-24′,’2010-12-25′,’2010-12-26′,’2010-12-31′,’2011-01-01′,’2011-04-22′,’2011-04-24′,’2011-04-25′,’2011-04-30′,’2011-05-05′,’2011-06-02′,’2011-06-12′,’2011-06-13′,’2011-12-25′,’2011-12-26′,’2011-12-31′,’2012-01-01′,’2012-04-06′,’2012-04-08′,’2012-04-09′,’2012-04-30′,’2012-05-05′,’2012-05-17′,’2012-05-27′,’2012-05-28′,’2012-12-25′,’2012-12-26′,’2012-12-31′,’2013-01-01′,’2013-01-01′,’2013-03-29′,’2013-03-31′,’2013-04-01′,’2013-04-30′,’2013-05-05′,’2013-05-09′,’2013-05-19′,’2013-05-20′,’2013-12-25′,’2013-12-26′,’2013-12-31′,’2014-01-01′,’2014-04-18′,’2014-04-20′,’2014-04-21′,’2014-04-30′,’2014-05-05′,’2014-05-29′,’2014-06-08′,’2014-06-09′,’2014-12-25′,’2014-12-26′,’2014-12-31′,’2015-01-01′,’2015-04-03′,’2015-04-05′,’2015-04-06′,’2015-04-30′,’2015-05-05′,’2015-05-14′,’2015-05-24′,’2015-05-25′,’2015-12-25′,’2015-12-26′,’2015-12-31′,’2016-01-01′,’2016-03-25′,’2016-04-27′,’2016-04-28′,’2016-04-30′,’2016-05-05′,’2016-05-05′,’2016-05-15′,’2016-05-16′,’2016-12-25′,’2016-12-26′,’2016-12-31′,’2017-01-01′,’2017-04-14′,’2017-04-16′,’2017-04-17′,’2017-04-30′,’2017-05-05′,’2017-05-25′,’2017-06-04′,’2017-06-05′,’2017-12-25′,’2017-12-26′,’2017-12-31′,’2018-01-01′,’2018-03-30′,’2018-04-01′,’2018-04-02′,’2018-04-30′,’2018-05-05′,’2018-05-10′,’2018-05-20′,’2018-05-21′,’2018-12-25′,’2018-12-26′,’2018-12-31′,’2019-01-01′,’2019-04-19′,’2019-04-21′,’2019-04-22′,’2019-04-30′,’2019-05-05′,’2019-05-30′,’2019-06-09′,’2019-06-10′,’2019-12-25′,’2019-12-26′,’2019-12-31′,’2020-01-01′,’2020-04-10′,’2020-04-12′,’2020-04-13′,’2020-04-30′,’2020-05-05′,’2020-05-21′,’2020-05-31′,’2020-06-01′,’2020-12-25′,’2020-12-26′,’2020-12-31′,’2021-01-01′,’2021-04-02′,’2021-04-04′,’2021-04-05′,’2021-04-30′,’2021-05-05′,’2021-05-13′,’2021-05-23′,’2021-05-24′,’2021-12-25′,’2021-12-26′,’2021-12-31′,’2022-01-01′,’2022-04-15′,’2022-04-17′,’2022-04-18′,’2022-04-30′,’2022-05-05′,’2022-05-26′,’2022-06-05′,’2022-06-06′,’2022-12-25′,’2022-12-26′,’2022-12-31′,’2023-01-01′,’2023-04-07′,’2023-04-09′,’2023-04-10′,’2023-04-30′,’2023-05-05′,’2023-05-18′,’2023-05-28′,’2023-05-29′,’2023-12-25′,’2023-12-26′,’2023-12-31′,’2024-01-01′,’2024-03-29′,’2024-03-31′,’2024-04-01′,’2024-04-30′,’2024-05-05′,’2024-05-09′,’2024-05-19′,’2024-05-20′,’2024-12-25′,’2024-12-26′,’2024-12-31′,’2025-01-01′,’2025-04-18′,’2025-04-20′,’2025-04-21′,’2025-04-30′,’2025-05-05′,’2025-05-29′,’2025-06-08′,’2025-06-09′,’2025-12-25′,’2025-12-26′,’2025-12-31′,’2026-01-01′,’2026-04-03′,’2026-04-05′,’2026-04-06′,’2026-04-30′,’2026-05-05′,’2026-05-14′,’2026-05-24′,’2026-05-25′,’2026-12-25′,’2026-12-26′,’2026-12-31′,’2027-01-01′,’2027-03-27′,’2027-03-29′,’2027-03-30′,’2027-04-30′,’2027-05-05′,’2027-05-06′,’2027-05-16′,’2027-05-17′,’2027-12-25′,’2027-12-26′,’2027-12-31′,’2028-01-01′,’2028-04-14′,’2028-04-16′,’2028-04-17′,’2028-04-30′,’2028-05-05′,’2028-05-25′,’2028-06-04′,’2028-06-05′,’2028-12-25′,’2028-12-26′,’2028-12-31′,’2029-01-01′,’2029-03-30′,’2029-04-01′,’2029-04-02′,’2029-04-30′,’2029-05-05′,’2029-05-10′,’2029-05-20′,’2029-05-21′,’2029-12-25′,’2029-12-26′,’2029-12-31′,’2030-01-01′,’2030-04-19′,’2030-04-21′,’2030-04-22′,’2030-04-30′,’2030-05-05′,’2030-05-30′,’2030-06-09′,’2030-06-10′,’2030-12-25′,’2030-12-26′,’2030-12-31’) THEN ‘1’
ELSE ‘0’
END ‘IsDutchHolliday’