Select Distinct Logo Clear Background

How to use a CTE? Should you use this “With” your SQL code?

What is a SQL CTE

Introduction CTEs in SQL are a way to simplify code by creating a temporary dataset, giving it a name, then referencing that dataset later in your query You can use Common Table Expressions (CTEs) as temporary named result sets within a SELECT, INSERT, UPDATE, or DELETE statement. You may also have heard of them described […]

PIVOT function in SQL

How to use the PIVOT function in SQL

Introduction to the PIVOT function in SQL The PIVOT function in SQL can be used to create a dataset with aggregated rows from a list of data This post shows you how to transform a table of data like this Into a summary table of data with a column representing each month If you are […]

Drag and Drop Field Names in SQL (SSMS)

Drag and Drop field names in SSMS cover

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 […]

Top 5 SQL Time savers of 2022

Top 5 SQL Timesavers videos for 2022 title screen

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 […]