SQL Pivot and Unpivot | Quick Tips Ep57

In this video I show how to use the SQL Pivot and Unpivot. I will walk you through what it is, demonstrate how to use it on a small dataset, then demonstrate how you might use it in everyday programming.

SQL Pivot and Unpivot | Quick Tips Episode #57

TABLE OF CONTENTS
00:00 - Intro
00:57 - PIVOT and UNPIVOT example in Excel
02:34 - PIVOT in SQL
06:34 - SELECT INTO Example
07:03 - UNPIVOT in SQL
10:10 - Real World Example of UNPIVOT
13:26 - Phone Number Normalization
14:30 - SELECT INTO Example 2
15:12 - Drop Phone Columns
16:10 - Left Join Example
17:00 - PIVOT in SQL, advanced example
19:39 - Insert new PhoneType of Fax

YOUTUBE NEWS UPDATES
   / 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_c...

SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com

LET'S CONNECT!
LinkedIn:   / joeyblue  
SQLTrainingOnline: http://www.sqltrainingonline.com