As a first time published author it is exciting to see that my Common Table Expressions book is now available on the Amazon.co.uk website. It showed up on Amazon.com about a week ago, and now its available in the UK. …
My common Table Expressions book became available on Amazon.com late last week. After presenting on Common Table Expressions at SQL Saturday yesterday, the sales jumped a bit to the point that the CTE Book is now #2 in the Hot …
My Common Table Expressions book is now available at Amazon.com as both the normal printed book, and the Kindle version. Just in time for SQL Saturday Redmond tomorrow.
Mastering Common Table Expressions (CTEs) in SQL Server Common Table Expressions (CTEs) are a powerful feature in SQL Server that can make your queries more readable, more expressive, and often more efficient. Today, we’ll demystify this tool and invite you …
Mastering Common Table Expressions (CTEs) in SQL Server Read more »
Learning Common Table Expressions is one of my favorite classes, with over 8 years of prep time for this course, including presentations at live conferences, writing a book on CTE’s and number online presentations. This course will cover most everything …
40% off Learning Common Table Expressions in SQL Server Read more »
Improve you query skills with Common Table Expressions. The Common Table Expression (CTE) is one of the more powerful and often overlooked features in Microsoft SQL Server. This book will show some of the more interesting things you can do …
Over 250 pages of Common Table Expression lessons! Download your FREE copy today! The Common Table Expression (CTE) is one of the more powerful and often overlooked features in Microsoft SQL Server. This book will show some of the more …
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 eight page print out with an 8pt font showing a single SQL statement. It was …
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 snowboarding after being a skier for many years it was very uncomfortable. Everything was difficult, …
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 he duplicates himself to get more work done. It first started out that he just …