THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » SQL Server » Calendar   (RSS)
  • Generate date dimension that support working days calculation

    I just wrote a T-SQL query based on CTE that generates support information to calculate working days in a period. Simply look at the WorkingDaySequential measure, which difference between two dates is the number of elapsed working days. In the real world: The Holidays CTE could be replaced by a real table with user-inserted data. The ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 27, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement