SQL Server Programming Part 18 - Dynamic Pivot Tables

By Andrew Gould

You can download the script to create the Movies database used in this video at the following link:

You can view a written version of this tutorial at:

You can see the range of resources and courses we offer in SQL Server here:

[BGODE]

Its been 10 years, and there are no youtube tutorials better than these, thank you very much

[richardshi]

This series of education videos were created 6 years ago, but are just as effective and relevant today. Many thanks to the Wise Owl!

[hilmargustafsson]

Best explanation of dynamic SQL pivot I have ever seen, heard or read. Thank you!

[alireza]

I googled a lot about Dynamic pivot and none of the explanations was clear and easy like this one. Thanks.

[houstonvanhoy]

Thank you, Andrew! It seems to me that you have created what Microsoft should have created in the first place. Perhaps new versions of SQL Server will incorporate (or better, have incorporated) this functionality. 👍

[YukiAmeka]

Thank you so much for this series! Without these videos, it would have been much more difficult to complete the first bunch of tasks at the DB Dev bootcamp I'm in. I've shared the link with my teammates & mentioned your channel during my Demo report in case someone in the audience could use them

[DayTradeEssentials]

You are an asset to YouTube software developer community. Thank you!

[GAMasterMedo]

Really loved the series, learned the whole class off of your videos and w3schools in less than a week.
If only all classes on college were recorded. Clear English + option to make it 2x faster is the best way of learning for me. Cheers mate!

[jhzhaozhao]

Great work. I enjoyed every bit of it!  The explanation was very logic and your voice is very nice and attractive. I just wish you could have made the volume louder so I can listen to your playlists on my cell phone during my commute. I plan to finish listening all your videos. So far I just finished SSIS part.

[nikhil]

Clearly, one of the best explainations I have ever came across . Thank u

[omkarsakhalkar]

Thank You very much WiseOwl. I have watched all your videos on SQL and they are just awesome. Very Well Explained!!

[houstonfirefox]

Very well presented! This would be an excellent use case for a Matrix object in SSRS vs a straight Table display. Very well done!

[gp]

Best Video ever in regards to Dynamic Pivoting Columns

[sharqyyem]

Thank you very much for this awesome work.
You have talent training for all levels watchers.
I watched all playlist in one breath.

[fUjiMaNia]

It was awesome to see how to execute a string, never new how before. I'd also like to share these 3 useful T-SQL functions that were introduced in SQL2012 that might come handy for any of the watchers. I've been using and abusing these since we upgraded to SQL2012.

1) The beloved IIF function 
    Syntax: IIF ( boolean_expression, true_value, false_value )

2) EOMonth 
    Syntax: EOMONTH ( start_date [, month_to_add ] )

3) Concat 
    Syntax: CONCAT ( string_value1, string_value2 [, string_valueN ] )

[hungwenlong]

Thanks, all the training tapes are very helpful.

[Oobs]

In the Dynamic SQL tutorial video, you made a point to begin NVARCHAR strings with N (e.g., N'TextStringHere'), but in this video you omit that N character, and obviously SQL Server executed the code without issue.  I assume, then, this character is optional?

Thank you very much for this tutorial series; it's been extremely helpful in getting me caught up to where I need to be at my new job.

[BijouBakson]

This awesome! covers everything in this series, virtually. Oh and I've noticed that to initialize the variables you didn't need to start a new line with the SET clause; instead, you just added the value on the same line the variable's been declared. I also noticed that your code worked even though the @SQL string is not a Unicode. I have been revising without a server, so you can imagine how watching this helped, even though it was posted back in 2014. On a side note - I have been using a pen and pad as I do not have access to an SQL server at present. May I just say a huge - Thank you so much :)

[venkatasrinivas]

Thank you WiseOwl, very easy and nice tutorial

[dilipkumar-ddud]

thanks a lots
i am new in sql server and i was searching for this from last few days....
once agian thanks