Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Retrieve Data for working days using date function

Author  Topic 

roxcy
Yak Posting Veteran

58 Posts

Posted - 2007-08-22 : 08:22:37
Hi
I would like to return data for working days only. This will need to exclude holidays.For eg In the Month of August we have 31 Days and every 1st day of 1st week is holiday.So my output should retrieve me 31-4=27 .
Any ideas?

Thanks...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-22 : 08:55:53
Have a look at this article
http://www.sqlservercentral.com/columnists/plarsson/howmanymoremondaysuntiliretire.asp



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

roxcy
Yak Posting Veteran

58 Posts

Posted - 2007-08-22 : 09:34:34
Thanks....
Go to Top of Page
   

- Advertisement -