hi
hope this helps
use weekday function !!
https://blog.sqlauthority.com/2012/11/25/sql-server-find-weekend-and-weekdays-from-datetime-in-sql-server-2012/
check if weekday .. if it is SUM other wise ignore
sum ( case when weekday 1 else 0 end )
hi
hope this helps
use weekday function !!
https://blog.sqlauthority.com/2012/11/25/sql-server-find-weekend-and-weekdays-from-datetime-in-sql-server-2012/
check if weekday .. if it is SUM other wise ignore
sum ( case when weekday 1 else 0 end )