Go

CAN NE ONE SPECIFY THE USE OF GO IN SCRIPTS ?Check SQL Server books online.|||Collect $200.00

Global setting for business (5 day) versus calendar week

Is there a global setting to specify a business (5 day) versus a calendar (7
day) w for date calculations?> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?|||> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?
Oops - finger slippage. There is no setting, global or otherwise.|||Hi Ledd,
In relation to what though?
You could just check to see if the wday isn't a Saturday or Sunday by
using DATENAME( )
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Ledd" <ledd@.discussions.microsoft.com> wrote in message
news:C1885745-46EF-4214-9190-26D8DF72F8DE@.microsoft.com...
> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?|||Thanks. Makes sense.
"Tony Rogerson" wrote:

> Hi Ledd,
> In relation to what though?
> You could just check to see if the wday isn't a Saturday or Sunday by
> using DATENAME( )
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "Ledd" <ledd@.discussions.microsoft.com> wrote in message
> news:C1885745-46EF-4214-9190-26D8DF72F8DE@.microsoft.com...
>
>|||Create your own Calendar table to identify which days are working days.
Shouldn't be difficult to do calcs against that.
David Portas
SQL Server MVP
--|||How about a calendar table?
http://www.aspfaq.com/2519
"Ledd" <ledd@.discussions.microsoft.com> wrote in message
news:C1885745-46EF-4214-9190-26D8DF72F8DE@.microsoft.com...
> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?