Martin Catherall

https://www.linkedin.com/in/martincatherall?originalSubdomain=au

T-SQL Window Functions

T-SQL Window Functions are amongst some of the most innovative and useful features in the SQL Language.

They allow a range of problems to be solved that might otherwise require complex iteration. They will allow you to do such things as

• Order data in different ways with the same query
• Partition data within a query
• Access different rows from within the same query without iterating
• Find gaps in data
• Simply (and efficiently) define running totals within a query.
• Solve complex business problems more easily.

This session will look at a range of implementations - from basic to advanced and will demonstrate some real-world problems that were solved using T-SQL Window Functions

Return back to home page