SQL Unpivot and more 

Awesome video, thank you!

Great work here and thanks so much. This is very useful and helpful.

Brilliant example and explanation Brother 😎

The best way to put it so far👍 Thanks it works whether data is aggregate values or not. good way akso to create tall tables for some reasons.

Brilliant…. Thank you

You are the man

Thank you!

that was clean

Hi James, for the first section where you add the column name for unpivot, how can we write it such that the column name comes from a table or a variable so that it becomes dynamic.

Thanks but how can you have sales amount greater than the inventory amount

Hi james i am great fan of your teaching... could you please make a video on what are the conditions to blend two datasets in microstrategy document? Means is it enough to have one common attribute in two datasets or any other conditions.

Great video! Thanks!

🌟🌟🌟🌟🌟

Thank you. Learning SQL on my own, is there a place to download large amounts of sample data?

please post a video on Microstrategy dossiers in youtube or udemy by updating your course.thanks.

Very nicely explained...

Hi, James. For the first section of the video, you unpivoted. What if you want to add the results of that unpivoted data to another query?

how can we know the original column name ? like SalesAmount and Week