Technical Article

WorkingDaysDiff complementary UDF for DATEDIFF

We frequently have to work out a date based on a number of working days before or after a specified date, excluding Saturdays and Sundays.Attached is the script to create the function.  I call another function called fn_Midnight which was designed to help whe programmers get a date with no time portion without having to […]

You rated this post out of 5. Change rating

2002-10-22

471 reads

Blogs

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

Gentlest of Reminders, Don't Stop Learning

By Grant Fritchey

Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers