• Refer below link. I think this post has exactly what you are looking for.

    http://www.itdeveloperzone.com/2015/10/generating-week-dates-for-year-in-sql.html