LEAD and LAG Functions in SQL

A Guide to Lead and Lag Functions in SQL Introduction: An Overview of Lead & Lag Functions and Their Benefits in SQL Lead and Lag in SQL are essential functions for data analysis. These window functions allow users to compare and analyse data points between rows in a specified window. By using Lead and Lag […]

Running Totals in SQL Server

This blog post explains how to calculate running totals in SQL Server, why you would use them and provides a breakdown of the syntax What is a running total? A running total is a cumulative sum that takes all the values of a sequence and adds them together. It is also called a cumulative sum […]

Remove Carriage Returns in SQL Server SSMS

How to Remove Carriage Returns in SQL Server Management Studio? It is a fairly common task, a lot of people manually select and remove carriage returns and new lines, which can take time and is error prone But you can use find and replace functionality built into SSMS to make the task more efficient This step […]

How to show line numbers in SQL Server Management Studio

Using Line Numbers in SQL (SSMS) Showing line numbers in SQL Server Management Studio is a simple tip that can really help users to quickly debug and find their away around  large SQL scripts Why use line numbers in SQL Server? The primary benefits from enabling line numbers in SQL Server Management Studio are Finding […]

How to Connect Excel to SQL Server

Connecting Excel to SQL Server is important because it allows you to have access to up-to-date information. You can connect many spreadsheets to a single trusted data source in SQL Server. Then you can use Excel to refresh the data to be kept in sync. Excel has powerful but simple features that can help you […]

Drag and Drop Field Names in SQL (SSMS)

Drag and drop is a common and convenient way to move data and objects in SQL Server Management Studio (SSMS). With the object explorer, you can easily drag field names from a table.  Then drop them into a query window to quickly create a SELECT statement. How to drag and drop field names in SQL […]

SQL Timesaver – Add comma separators

This one-minute SQL timesaver showcases a free online comma separator tool, designed to simplify the process of adding comma separators to your SQL code. Delim.co is a Free Comma Separating Tool that separates one or more characters and text strings using delimiters such as commas (,), semicolon (;), quotes (\”, ‘), braces ({}), pipes (|), […]

Top 5 SQL Time savers of 2022

Here are our top 5 SQL Time saver videos on YouTube for 2022 based on the most watched Number 5 How to quickly add comma separators in SQL First published on 13th December 2022 This video demonstrates a free tool to add commas to a list of field values. The video shows this being used […]