I have a table to record sickness i.e. DateStart and DateEnd.
I need to report total sickness recorded for an employee for each of the weekday in the year.
Mon Tue Wed Thu Fri Sat Sun
2 1 3 0 4 0 5
How can I generate SQL for the above?
I need to report total sickness recorded for an employee for each of the weekday in the year.
Mon Tue Wed Thu Fri Sat Sun
2 1 3 0 4 0 5
How can I generate SQL for the above?