SQL Server Performance Forum – Threads Archive
How to get business Hours
hello does anybody have script to calculatethe 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
http://weblogs.sqlteam.com/brettk/archive/2005/05/12/5139.aspx 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 http://www.codefez.com/Home/tabid/36/ctl/ArticleView/mid/364/articleId/192/Default.aspx 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
]]>