What is a Common Table Expression
The following is chapter 2 in its entirety from my Common Table Expressions book. What is a Common Table Expression? The first time I tried… Read More »What is a Common Table Expression
CTE Book
Common Table Expressions – Chapter 1
The following has been republished from my Common Table Expressions book. Chapter 1. Memory Tables There was a 1996 Michael Keaton movie called Multiplicity where… Read More »Common Table Expressions – Chapter 1
CTE to Split a String in a function SplitString
Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a… Read More »CTE to Split a String in a function SplitString
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
Advanced CTEs Slides and Sample Queries
My second presentation at SQL Saturday in Portland Oregon is Advanced Common Table Expressions. Here is the outline for the session. 1. Hierarchical Recursive CTEs… Read More »Advanced CTEs Slides and Sample Queries
Introduction to CTEs Slides and Sample Queries
Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract:… Read More »Introduction to CTEs Slides and Sample Queries
SQL Saturday #265 in Portland Oregon
I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland,… Read More »SQL Saturday #265 in Portland Oregon
CTE Book Signing at PASS Summit – Wed 6:45pm
Wednesday at 6:45PM I will be doing a book signing of my Common Table Expressions Book. Joes2Pros will be giving away 30 books during this… Read More »CTE Book Signing at PASS Summit – Wed 6:45pm
Advanced CTEs Slides and Samples
Today I presented on Advanced CTEs at SQL Saturday Denver. Here are my slides and sample code for download: Advanced CTEs Denver Thanks to everyone… Read More »Advanced CTEs Slides and Samples
In Denver for SQL Saturday
I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions. This presentation should be a lot of fun. I will be… Read More »In Denver for SQL Saturday
- « Previous
- 1
- 2
- 3
- 4
- Next »