Friday morning at 8:00am at PASS Summit 15 in Seattle, I will be presenting my Advanced Common Table Expressions and Recursive Query Technique session. Advanced Common Table Expressions Here is the abstract: You might have been introduced to Common Table Expressions …
Advanced Common Table Expressions and Recursive Query Technique Read more »
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 week Aaron Buma and I will be presenting Set Operators, Derived Tables and CTEs. The live …
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs Read more »
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 signing. Come by the Joes2Pros booth for a chance at one of the 30 CTE …
After registering at PASS SUMMIT 13, I had a nice surprise. I walked over to the bookstore to see what interesting new books I could find. I discovered that they had a stack of my book on Common Table Expressions. …
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction …
Day 4 of Common Table Expression Month (June) at SteveStedman.com, today I will cover the topic of terminating the previous T-SQL statement. These queries will be using that database that was set up in a previous posting on the CTE_DEMO Sample …
Common Table Expressions – Terminating the Previous Statement Read more »
Day 2 of Common Table Expression Month (June) at SteveStedman.com, today I will cover creating your very first CTE. Keep in mind that this may look a bit weird or strange at first, the syntax is different from anything you …
Writing Your First Common Table Expression with SQL Server Read more »
As I have presented my Common Table Expressions presentation many times, and as part of writing the Common Table Expressions Book I have created some sample database scripts to use. Once you load up the script into SSMS and refresh the databases …
This month is going to be Common Table Expressions Month at SteveStedman.com. My goal is to post one valuable post on a Common Table Expressions topic each day for the entire month. What is a Common Table Expression A …
Common Table Expression (CTE) Month at SteveStedman.com Read more »
I used to be able to do the Common Table Expression in a single 1 hour session, but after writing the book on Common Table Expressions, I discovered that I just can’t fit it into an hour with the detail …