thelabwiz (4/15/2008)
Looking at the database structure showed that every step of the process was date/time stamped, so the total time for any request could be determined. I built a prototype Excel sheet that used VBA to extract the pertinent data and compute the NBD time.
I guess I don't understand that... sure, that's a decent solution... but why do you think that such a calculation is not possible in SQL Server? It's just data.
--Jeff Moden
Change is inevitable... Change for the better is not.