Basic SQL Training - SQL With - How to Use the With (CTE) Statement in SQL Server - Quick Tips Ep35

SQL With - How to Use the WITH Statement/Common Table Expressions (CTE) in SQL Server - SQL Training Online In this video, I introduce the SQL WITH statement (also known as Common Table Expressions or CTE) and show you the basics of how it is used. The SQL WITH Statement is called Common Table Expressions or CTE for short in SQL Server The SQL WITH statement is used for 2 primary reasons: 1) To move Subqueries to make the SQL easier to read. 2) To do recursive queries in SQL TABLE OF CONTENTS 00:00 - Intro 01:40 - CTE Example 04:10 - CTE with Inner Join READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com