I am trying to get business days using datedif function.
I get the difference in days, but do not know how to
account for Saturday and Sunday. Can you help?

I presume you want to ask

WHERE day is not Saturday or Sunday?

The best way IMHO to handle this is to have a calendar table.

CREATE TABLE CalendarTable
(
DateID int IDENTITY(1,1) Primary Key,
DateActual small datetime,
DayOfMonth tinyint,
MonthNum tinyint,
YearNum tinyint,
IsHoliday bit,
IsWeekend bit
etc
)

You can therefore count the # of days between two dates where IsWeekend <> 0
and IsHoliday <> 0



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Barbara" <anonymous (AT) discussions (DOT) microsoft.com> wrote

In message <OBDeygF4DHA.2528 (AT) tk2msftngp13 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
public holidays and using the advanced search options filter on your
country TLD. Using this I can find the UK government site that tells me
what the upcoming public holidays are -

http://www.dti.gov.uk/er/bankhol.htm

I find it invaluable it this sort of calculation and also setting
schedules for alerts and similar.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org