Experts - I need to find week numbers from a specific month number and a start day.
In SQL Table, I have FiscalDate as smalldatetime column which will have dates from 2017 start to 2030 end.
Now, I need an SP which should have a parameter of month number and starting day.
Exec SP_UpdateFiscalWeek(7, 'Sunday')
The above sp should consider July as the first month of the year & calculate the fiscal week's accordingly for the whole datasets & update Sunday as the starting day for week's calculation.