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,623 reads


Altering a Computed Column in a Temporal Table in Azure SQL


System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Calgary Data User Group with Deborah Melkin and Andy Yun


Next week on Wednesday is the Calgary Data User Group’s second event for 2021,...

Read the latest Blogs


SQL2016 to Access2016 Linked server issue

By richardmgreen1

Hi all   We've got an issue with a linked server to an Access...

Future of SQL Server

By sean redmond

I am becoming a little disconcerted by the lack of news about the next...

Changing Data Drive Allocation Unit Size on Existing Installation

By garyb1

I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers