Thursday, June 7, 2012

Eliminate holidays (weekends, specific day) using T-SQL


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.

Card