--Begin 2018
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Helg', ColorId = 10 WHERE CalendarDayName = 'Lördag' OR CalendarDayName = 'Söndag'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2018-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2018-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredagen', ColorId = 10 WHERE CalendarDate = '2018-03-30 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2018-04-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2018-04-02 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2018-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2018-05-10 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2018-05-20 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2018-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagen', ColorId = 10 WHERE CalendarDate = '2018-06-23 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2018-11-03 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2018-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2018-12-26 00:00:00.000'
GO
--End 2018

--Begin 2019
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2019-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2019-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2019-04-19 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2019-04-21 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2019-04-22 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2019-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2019-05-30 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2019-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2019-06-09 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2019-06-22 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2019-11-02 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2019-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2019-12-26 00:00:00.000'
GO
--End 2019

--Begin 2020
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2020-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2020-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2020-04-10 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2020-04-12 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2020-04-13 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2020-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2020-05-21 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2020-05-31 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2020-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2020-06-20 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2020-10-31 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2020-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2020-12-26 00:00:00.000'
GO
--End 2020

--Begin 2021
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2021-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2021-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2021-04-02 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2021-04-04 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2021-04-05 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2021-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2021-05-13 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2021-05-23 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2021-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2021-06-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2021-11-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2021-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2021-12-26 00:00:00.000'
GO
--End 2021

--Begin 2022
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2022-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2022-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2022-04-15 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2022-04-17 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2022-04-18 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2022-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2022-05-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2022-06-05 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2022-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2022-06-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2022-11-05 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2022-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2022-12-26 00:00:00.000'
GO
--End 2022

--Begin 2023
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2023-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2023-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2023-04-07 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2023-04-09 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2023-04-10 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2023-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2023-05-18 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2023-05-28 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2023-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2023-06-24 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2023-11-04 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2023-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2023-12-26 00:00:00.000'
GO
--End 2023

--Begin 2024
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2024-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2024-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2024-03-29 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2024-03-31 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2024-04-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2024-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2024-05-09 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2024-05-19 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2024-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2024-06-22 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2024-11-02 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2024-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2024-12-26 00:00:00.000'
GO
--End 2024

--Begin 2025
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2025-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2025-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2025-04-18 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2025-04-20 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2025-04-21 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2025-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2025-05-29 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2025-06-08 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2025-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2025-06-21 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2025-11-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2025-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2025-12-26 00:00:00.000'
GO
--End 2025

--Begin 2026
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2026-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2026-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2026-04-03 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2026-04-05 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2026-04-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2026-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2026-05-14 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2026-05-24 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2026-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2026-06-20 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2026-10-31 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2026-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2026-12-26 00:00:00.000'
GO
--End 2026

--Begin 2027
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2027-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2027-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2027-03-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2027-03-28 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2027-03-29 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2027-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2027-05-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2027-05-16 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2027-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2027-06-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2027-11-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2027-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2027-12-26 00:00:00.000'
GO
--End 2027

--Begin 2028
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2028-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2028-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2028-04-14 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2028-04-16 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2028-04-17 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2028-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2028-05-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2028-06-04 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2028-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2028-06-24 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2028-11-04 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2028-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2028-12-26 00:00:00.000'
GO
--End 2028

--Begin 2029
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2029-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2029-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2029-03-30 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2029-04-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2029-04-02 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2029-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2029-05-10 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2029-05-20 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2029-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2029-06-23 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2029-11-03 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2029-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2029-12-26 00:00:00.000'
GO
--End 2029

--Begin 2030
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2030-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2030-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2030-04-19 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2030-04-21 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2030-04-22 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2030-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2030-05-30 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2030-06-09 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2030-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2030-06-22 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2030-11-02 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2030-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2030-12-26 00:00:00.000'
GO
--End 2030

--Begin 2031
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2031-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2031-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2031-04-11 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2031-04-13 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2031-04-14 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2031-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2031-05-22 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2031-06-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2031-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2031-06-21 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2031-11-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2031-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2031-12-26 00:00:00.000'
GO
--End 2031

--Begin 2032
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2032-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2032-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2032-03-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2032-03-28 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2032-03-29 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2032-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2032-05-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2032-05-16 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2032-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2032-06-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2032-11-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2032-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2032-12-26 00:00:00.000'
GO
--End 2032

--Begin 2033
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2033-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2033-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2033-04-15 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2033-04-17 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2033-04-18 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2033-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2033-05-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2033-06-05 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2033-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2033-06-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2033-11-05 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2033-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2033-12-26 00:00:00.000'
GO
--End 2033

--Begin 2034
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2034-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2034-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2034-04-07 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2034-04-09 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2034-04-10 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2034-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2034-05-18 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2034-05-28 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2034-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2034-06-24 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2034-11-04 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2034-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2034-12-26 00:00:00.000'
GO
--End 2034

--Begin 2035
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nyårsdagen', ColorId = 10 WHERE CalendarDate = '2035-01-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Trettondagen', ColorId = 10 WHERE CalendarDate = '2035-01-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Långfredag', ColorId = 10 WHERE CalendarDate = '2035-03-23 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Påskdagen', ColorId = 10 WHERE CalendarDate = '2035-03-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag påsk', ColorId = 10 WHERE CalendarDate = '2035-03-26 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Första maj', ColorId = 10 WHERE CalendarDate = '2035-05-01 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Kristi himmelsfärdsdag', ColorId = 10 WHERE CalendarDate = '2035-05-03 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Pingstdagen', ColorId = 10 WHERE CalendarDate = '2035-05-13 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Nationaldagen', ColorId = 10 WHERE CalendarDate = '2035-06-06 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Midsommardagaen', ColorId = 10 WHERE CalendarDate = '2035-06-23 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Alla helgons dag', ColorId = 10 WHERE CalendarDate = '2035-11-03 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Juldagen', ColorId = 10 WHERE CalendarDate = '2035-12-25 00:00:00.000'
GO
UPDATE Calendar SET CalendarHoliday = 1, CalendarHolidayName = 'Annandag jul', ColorId = 10 WHERE CalendarDate = '2035-12-26 00:00:00.000'
GO
--End 2035