T-SQL: Running Totals

I'm demonstrating here 2 different approaches how to query running totals. The first one is based on a self join and aggregates the values whereas the second query uses ROWS UNBOUNDED PRECEDING.

Please leave feedback if this was helpful. Thanks!

T-SQL: MERGE STATEMENT

The Merge Statement can be very handy within an ETL process. Please see the video to understand the syntax and options it delivers.


Please leave feedback if this was helpful. Thanks!

SSAS: Build a Cube and access data in Excel

This video demonstrates how to build a cube in Microsoft SSAS and later on access the cube data from Excel.


Please leave feedback if this was helpful. Thanks!

T-SQL: CURSORS

Cursors in T-SQL are usually not very performant. Depending on the data quantity and what you're trying to achieve, they may be very useful. Please check the video below, where I demonstrate a sample, when Cursor does the job!



Please leave feedback if this was helpful. Thanks!

SSRS: Using .NET custom code for formatting

In this video I will write a funciton in VB.NET to later use for formatting purposes (changing font color).

Please leave feedback if this was helpful. Thanks!

T-SQL: PIVOT vs. UNPIVOT

Today I'm presenting the very helpful aggregation function PIVOT and later a reverse function of this called UNPIVOT. This function helps you present your data in a maxtrix form!


Please leave feedback if this was helpful. Thanks!

T-SQL: Find gap ranges using ROW_NUMBER()

Here I will be demonstrating how you can find gaps with help of the T_SQL function ROW_NUMBER() which I described in the previous video. In the first part I will write a query that shows where each gap begins and ends. In the second query I will show you how you generate a list of missing values.


Please leave feedback if this was helpful. Thanks!