I required a table of US holidays so adapted ChrisM's solution (above) as follows to list 40 years of US holidays.....


DECLARE @start_date date = 'Jan...