从指定日期计算 30 个工作日的 TSQL 函数 (SQL Server 2005) [英] TSQL Function to calculate 30 WORKING days Date from a Specified Date (SQL Server 2005)

问题描述

从指定日期计算 30 个工作日的 TSQL 函数 (SQL Server 2005)?

TSQL Function to calculate 30 WORKING days Date from a Specified Date (SQL Server 2005)?

输入参数是日期和工作日数.
输出将是计算日期.

Input parameters would be Date and Number of Working Days.
Output would be the Calculated Date.

这将排除周六、周日、节假日和观察到的节假日.
即如果假期是周末，但在假期后的星期五或星期一观察.

This would exclude Saturday, Sunday, Holidays and Day Holiday was observered.
i.e. If the Holiday falls on a weekend but it is observed on the Friday or Monday after the holiday.

对于假期，我们有一张包含假期和日期的表格.

For the Holidays we have a table with holiday and day it is being observed date.

推荐答案

看看这篇文章 Celko - 一般来说，您需要预先计算"一个日历表，以考虑所有可能的变故，如复活节、银行假期等.

Have a look at this article by Celko - in general you need to "pre-calculate" a calendar table to take in account all possible vagaries like Easter, bank holidays etc.

这篇关于从指定日期计算 30 个工作日的 TSQL 函数 (SQL Server 2005)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！