Answer Posted / lekurwale

U can caculate By creating the following function in SQL
server :

CREATE FUNCTION dbo.GetWorkingDays
( @StartDate datetime,
@EndDate datetime )
RETURNS INT
AS
BEGIN
DECLARE @WorkDays int, @FirstPart int
DECLARE @FirstNum int, @TotalDays int
DECLARE @LastNum int, @LastPart int
IF (DATEDIFF(day, @StartDate, @EndDate) < 2)
BEGIN
RETURN ( 0 )
END
SELECT
@TotalDays = DATEDIFF(day, @StartDate, @EndDate) - 1,
@FirstPart = CASE DATENAME(weekday, @StartDate)
WHEN 'Sunday' THEN 6
WHEN 'Monday' THEN 5
WHEN 'Tuesday' THEN 4
WHEN 'Wednesday' THEN 3
WHEN 'Thursday' THEN 2
WHEN 'Friday' THEN 1
WHEN 'Saturday' THEN 0
END,
@FirstNum = CASE DATENAME(weekday, @StartDate)
WHEN 'Sunday' THEN 5
WHEN 'Monday' THEN 4
WHEN 'Tuesday' THEN 3
WHEN 'Wednesday' THEN 2
WHEN 'Thursday' THEN 1
WHEN 'Friday' THEN 0
WHEN 'Saturday' THEN 0
END
IF (@TotalDays < @FirstPart)
BEGIN
SELECT @WorkDays = @TotalDays
END
ELSE
BEGIN
SELECT @WorkDays = (@TotalDays - @FirstPart) / 7
SELECT @LastPart = (@TotalDays - @FirstPart) % 7
SELECT @LastNum = CASE
WHEN (@LastPart < 7) AND (@LastPart > 0) THEN
@LastPart - 1
ELSE 0
END
SELECT @WorkDays = @WorkDays * 5 + @FirstNum +
@LastNum
END
RETURN ( @WorkDays )
END

How can we optimize a sql query?

1050

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3050

---

What are synonyms in sql?

972

---

what is the bond code in materialized view?

3002

---

What is data type in database?

992

---

how to add a new column to an existing table in mysql? : Sql dba

1073

---

What is scalar and vector?

1002

---

explain advantages of innodb over myisam. : Sql dba

1128

---

How many primary keys can a table have?

1009

---

What is procedure in pl sql?

1046

---

What is the difference between mdf and ndf files?

1119

---

What do you mean by “trigger” in sql?

1079

---

What is difference between primary and secondary key?

1027

---

What are all the ddl commands?

1183

---

What is #table in sql?

1099

---