INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('New Year''s Day','New Year''s Day',2,1,1,0)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Thanksgiving','Thanksgiving',3,4,5,11)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Independence Day','Independence Day',2,7,4,0)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Memorial Day','Holiday for the rememberance of those lost in wars.',4,6,2,5)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Labor Day','Holiday for the celebration of the workforce',3,1,2,9)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('MLK Birthday','Martin Luthor King Jr''s Birthday',3,3,2,1)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Washington''s Birthday','George Washington''s Birthday',3,3,2,2)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Columbus Day','Columbus Day',3,2,2,10)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Veteran''s Day','The anniversary of the end of World War I',2,11,11,0)

INSERT INTO dbo.NorthernRoad_Holidays (holidayName, holidayDescription, holidayCalculationTypeId, primaryOrdinal, secondaryOrdinal, tertiaryOrdinal)
VALUES ('Christmas Day','Christian celebration of the birth of Christ.',2,12,25,0)