In this post we are going to take a look at Left Joins, what they are and how they work.

A CTE or Common Table Expression specifies a tempoary named result set for the current session, a …

Something new happened this week, well not new in the sense like buying a new car but new to me, I …

In this post, I want to take a look at datediff, how it works and how I use it as part of my job.

When I first starting learning T-SQL things like DATEADD took a really long time for my brain to …