SQL Unpivot and more

In this video I will demonstrate joining multiple unpivot queries using a real work example.

[@aleksandraarsic1100]

Awesome video, thank you!

[@coolharinath6003]

Brilliant example and explanation Brother 😎

[@emmanuelaolaiya]

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

[@hadibq]

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.

[@derekbyers4373]

Brilliant…. Thank you

[@daciai2201]

You are the man

[@sempowhale3138]

that was clean

[@chrisbertj]

Thank you!

[@darrylw99]

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

[@ajaymahato4270]

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.

[@rapo107]

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.

[@JamesOliver]

I have 2 videos I created a while back on data blending that should help. ua-cam.com/video/A8EWDlarzK0/v-deo.html and also ua-cam.com/video/x5W7b7_tmEs/v-deo.html

[@CheCheSmith]

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

[@JamesOliver]

CheCheSmith Yes install sql server express and then download the sample database AdventureWorks from Microsoft

[@hadireg]

🌟🌟🌟🌟🌟

[@thirumalaip6458]

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

[@joshsmart9178]

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?

[@JamesOliver]

If I understand you correctly, you should use CTE / WITH statements to do that

[@slavchevbg]

Great video! Thanks!

[@juancarlosabayo874]

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