Luis Cazares

Calculating Working Hours

Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.

4.67 (3)

2015-10-22 (first published: )

3,616 reads

Blogs

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Daily Coping 10 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Creating a Dimension with no Primary Key

By daithiboy

Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and...

Code signing a dll with certificate for use in SQL Server 2016

By fafful

I have a dll that will perform some webservice calls function. in order to...

Find whether a clustered index is actually unique

By DamianC

Hi   I have a table that has a clustered index on it The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers