SQL Tutorial - How to Calculate Rolling Totals

[@houstonvanhoy7767]

@BeardedDev. The video on this movie is a lot clearer. Thank you.

[@nmirza2013]

Thanks a lot for Windows function series. It has helped me a lot

[@BeardedDevData]

Thanks for the positive feedback.

[@raymondjurado9203]

I can't do my stuff without Window Functions. Very pleased with how elegant they worked out sometimes. Hard to learn at first.

[@houstonvanhoy7767]

Yes, @raymondjurado9203. It does take some time to sink in. I'm still working on it!

[@houstonvanhoy7767]

1:42 Do you have a separate video on using temp tables?

[@BeardedDevData]

I haven't at the moment.

[@joshuasowin7071]

I am wondering if it would be possible to get a download of the various databases you've use in these videos in order to better follow along with what you're teaching. Thank you for the excellent content.

[@BeardedDevData]

Hi, unfortunately I haven’t but I am going to add code samples to future videos to allow you to follow along.

[@CaribouDataScience]

How about a non-rolling total i.e I calc the total for the first week of the month, then I calc the total for the second week of the month etc.

[@BeardedDevData]

Sure, would just need to move week in to the partition then the calculation will reset when it hits a new week, you can use DATEPART(WEEK, [Date]) within the partition or if you need to use a specific calendar, you can add this as a table, join to it within the query then use your own calendar to get the week number as part of the partition.

[@CaribouDataScience]

@@BeardedDevData Thanks, that is really helpful.

[@nishantkumar-lw6ce]

Hi can we have videos on query plan ?

[@BeardedDevData]

Hi, thanks for you request, I will get some videos up by the end of the year.