SQL工作日计算(不含规定假日).doc

SQL工作日计算（不含规定假日） / * Because of a strange need in the job, you need to calculate how ineiny working days in two days in the SQL language? The setting is five working days a week, from Monday to Friday Description: The working days of the first week: the DATEPART (dw, @begdt) -datepart (dw, @begdt), minimum of 0 days The number of days at the end of the week: DATEPART (dw, @enddt), up to five clays Method: If the two dates are in the same week, count the work days of the first week〃? Otherwise, you calculate it by the following formula The total number of days between the two days 一 the number of days in the first week - the number of days in the final week) / 7 * 5 + the first week of working days + the working days of the last week Calculate and return the working hours of the two days (weekday * 8) from Monday to Friday -- you must SET DATEFIRST 1 Alter FUNCTION dbo. CalcWorkHours (@bdate DATETIME, @edate DATETIME) RETURNS an INTEGER / * Because of a strange need in the job, you need to calculate how many working days in two days in the SQL language? The setting is five working days a week, from Monday to Friday Description: The working days of the first week: the DATEPART (dw, @begdt) -datepart (dw, @begdt), minimum of 0 days The number of days at the end of the week: DATEPART (dw, @enddt), up to five days Method: If the two dates are in the same week, count the work days of the first week〃? Otherwise, you calculate it by the following formula The total number of days between the two days - the number of days in the first week - the number of days in the final week) / 7 * 5 + the first week of working days + the working days of the last week Computational methods complement: First, calculate the working day except for the weekend -minus Monday to Friday Plus weekend work (if the end of the day is Sunday) minus one day Calculate the head not the tail * / Calculate and return the working hours of the two days (weekday * 8) from Monday to Friday -- you must SET DAT