Eliminate
holidays (weekends, specific day) using T-SQL
One of the tasks that may we have to deal with is
how to eliminate weekends and holidays from a period using SQL server, e.g.
if you want to calculate number of business days for specific company you may
need to eliminate Saturday and Sunday or Friday.