1 of 1 people found this helpful
You need to join the production table to the holidays table with a pair of inequality joins:
begin date <= holiday date
end date >= holiday date
Now you will have one record for each day from begin to end. You can count just the "B" business days.
(Edited: I had the inequalities pointing the wrong way the first time. Sorry about that.)