Search results for: cte

By Posted on Posted in Classes No Comments Tagged with , , ,

Here is the agenda for this weeks free SQL training covering  Set Operators, Derived Tables and CTEs – Presentation to prepare for the 70-461 exam: —Set Operators —Derived Tables —Common Table Expressions This session is presented by Aaron Buma and myself. Here is a quick overview of the slides: Set operators – derived tables and CTEs from Steve Stedman This is …

Set Operators, Derived Tables and CTEs – Presentation downloads Read more »

By Posted on Posted in 70-461 Training, Classes, CTE, SQL Server 2 Comments Tagged with , , ,

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 session will be with Google On Air Broadcasts Thursday Feb 12th at 9:00am (pacific). This is a FREE SQL Training …

SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs Read more »

By Posted on Posted in CTE, CTE Book, SQL Saturday No Comments Tagged with , ,

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 2. Manipulating Data 3. Common Use Cases 4. CTE Performance Considerations Download the presentation and samples here:  Advanced CTEs.zip See Also: Introduction to CTEs presentation

By Posted on Posted in CTE, CTE Book, SQL Saturday No Comments Tagged with , , , , , , ,

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: 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 everything needed to start using CTE’s for recursive queries, as …

Introduction to CTEs Slides and Sample Queries Read more »

By Posted on Posted in CTE, CTE Book No Comments Tagged with , , , , , , , , , ,

Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday we took a look at CTEs for Data Paging, today we will build on what we used yesterday. These queries will be using that database that was set up in a previous posting on the CTE_DEMO …

CTE Data Paging in a Procedure Read more »

By Posted on Posted in CTE, CTE Book 1 Comment Tagged with , , , , , , , ,

Day 14 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s and how it compares to the offset and fetch in T-SQL 2012. Now on to CTE Data Paging. These queries will be using that database that was set up in a previous posting on the CTE_DEMO Sample Database, if you haven’t …

CTE Data Paging Read more »