How to get business Hours | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to get business Hours

hello does anybody have script to calculate
the business hours between the 2 given dates. The working hours is 8 hours each day and want to remove only the weekends from the calculation for i am not tracking public holidays and so public holidays also considered as business days. Thanks and Regards

Start with this Madhivanan Failing to plan is Planning to fail
Hello Madhivanan
that is nice way to start to calculate the business days.
But what i really looking for is Business Hours. while i was searching i found this excellent article and i am putting it here so that people like me who requires this functionality may use this link. Thanks Madhivanan for the reply and as usual this site is excellent when comes to really wonderful and useful
scripts and solutions given by experts like you more quicker then any other sites. Thanks and regards
Thanks for the kind words [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail