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)

Exploring the DATE Functions in SQL

Learn more about using the DATEADD function in SQL...

Politics makes for bad databases - plus calculate British holidays

In this piece, learn about changes in UK holidays and get a script to calculate them.

July 4 2019

Get the Datetime

Function for Getting Interval Dates by days,months,years.

Function for Getting Interval Dates by days,months,years for particular week number, for particular month, for particular date between 1 to 31. etc...
All in One Date Interval Related Function.

First day and last day of a week

This scripts calculates the first day and the last day of a given week