declare @StartDate date = cast(year(getdate()) - 1 as varchar(4)) + '0101', @EndDate date = cast(year(getdate()) as varchar(4)) + '1231'; select * from dbo.GetCalendar( @StartDate, @EndDate ) order by [Date]