select * from dbo.GetHolidays(16)

ItemID Holiday_Title Holiday_Date

1 Easter Sunday 2016-04-10

2 Thanksgiving 2016-11-24

3 Memorial Day 2016-05-30

4 Labor Day 2016-09-05

select * from dbo.GetHolidays(2016)

ItemIDHoliday_TitleHoliday_Date

1 Easter Sunday2016-03-27

2 Thanksgiving2016-11-24

3 Memorial Day2016-05-30

4 Labor Day 2016-09-05