MSDN Webcast: Using Transact-SQL for Recursive Queries in SQL Server 2005 (Level 300)  

Microsoft SQL Server 2005, is the first version of SQL Server that supports recursive queries and implementing a standard recursive common table expression (CTE). In this webcast, we explore recursive CTEs and demonstrate how to use them to answer common requests against graph structures. Using an employee organizational chart as an example of a graph structure, learn how common requests against graph structures include:
• Sub-graphs, all subordinates of a given manager
• Paths, the management chain of a given employee
• Presentation, the sorting and indentation of information
We also cover advanced subjects, including cycle detection and sorting siblings.

Presenter: Itzik Ben-Gan, Mentor and Co-Founder , Solid Quality Learning

Itzik Ben-Gan is a mentor and one of the original founders of Solid Quality Learning, a global provider of advanced education and solutions for Microsoft SQL Server. A Microsoft Most Valuable Professional (MVP) for SQL Server since 1999, Itzik has delivered numerous training events around the world focused on Transact-SQL querying, query tuning, and programming. Itzik is the author of Inside Microsoft SQL Server 2005: T-SQL Querying (Microsoft Press, 2006) and Inside Microsoft SQL Server 2005: T-SQL Programming (Microsoft Press, 2006). He has written many articles for SQL Server Magazine, as well as articles and white papers for Microsoft Developer Network (MSDN).

To avoid possible problems, we suggest you temporarily disable pop-up blocker software before viewing the webcast.

Register to view this on-demand webcast and download a .wmv of the webcast now. By registering, you will also receive a confirmation email the following day with a link to the PowerPoint download.

If you have questions or feedback, contact us.