I need your help with the following SQL query which worked fine during 2016 but not working now in 2017. So if you can take a look and let me know what I need to change to make it bring the 2017 results back I would appreciate it. If I comment out the part after [and] below it brings results but much more than I need
select LABEL AS 'Holiday', DATENAME(DW,HOLIDAYDATE) AS 'Day of the Week', CONVERT(VARCHAR(12), HOLIDAYDATE, 107) AS [Date] from HOLIDAYS where
year(HOLIDAYDATE) = YEAR(getdate()) and LOCATIONCODE = 'US'
Here's an abbreviated table below: