Why do my rollups come before the data while yours are after.

Crystal clear explanation, thanks!

Super clear explanation, thanks!

easy to follow. thank you

Great video, thanks. In your last example, what is the benefit of CROSS APPLY versus something like this? WITH CTE AS ( Select blah ,row_number() over (partition by BusinessEntityID order by [some relevant field]) rownum FROM Person LEFT JOIN Trans on Person.BusEntId = Trans.BusEntId ) SELECT * FROM CTE WHERE rownum <= 2

Isn't there a expected output to compare after the calculation? if the calculated output isn't matching the expected output, we will find the Gradient for the cost function then we find the minimum cost. It shouldn't matter where we start because it will eventually got fix during the process.

i got my json from a table copied it and put it between set @json = ' ' and it causes an error: Unclosed quotation mark after the character string '}}]}';

Absolute clarification and demonstration. The way u illustrated the subject is plain and easy to grasp. We need more contents like this. You have been not around, are we gonna hear about you anytime soon?

Thanks for this. If I had a variable amount of categories, how could I pivot?

Watching this in 2024 and love the content- which you comeback to posting more videos on how to productively use AI to run SQL codes

well explained on the rollup level! thx!

Thank you 🙏🏾

Good one thank you, here is I found some more SSMS techniques: kzbin.info/www/bejne/sHaliKttiM6XebMsi=CvirZgOp82zRddAJ kzbin.info/www/bejne/paWYdqGpaLKeg5osi=kjtcNtMk8G13gtzI

I like ur vid

incredible information very eye opening to be honest

That's really great...... thankyou sir

Great content! I know this is a older video but do you have a link to the datasets?

Thank you James, great video

Great video. this really explains clearly and basically how apply operator works and how it works differently to join

awesome

Been doing SQL for +20 years and bumped into these statements in a query of a colleague. So looked up your explanation. Quite useful functionality. Thanks!

Beautiful !! I was always wondering the purpose of full outer join

Thanks for the analysis! 🔍 Just a small off-topic question: 😅 I have these words 🤨. (behave today finger ski upon boy assault summer exhaust beauty stereo over). I’d be grateful for some help. 🙌

Thank you very much. I did meet this syntax on procedures I was working on without understanding what it is and I wasn't confident with my understanding of the documentation. Now I was working on a problem of the same kind as the last example. I did try many things. I had a query that was functionnally OK but the performance was awful. We have an expert SQL dev in the team and he did me a proposition to solve this, but it is not quite exactly solving the issue but just close and the performance is way better. Guess it is his way to put me on the way without disclosing the full answer. After all I need to learn that thing. With your video I understand what it does and what I should do to completely solve the problem.

Great analysis, thank you! I have a quick question: I have a SafePal wallet with USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). How can I transfer them to Binance?

Nice concept.is it possible to check the value from a table colum in pre sql

lifesaver video

I watched this today while I was stuck trying to use merge for the first time at work. I looked up this video on my phone just to say thank you!!! I can't post youtube comments from my work pc but I wanted to say great vid 😊

what do mean by materialized at 12:29

Great Idea. If what more than 2 children approaching from different direction ??? Any keep it up good development

james i grasp little from your videos,, please take some pauses or that stuff

The best explanation. Thanks

Hi James, Please add more videos on Microstrategy advanced concepts. I found your videos are very much helpful to use in my projects. Thanks a lot for sharing this knowledge.

Thank you for this very useful video!

Nice Video

This was so cool. Are you potentially planning to go into more detail so people can recreate it ?

Probably the best teaching video I've seen in terms of: Visuals + well paced script + audio on point. Please keep up the good work.

thanks for the video

thanks for the video

thanks for the video

You are the MAN!!!

Hello sir if you still active user please I want to know how you to create a script for the DATA_LOAD.trg cause I've been reading several article of community they showing only loaded data from the cube not from the datawarehouse. Please can you help me with this

It's rubbish that you have to hard code the columns for the pivot... can you not do a select Distinct to populate that?

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

What's this got to do with SSIS

thank you so much, I appreciate that, and it was very useful

Your videos are great, you speak in such a clear manner

Im just proud of myself that i started learning sql 2 weeks ago and i understand about 95% of what ur talking about. Goals

Been using SQL as a functional ERP resource so I don’t know if I am an expert. This is very well done and IMHO not too far out of reach for someone who has the basics. Where have you been hiding?

do we also need to add weights on the hidden layers? all of them? or only the weights of the input