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
CTE
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
Deleting from a CTE with an EXISTS statement
During my 24 Hours of Pass presentation on Advanced CTE’s today I was asked the question about deleting from a CTE when it uses an EXISTS… Read More »Deleting from a CTE with an EXISTS statement
24 Hours of PASS – Advanced CTE Presenation
Today I am presenting on Advanced Common Table Expressions as part of the 24 Hours of PASS conference. It is being webcast so check it… Read More »24 Hours of PASS – Advanced CTE Presenation
Advanced Common Table Expressions – 24 Hours of PASS
On Wednesday June 24th at 6:00pm pacific time or( 25 Jun 2015 01:00 GMT ) will be speaking at the 24HOP (24 Hours of Pass) conference which… Read More »Advanced Common Table Expressions – 24 Hours of PASS
Upcoming Speaking Engagements
There is a lot happening right now, so I thought I would put together a brief overview of upcoming speaking engagements. May 13th – When… Read More »Upcoming Speaking Engagements
Weekly SQL Training – MERGE Statement and Recursive Queries
The free SQL Server Queries weekly training is being presented by Steve Stedman. The training is being presented by Aaron Buma and myself. This week we… Read More »Weekly SQL Training – MERGE Statement and Recursive Queries
Using a Common Table Expression Instead of a Derived Table
Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up… Read More »Using a Common Table Expression Instead of a Derived Table
What is a Common Table Expression
I just a added a video to YouTube titled “What is a Common Table Expression”. This video covers the extreme basics of what a CTE… Read More »What is a Common Table Expression
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next… Read More »SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs