TSQL Basics: SQL Server Join Types Webinar
Join us May 11th @ 12 pm PST – Steve Stedman will teaching a FREE lesson on SQL Server Join Types. TSQL joins – what’s… Read More »TSQL Basics: SQL Server Join Types Webinar
Classes
Notes from SQL Server Classes
Common Expression Tables – Introduction
Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn… Read More »Common Expression Tables – Introduction
Data Paging with CTEs
The following is chapter 7 from my Common Table Expressions book in its entirety. I can remember the first time that I worked on data paging code. I… Read More »Data Paging with CTEs
Multiple CTEs in a Query
The following is chapter 6 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in… Read More »Multiple CTEs in a Query
Hierarchical Queries
Creating a SQL Server hierarchical query can be incredibly useful, but also very difficult without the right tools. The following is chapter 5 from my Common… Read More »Hierarchical Queries
CTE Book Sample Code
As part of the CTE book there is a sample database that all the queries use. You can download the create script for that sample… Read More »CTE Book Sample Code
Recursive CTEs
The following is chapter 4 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow… Read More »Recursive CTEs
CTEs Instead of Derived Tables
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an… Read More »CTEs Instead of Derived Tables
SQL Saturday – Spokane WA
On March 23rd I will be presenting at SQL Saturday in Spokane WA. There is still time to register for this event, so you can… Read More »SQL Saturday – Spokane WA
SQL Saturday Victoria Canada
We will be visiting SQL Saturday in Victoria Canada on March 16th. After the last SQL Saturday that I tried to attend was snowed out… Read More »SQL Saturday Victoria Canada