This Blog deals with a very simple requirement of customizing week start as per business requirement.
Like in attached example we had a Business need to have week numbers to start from Wednesday.
This can be done by modifying FirstWeekDay in SET statement.
SET FirstWeekDay=2; // this will set week to start from Wednesday.
You can customize your week with any week start day.