Whats So Common About Common Table Expressions?
Don Kiely In databases of the last millennium, recursive queries were a royal pain to implement, often requiring temporary tables, cursors, logic to control the flow, and a head full of hair to pull out while writing them. Yet recursive queries are the best way to go when you need to fit relational data into a hierarchical structure, such as with organizational charts or object/sub-object scenarios. Common Table Expressions (CTE) in SQL Server 2005 greatly simplify writing recursive queries, making it much easier to use this valuable technique in your code. During this session we’ll explore how CTEs work, how to write them and use them in sophisticated recursive queries, what they are good for, and how to keep your full head of hair (if you arrive with one). KEYNOTE SESSION KEYNOTE: Dynamic IT and the 2008 Launch Wave Steve Guggenheimer Its an exciting time to be in IT! Find out how the Microsofts new wave of innovation Windows Server 2008, SQL Server 2008 and Visual Studio 2008 will e
