Hi Dave!
I am a newbie when it comes to SQL, sorry for inconvienience, your answer worked perfectly, but I meant to say minutes
With your above answer, can you change that to return MINUTES instead of hours and exclude holidays that are in TableA . Lets say TableA has
HolidayDate
2004-08-09 00:00:00.000
2004-09-24 00:00:00.000
2004-12-16 00:00:00.000
2004-12-26 00:00:00.000
2004-12-25 00:00:00.000