SQL Unpivot and more

[@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.

[@darrylw99]

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

[@coolharinath6003]

Brilliant example and explanation Brother 😎

[@emmanuelaolaiya]

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

[@aleksandraarsic1100]

Awesome video, thank you!

[@derekbyers4373]

Brilliant…. Thank you

[@daciai2201]

You are the man

[@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.

[@chrisbertj]

Thank you!

[@sempowhale3138]

that was clean

[@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. th-cam.com/video/A8EWDlarzK0/w-d-xo.html and also th-cam.com/video/x5W7b7_tmEs/w-d-xo.html

[@juancarlosabayo874]

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

[@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

[@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

[@slavchevbg]

Great video! Thanks!

[@hadireg]

🌟🌟🌟🌟🌟