I know how to count business days, but I need to count business hours...
Basically, "if EVENT happens at 4:30PM Friday...then reaction happens at 4:30PM Tuesday" by counting 48 business day hours. I don't mean 9-5, I basically mean two business days but exactly from 3:33PM Thursday to 3:33PM Monday.
I have code that counts business days here.
DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = '2008/10/01' SET @EndDate = '2008/10/31' SELECT (DATEDIFF(dd, @StartDate, @EndDate) + 1) -(DATEDIFF(wk, @StartDate, @EndDate) * 2) -(CASE WHEN DATENAME(dw, @StartDate) = 'Sunday' THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, @EndDate) = 'Saturday' THEN 1 ELSE 0 END)