I need an SQL query that I can pass a month to, it will return 3 values.
1. The week numbers of the weeks contained in that month
2. The date of Monday in each of those weeks (or the first day of that week if the month starts midweek.
3. The date of Friday in each of those weeks (or the last day of that week if the month ends midweek.
Thanks in advance