I am using the below sql query to calculate working hours. The problem which i am facing is that query is taking lot of time to calculate the working hours. Please help to reduce the execution time of this query or if there is any other way to calculate working hours
The following query take 63.499 sec
please help me how do i change the query to reduce the sec.