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
 Business Days

Author  Topic 

bbeeharry
Starting Member

1 Post

Posted - 2007-09-24 : 09:02:32
I Have a date range and i want to calculate the number of days - the weekends(saturdays and sundays) so that only businessdays are obtained.

A simple table's example:

Name, surname, datebeg, dateend

How can can it be done with sql?
BB

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-24 : 09:26:04
With or without holidays?



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

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-09-24 : 12:16:13
Take a look at this thread:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80158

CODO ERGO SUM
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2007-09-24 : 12:52:16
Or look at this

http://weblogs.sqlteam.com/brettk/archive/2004/12/20/3751.aspx



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -