SQL Window Functions Series: LAG() and LEAD()

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

Combine DATE and TIME to DATETIME2 in SQL Server

The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".

How to Find the Start and End Dates for the Current Week (and more)

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

Add working days but avoid holidays

A function to add or subtract working days taking into account weekends and using a table of non-working days.

Get date for iteration of a DOW

Good for Thanksgiving, Daylight Savings changes, Others?

Ending 2017

Compute Holiday Day of the Month for any Year

This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.