USE [RayFlow]
GO 

/* 
The following 2015 holiday entries are for Australia (AU), Austria (AT), Belgium (BE), Canada (CA), France (FR), Germany (DE), India (IN), 
Ireland (IR), Luxemburg (LX), Netherlands (NL), Poland (PL), Switzerland (CH), United Kingdom (UK), & United States of America (USA), 
based off of information provided by http://www.officeholidays.com/countries/<country name>/ 

If a calender entry was initially ceated for a country that has two or more different holiday names for that date, the names have been seperated by the "/" character.  
Example = 'Vasant Panchami / Sir Chhotu Ram Jayanti'  
That countries regions that relate to each holiday name are found between the "()" characters and are also seperated by the "/" character.  
Example = --IN (Haryana, Odisha,Tripura, West Bengal only / Haryana only)  

If two or more countries share the same holiday name on a date that other countries have a different holiday name, then those countries are grouped between the "[]" characters. 
Example = 'Day after New Years Day' --[CA (Quebec only), UK (Scotland)], CH (Berchtolds Day)   

If a country has a different holiday name for a date, that name will be found between the "()" characters.  
Example = CH (Berchtolds Day) 
If that country's holiday does not pertain to the entire country, then the associated regions are found between "()" characters within the country's "()" characters.  
Example = CH (Berchtolds Day (Aargau, Bern, Fribourg, Glarus, Jura, Lucerne, Neuchâtel, Obwalden, Schaffhausen, Solothurn, Thurgau, Vaud, Zug, Zurich)) 
*/

/* 
NOTE 1:  The SLA calculation only takes holidays into effect once a package task has entered that holidays date, and does not perform post SLA calculation if a holiday which has already passed is entered into the Holidays table.   
*/

/* 
NOTE 2:  The Holidays table currently does not offer the possibility to differentiate between holidays based on region and location of the task within the workflow. 
*/


/*
Feel free to select the holidays that apply to your RayFlow system, and modify the queries if the initial holiday name is not the one that you require.  
*/




DECLARE @ProjectID uniqueidentifier

-- Set project ID here (SELECT * FROM Projects) 
SET @ProjectID = '<projectid>'

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-01'
           ,'0'
           ,'New Years Day'  --AT, AU, BE, CA, CH, DE, FR, IN (Arunachal pradesh, Manipur, Meghalaya, Miizoram, Nagaland, Sikkim, Tamil Nadu, Telangana, Public Sector only), 
			--IR, LX, NL, PL, UK, USA
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-02'
           ,'0'
           ,'Day after New Years Day' --[CA (Quebec only), UK (Scotland)], CH (Berchtolds Day (Aargau, Bern, Fribourg, Glarus, Jura, Lucerne, Neuchâtel, Obwalden, Schaffhausen, 
				--Solothurn, Thurgau, Vaud, Zug, Zurich)) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-03'
           ,'1'
           ,'Milad-un-Nabi' --IN  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-04'
           ,'1'
           ,'Milad-un-Nabi' --IN (Delhi, Tamil Nadu, Telangana) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-05'
           ,'0'
           ,'Guru Govind Singh Jayanti' --IN (Punjab only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-06'
           ,'0'
           ,'Epiphany' --AT, CH (Graubünden, Lucerne, Schwyz, Ticino, Uri), DE (Baden-Württemberg, Bavaria, Saxony-Anhalt), PL
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-12'
           ,'0'
           ,'Birthday of Swami Vivekananda' --IN (West Bengal only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-13'
           ,'0'
           ,'Bhogi' --IN (Andhra Pradesh only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-14'
           ,'0'
           ,'Pongal' --IN  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-15'
           ,'0'
           ,'Pongal' --IN (Assam, Karnataka, Tamil Nadu, Telangana) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-16'
           ,'0'
           ,'Thiruvalluvar Day' --IN (Tamil Nadu only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-17'
           ,'1'
           ,'Uzhavar Tirunal' --IN (Puducherry, Tamil Nadu only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-19'
           ,'0'
           ,'Martin Luther King Day' --USA  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-21'
           ,'0'
           ,'Sonam Lhochar' --IN (Sikkim only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-23'
           ,'0'
           ,'Netaji Subhas Chandra Bose Jayanti' --IN (Assam, Odisha, Tripura, West Bengal only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-24'
           ,'1'
           ,'Vasant Panchami / Sir Chhotu Ram Jayanti' --IN (Haryana, Odisha,Tripura, West Bengal only / Haryana only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-25'
           ,'1'
           ,'Statehood Day' --IN (Himachal Pradesh only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-26'
           ,'0'
           ,'Australia Day' --AU, IN (Republic Day) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-31'
           ,'1'
           ,'Me-dam-me-phi' --IN (Assam only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-01-31'
           ,'1'
           ,'Me-dam-me-phi' --IN (Assam only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-03'
           ,'0'
           ,'Guru Ravidas Birthday' --IN (Haryana, Himachal Pradesh, Punjab only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-09'
           ,'0'
           ,'Family Day' --CA (British Columbia only) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-14'
           ,'1'
           ,'Maharshi Dayanand Saraswati Jayanti' --IN (Haryana only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-16'
           ,'0'
           ,'Presidents Day' --USA, CA (Family Day (Alberta, Nova Scotia, Ontario, and Saskatchewan))   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-17'
           ,'0'
           ,'Maha Shivrati' --IN (Krishna Paksha) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-19'
           ,'0'
           ,'Chhatrapati Shivaji Maharaj Jayanti / Losar' --IN (Maharashtra (Mumbai) only / Sikkim only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-02-27'
           ,'0'
           ,'Public Holiday' --IN (Haryana only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-01'
           ,'1'
           ,'Republic Day'  --CH (Neuchâtel) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-02'
           ,'0'
           ,'Labour Day'  --AU (WA only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-05'
           ,'0'
           ,'Doljatra'  --IN (Holi Dahan. Assam, Odisha, Uttar Pradesh, West Bengal only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-06'
           ,'0'
           ,'Holi'  --IN 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-09'
           ,'0'
           ,'Adelaide Cup / Canberra Day / Labour Day'  --AU (SA only / ACT only / VIC, TAS only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-17'
           ,'0'
           ,'St Patricks Day'  --UK (Northern Ireland), IR 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-18'
           ,'0'
           ,'Public Holiday'  --IN (Goa)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-19'
           ,'0'
           ,'St Josephs Day'  --CH (Graubünden, Lucerne, Nidwalden, Schwyz, Solothurn, Ticino, Uri, Valais) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-21'
           ,'1'
           ,'Ugadi'  --IN (Telugu and Kannada New Year. Karnataka, Maharashtra, Andhra Pradesh, Telangana, Uttar Pradesh.)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-23'
           ,'0'
           ,'Shaheedi Diwas of Bhagat Singh, Rajguru & Sukhdev'  --IN (Haryana only)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-03-28'
           ,'1'
           ,'Ram Navami'  --IN   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-01'
           ,'0'
           ,'Odisha Day'  --IN (Odisha only)
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-02'
           ,'0'
           ,'Mahavir Jayanti'  --IN (Jainism)
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-03'
           ,'0'
           ,'Good Friday'  --AU, CA (except in Quebec), IN, NL, DE, UK
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-05'
           ,'1'
           ,'Easter Sunday'  --AT, AU, BE, CH, DE, FR, IR, LX, NL, PL, UK, IN (Babu Jagjivan Ram Birthday (Andhra Pradesh, Telangana only)) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-06'
           ,'0'
           ,'Easter Monday'  --AT, AU, BE, CA (Quebec Only.  Government Holiday in most regions), CH, DE, FR, IR, LX, NL, PL, UK
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-09'
           ,'0'
           ,'Näfelser Fahrt'  --CH (Glarus)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-13'
           ,'0'
           ,'Sechselauten'  --CH (Zurich - half a day) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-14'
           ,'0'
           ,'Dr Ambedkar Jayanti / Tamil New Year / Vaisakhi'  --IN ( / Tamil Nadu only / Haryana only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-15'
           ,'0'
           ,'Himachal Day / Bengali New Year / Vishu'  --IN (Himachal Pradesh only / Tripura, West Bengal only / Kerala only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-16'
           ,'0'
           ,'Emancipation Day'  --USA (Washington DC Only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-17'
           ,'0'
           ,'Public Holiday'  --IN (Uttar Pradesh) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-20'
           ,'0'
           ,'Parashurama Jayanti'  --IN (Haryana, Himachal Pradesh, Uttar Pradesh only) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-25'
           ,'1'
           ,'ANZAC Day'  --AU 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-04-27'
           ,'0'
           ,'King's Birthday'  --NL, AU (ANZAC Day (ACT, Public Sector, Western Australia only)) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-01'
           ,'0'
           ,'May Day'  --AT, BE, CH, FR, IN (Assam, Bihar, Goa, Jharkhand, Karnataka, Kerala, Manipur, Tamil Nadu, Tripura, West Bengal only), [LX, PL (Labour Day)], 
			--IN (Maharashtra Day (Maharashtra (Mumbai) only))  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-03'
           ,'1'
           ,'Constitution Day'  --PL, IN (Hazrat Alis Birthday (Uttar Pradesh only))  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-04'
           ,'0'
           ,'Early May Bank Holiday'  --UK, AU (Labour Day (NT only)), IR (May Bank Holiday), IN (Buddha Purnima)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-05'
           ,'0'
           ,'Liberation Day'  --NL 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-08'
           ,'0'
           ,'V-E Day'  --FR 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-09'
           ,'1'
           ,'Birthday of Rabindra Nath Tagore / Public Holiday'  --IN (Tripura, West Bengal / Uttar Pradesh)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-14'
           ,'0'
           ,'Ascension Day'  --AT, BE, CH, DE, FR, LX, NL
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-18'
           ,'0'
           ,'Victoria Day / National Patriots Day'  --CA (except in New Brunswick, Nova Scotia and Prince Edward Island / Quebec only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-20'
           ,'0'
           ,'Maharana Pratap Jayanti'  --IN (Haryana, Himachal Pradesh, Rajasthan)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-24'
           ,'1'
           ,'Pentecost Sunday'  --PL
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-05-25'
           ,'0'
           ,'Whitmonday'  --AT, BE, CH (except Valais), DE, FR, LX, NL, UK (Spring Bank Holiday), USA (Memorial Day)   
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-01'
           ,'0'
           ,'Corpus Christi'  --IR, AU (Western Australia Day (WA only))  
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-02'
           ,'0'
           ,'Sant Guru Kabir Jayanti'  --IN (Gazetted holiday in Haryana, Himachal Pradesh, Punjab)  
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-04'
           ,'0'
           ,'Corpus Christi'  --AT, CH (Aargau, Appenzell Innerrhoden, Fribourg, Jura, Lucerne, Nidwalden, Obwalden, Ticino, Uri, Valais, Zug), 
			--DE (Baden-Württemberg, Bavaria, Hesse, North Rhine-Westphalia, Rhineland-Palatinate, Saarland), PL 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-08'
           ,'0'
           ,'Queens Birthday'  --AU (except WA)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-15'
           ,'0'
           ,'Raja Sankranti'  --IN (Odisha only)   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-16'
           ,'0'
           ,'Arjun Dev Martyrdom day'  --IN (Punjab only)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-19'
           ,'0'
           ,'Foundation of Sri Anandpur Sahib'  --IN (Punjab only)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-22'
           ,'0'
           ,'Discovery Day'  --CA (Newfoundland and Labrador only)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-23'
           ,'0'
           ,'National Day'  --LX, CH (Fete d'Independance (Jura))  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-24'
           ,'0'
           ,'The National Holiday of Quebec'  --CA (Quebec only)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-06-29'
           ,'0'
           ,'Saint Peter and Saint Paul'  --CH (Graubünden, Ticino)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-01'
           ,'0'
           ,'Canada Day'  --CA   
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-03'
           ,'0'
           ,'Independence Day'  --USA (as July 4th is a Saturday)   
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-10'
           ,'1'
           ,'Jumat-ul-Wida'  --IN  
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-11'
           ,'1'
           ,'Celebration of the Golden Spurs'  --BE  
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-13'
           ,'0'
           ,'Battle of the Boyne'  --UK (Northern Ireland) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-14'
           ,'0'
           ,'Bastille Day'  --FR
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-18'
           ,'0'
           ,'Idul Fitr'  --IN (All states except Goa, Jharkhand and Uttar Pradesh) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-07-21'
           ,'0'
           ,'Independence Day'  --BE
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-01'
           ,'1'
           ,'National Day'  --CH 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-03'
           ,'0'
           ,'August Bank Holiday'  --DE (Saarland), IR, AU (Picnic Day (NT only)), CA (Civic Day)   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-12'
           ,'0'
           ,'Ekka Peoples Day'  --AU (Brisbane only)   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-15'
           ,'1'
           ,'Assumption Day'  --AT, BE, CH (Aargau, Appenzell Innerrhoden, Fribourg, Jura, Lucerne, Nidwalden, Obwalden, Schwyz, Solothurn, St. Gallen, Ticino, Uri, Valais, Zug), 
			--FR, LX, PL, UK (Scotland), IN (Independence Day) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-17'
           ,'0'
           ,'Teej'  --IN (Haryana only), CA (Discovery Day (Yukon only))  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-18'
           ,'0'
           ,'Parsi New Year'  --IN (Jamshed Navroz. Mumbai Only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-27'
           ,'0'
           ,'First Onam'  --IN (Kerala only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-28'
           ,'0'
           ,'Thiruvonam'  --IN (Kerala only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-29'
           ,'1'
           ,'Raksha Bandhan'  --IN (Gujarat, Rajasthan, Uttarakhand, Uttar Pradesh only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-08-31'
           ,'0'
           ,'August Bank Holiday'  --UK (except Scotland) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-05'
           ,'1'
           ,'Janmashtami'  --IN 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-07'
           ,'0'
           ,'Labor Day'  --USA, CA (Labour Day) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-10'
           ,'0'
           ,'Jeune genevois'  --CH (Geneva) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-15'
           ,'1'
           ,'Tithi of Shrimanta Shankar Dev'  --IN (Assam only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-17'
           ,'0'
           ,'Ganesh Chaturthi'  --IN (Varasiddhi Vinayaka Vrata) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-18'
           ,'0'
           ,'Nuakhai'  --IN (Odisha only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-20'
           ,'1'
           ,'Swiss Federal Fast'  --CH (except Geneva) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-21'
           ,'0'
           ,'Knabenschiessen / Bettagsmontag'  --CH (Zurich - half a day / Bern, Neuchâtel, Vaud), IN (Sree Narayana Guru Samadhi (Kerala only))  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-23'
           ,'0'
           ,'Haryanas Heroes Martyrdom Day'  --IN (Haryana only)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-24'
           ,'0'
           ,'Saint Rupert'  --AT (Salzburg), IN (Idul Juha (Bakrid))  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-25'
           ,'0'
           ,'Saint Nicholas of Flüe'  --CH (Obwalden), IN (Idul Juha (Bakrid. Assam, Delhi, Himachal Pradesh, Haryana, Maharashtra)) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-27'
           ,'1'
           ,'French Community Day'  --BE
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-09-28'
           ,'0'
           ,'Family & Coomunity Day / Queens Birthday'  --AU (ACT only / WA only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-02'
           ,'0'
           ,'Mahatma Gandhi Birthday'  --IN (Gandhi Jayanti) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-03'
           ,'1'
           ,'German Unity Day'  --DE
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-05'
           ,'1'
           ,'Labour Day'  --AU (NSW, ACT, QLD, SA) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-06'
           ,'0'
           ,'October Holiday (Halloween)'  --IR
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-12'
           ,'0'
           ,'Mahalaya'  --IN (Karnataka, Odisha, Tripura, West Bengal only), USA (Columbus Day), CA (Thanksgiving (except in New Brunswick, 
			--Newfoundland, Nova Scotia and Prince Edward Island))   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-13'
           ,'0'
           ,'Muharram / Maharaja Agrasen Jayanati'  --IN (Observed mainly by the Shia Muslim community / Haryana only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-20'
           ,'0'
           ,'Saptami of Durgapuja'  --IN (Assam, Odisha, Sikkim, Tripura, West Bengal) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-21'
           ,'0'
           ,'Ayudha Puja'  --IN (Assam, Karnataka, Sikkim, Tamil Nadu, West Bengal) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-22'
           ,'0'
           ,'Dussehra / Mahanavami'  --IN (Vijaya Dashami / Kerala, Odisha only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-23'
           ,'0'
           ,'Vijaya Dashami / Muharram'  --IN (Assam, Kerala, Odisha, Sikkim. Dussehra / Tamil Nadu only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-24'
           ,'1'
           ,'Muharram (10th Day) / Durga Puja'  --IN ( / Mahastami. Odisha, Sikkim only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-26'
           ,'0'
           ,'National Day'  --AT, IN (Lakshmi Puja (West Bengal only)) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-27'
           ,'0'
           ,'Lakshmi Puja'  --IN (Odisha, Tripura only) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-10-31'
           ,'1'
           ,'Day of Reformation'  --DE (Brandenburg, Mecklenburg-Vorpommern, Saxony,Saxony-Anhalt, Thuringia) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-01'
           ,'1'
           ,'All Saints Day'  --AT, BE, DE (Baden-Württemberg, Bavaria, North Rhine-Westphalia, Rhineland-Palatinate, Saarland), FR, LX, PL, 
			--IN (Kannada Rajyothsava (Bangalore Only)), IN (Haryana Day (Haryana only))                
	,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-03'
           ,'0'
           ,'Melbourne Cup Day'  --AU (VIC only)   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-10'
           ,'0'
           ,'Deewali / Kali Puja'  --IN (Deepawali / Odisha West Bengal only)   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-11'
           ,'0'
           ,'Armistice Day'  --BE, FR, PL (Independence Day), IN (Deewali (Deepawali. Delhi, Haryana, Himachal Pradesh, Odisha, Punjab, Telangana)), 
			--IN (Diwali (Laxmi Puja. Maharashtra)), USA (Veterans Day), CA (Remembrance Day(except Manitoba, Ontario, 
			--Quebec, and Nova Scotia))      
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-12'
           ,'0'
           ,'Diwali / Vishavkarma day'  --IN (Deepawali. Maharashtra / Haryana only)    
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-15'
           ,'1'
           ,'German Community Day'  --BE, AT (Saint Leopold (Vienna))   
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-18'
           ,'0'
           ,'Repentance Day'  --DE (Saxony)  
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-25'
           ,'0'
           ,'Rasa Purnima / Guru Nanak Birthday'  --IN (Odisha only / )   
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-26'
           ,'0'
           ,'Thanksgiving'  --USA 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-11-30'
           ,'0'
           ,'St Andrews Day'  --UK (Scotland) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-06'
           ,'1'
           ,'Dr Ambedkar death anniversary'  --IN (Uttar Pradesh) 
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-08'
           ,'0'
           ,'Immaculate Conception Day'  --AT, CH
           ,@ProjectID) 

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-24'
           ,'0'
           ,'Christmas Eve'  --DE (half a day), IN (Milad-un-Nabi) 
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-25'
           ,'0'
           ,'Christmas Day'  --AT, AU, BE, CA, CH, DE, FR, IN, LX, NL, PL, UK, USA
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-26'
           ,'1'
           ,'Boxing Day'  --AU, CA, DE, UK, [AT, CH (Except Geneva, Jura, Neuchâtel, Valais and Vaud), IR, LX, NL, PL (St Stephens Day)], 
			--IN (Shaheed Udham Singh's Birthday (Haryana, Punjab only))   
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-28'
           ,'0'
           ,'Boxing Day (in lieu)'  --AU, UK, IR (St Stephens Day (in lieu))
           ,@ProjectID)

INSERT INTO [Holidays]
           ([HolidayDate]
           ,[IsWeekEnd]
           ,[HolidayName]
           ,[ProjectID])
     VALUES
           ('2015-12-31'
           ,'0'
           ,'New Years Eve'  --DE (half a day), CH (Restoration Day (Geneva))
           ,@ProjectID)