Have you ever wanted to create a recursive query, but didn't see how to do it? Now you no longer have to cringe when asked to turn a self-join table into a tree path outline or level hierarchy.

Each of these goals is now just one query if you use a common table expression (CTE). Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries. The query can be divided into separate, simple, logical building blocks. These simple blocks can then be used to build more complex, interim CTEs until the final result set is generated.

Register for the webinar now to learn:
  • What is a CTE and how it compares to other subqueries
  • How a CTE can simplify complex subqueries
  • How to create outlines, tree paths, and hierarchies from a single query using CTEs
  • When the CTE is has better performance than comparable queries
  • Tools that enhance the effectiveness of CTEs

About Rick Morelan

Rick Morelan has been working with Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008).

Rick has provided training for Northwest University, Volt Technical Education, and Microsoft. He currently works as a Software Design Engineer in Test for the Windows Mobile group, Bellevue College, and Moretechnology.com. As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.

Watch the Webinar On Demand