how can i create working days

Question

Hi friends please give me an idea on how to design working day details. In my task I want to create table for working days to school. this days except with general holidays and sunday as a holiday. i searched for this in google but i didnt get what i want. please help me and let me know any articles related with this title. thanks in advance

Akkiraju Ivaturi · Answer

You can use the following T-SQL scrip to calculate the number of business days between two dates. Business days usually are defined as non-weekend days. Popular responses include loops or temporary tables. But here is a single-expression approach that does the job. DECLARE @DateOld datetime @DateNew datetimeSET @DateOld = '10-Sep-2005'SET @DateNew = GETDATE() SET DATEFIRST 1 SELECT DATEDIFF (day @DateOld @DateNew) - (2 * DATEDIFF(week @DateOld @DateNew)) - CASE WHEN DATEPART(weekday @DateOld + @@DATEFIRST) = 1 THEN 1 ELSE 0 END - CASE WHEN DATEPART(weekday @DateNew + @@DATEFIRST) = 1 THEN 1 ELSE 0 END

Javeed M Shaikh · Answer

you can do this yourself and that way will have more control on which days you want to define working days. DateTime dt = new Datetime(today); if (dt.DayOfWeek == DayOfWeek.Thursday Or dt.DayOfWeek == DayOfWeek.Monday ......) { // it is working day } else { // it is a holiday } also in SQL Server select datename(dwgetdate()) --Friday select datepart(dwgetdate()) --6