Transcription of Video: So here’s an example of building a recursive common table expression, I’m gonna start out with the with statement, we’re gonna call it department CTE. And we’re going to label the columns that we’re going to return …

Steve Explains how to build a Recursive CTE Read more »

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 out if you can. The outline for the presentation will be the following: Recursive Queries …

24 Hours of PASS – Advanced CTE Presenation Read more »

As part of our weekly free SQL Query Training, we have split the 70-461 curriculum into 4 sections to prepare everyone to take the certification test later in the year. Today’s session is to review the first 25% of the …

Today’s Training: SQL Queries Section 1 Review Read more »

We are currently about 25% of the way through the SQL Server 70-461 exam preparation class, which has been available through Google On Air Broadcasts every Thursday at 9:00am Pacific time. To celebrate the 25% mark, and to strengthen the …

Next Weekly Free SQL Training: A Review Read more »

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 are covering two topics, first the MERGE statement will be covered by Aaron, then I …

Weekly SQL Training – MERGE Statement and Recursive Queries Read more »

Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL …

Next Week’s Free SQL Training: MERGE Statement and Recursive Queries Read more »