Montag, 21. Dezember 2015

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!

Samstag, 24. Januar 2015

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!