Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

I think the query below will do it. I used an inline tally table to cover multiple days. I only used a max of 10 days but it's easy enough to extend the tally table to 100 or even 1000 rows. I used CROSS APPLYs to do the preliminary calcs to make the main SELECT code "less cluttered".

--"Holidays" structure, but no data; naturally use your real holiday table or load dates to the one below.
--!!!!!Make sure you don't run the next line if your real holidays table is named "dbo.Holidays"!!!!IF OBJECT_ID('dbo.Holidays') IS NOT NULL DROP TABLE dbo.Holidays;
CREATE TABLE dbo.Holidays ( date date PRIMARY KEY );

My effort, calculating hours generating a cte that has all the possible work days and hours in it. I think the queries at the end could probably take some optimisation and I made an issue with having the end times as 23:59 which is why I am converting between minutes and hours and adding 1s <sigh>

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.

This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.