Common Table Expressions Joes 2 Pros: A Solution Series Tutorial on Everything You Ever Wanted to Know about Common Table Expressions

powerful and often overlooked features in Microsoft

SQL Server. This Joes 2 Pros book will show some of

the more interesting things you can do with a CTE. We

will learn how CTEs are a great alternative to derived

table queries, how to do data paging with a CTE, and

recursive queries with tree path and hierarchical output.

This book will also cover how to use the DELETE,

UPDATE, and INSERT statements with a CTE, and how

to use CTEs in stored procedures and functions. We will

discover what is good and bad with CTEs when it comes

to performance, and how to avoid performance pitfalls.

The twelve chapters take us from the most basic

introduction of a CTE all the way to the more complex

usage scenarios where a CTE can change the way you

look at writing T-SQL queries. Learn how to use a single

CTE or multiple CTEs in a single statement as well as

nesting them.