[SQL] To find the next work day

Let's say I have stored a bunch of holidays in my database.

What I need to do is find out which is next work day excluding Saturdays and the public holidays defined in the database.

eg.

Let's say today is the Friday the 15th Feb and the 17th and the 18th are public holidays as defined in the database as datetime. So now when I press a button that says next work day, it should return 19th Feb.

Which is the most efficient way to to get it?

Continue reading...