Click here to Skip to main content
15,900,461 members
Articles / Database Development / SQL Server / SQL Server 2008

SQL Wizardry Part Three - Common Table Expressions (CTEs)

Rate me:
Please Sign up or sign in to vote.
4.99/5 (19 votes)
12 Jan 2014CPOL9 min read 27.6K   264   45  
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
Australia Australia
Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.

Comments and Discussions