วีดีโอ

It was great , greetings from Venezuela

so underrated how valuable this information is! Thank you for this.

good

This is putting everyone together as a sum. When I want to see the scores for each person over time. How do I do that? I used to be able to utilize Tableau and I could see people by names and see their data over time. I think I used to be able to do this with excel before I got Tableau but now work for someone that doesnt have access..

Thanks, great intro for me.

dude used MTG terms

Everton is the worst, mate.

Thank you. Very neat!

You're a good teacher. Thanks. I just started learning SQL today, and I ran into a situation where I created same column entries multiple times. Came searching on YT how I can delete row by row, then I stumbled on your video. And guess what? I got more than asked for! You got yourself a new subscriber with alert set to All for all your contents.

Thank you so much!

Does this begin transaction, commit, rollback work with Stored Procedures?

6:51 It was a simple error. Man, I hate when that happens. Great video, by the way. Thanks for reminding me about column-level visibility settings. I have rarely (if ever) used it, and thusly it totally slipped my age-addled brain. Maybe that will come in handy someday in the future. Cheers!

on point, great explanation mate

Awesome thanks

Any example for 2 tables which is having many to many relation. Does sql works in this case

Good one

Can you please provide me the entire script to the same?

well explained and no indian accent 👍

This might be coming in late but this video really helped a lot. Thank you and I'll be following you and learning much from you.

in like operator it givess Syntax error why?

Is there an easy way to check more than 1 row

Thanks and maximum how many records we can control per page by using page break and also when we export to excel it shows multiple sheets but I need to show only single page with page break option.

Thank you!! 💯

Thank you!!!

Thank you so much :)

Use of top1 here?

how to deploy this

I'm in the middle of a SQL course and I wasn't quite understanding the idea behind coalesce. Thanks for clearing it up!

Really appreciate this vid. Thanks! <3

very helpful thanks! I am doing this in a class and you just made it so I do not have to search several things to complete what is expected.

In my system (zoho analytics) can't do that, but I saved the query and then created a new one and I take the values from there, but when I try to obtain other data like the amount, and I join by customer ID, duplicates everything because I have more the one customer ID, since there's more the one sales order. How can I fix that? Thank you for your video.

Thank you sir, this is the best explanation about database objects I've seen on YT. Keep on creating!

thank u for your tutorial. i have any problem to take data with new date. i use this query. and work select * from( select nama,max(tanggal) MAXID from tester.dataku group by nama)ns inner join tester.dataku on (dataku.tanggal=ns.MAXID and dataku.nama=ns.nama) I develop from your query to my table.

Great Video and Explained in great detail Great Job!!!!!!!

in my VS 2019 (updated just now) i don't have that gauges so beutyfull, i have only some noisy and ugly gauges... where can i find the plugin for the gauges you use in VS? thank you so much

Thank you for this!

Can I use a value from database inside the custom code. Creating a new database connectivity or using the existing dataset. Thank you in advance.

Very helpful thank you so much.

Thankyou so much it was very helpful.

I have a list of orders. Each time the status is updated for the order, the order duplicates with the latest date (ex. Order 7887 opened on 11/6, order 7887 closed on 11/8) Do use the MAX() on the date or the order number itself to find the latest update for that Order?

Thanks, this was a great explanation 😬👍

Great! Thank you so much!

I'm trying to do the same through an ODBC connection, but it doesn't recognize the "TOP" clause.

What if I want to see orders processed after 2012? Can I just use Where ns.OrderDate>='2012-01-01'?

this should have more views. helpful and concise, thanks man! 👍🏿

𝓅𝓇𝑜𝓂𝑜𝓈𝓂

Thanks for this video, helped a lot👍

thank you...it was helpful

very good, since reporting services does not allow to do this natively

Is there a way to show the tablix data structure even if there is no data in the rows? I have a tablix that have upper and lower and text boxes.. when there is no data, Management still would like to see the tablix info innstead of a blank screen. I did countrows but it still shows blanks