Basic T-SQL

In this article I’m going to outline the basic T-SQL commands for those new to the language, and as a reference for others. Continue reading “Basic T-SQL”

Advertisements

Lead & Lag Functions

A reporting requirement I’ve seen come up several times is the ability to compare a field value from one record with the value in the same field but a previous record, or else some other requirement to get the preceding or proceeding record. Continue reading “Lead & Lag Functions”