https://developerpublish.com/how-to-get-day-of-a-week-in-sql-server/
How to get day of a week in SQL Server ?