Archives | Hansen BI

SQL2012 Windowing Functions In The Data Warehouse–2. Reporting

by Marco Schreuder | Jun 13, 2013 | In2BI

This is the second post of a diptych on the magical windowing functions in data warehouse scenarios. With these functions you can greatly simplify the TSQL you write. Many complex queries with CTE’s, temp tables and sub queries can be rewritten to simpler, better...

SQL2012 Windowing Functions In The Data Warehouse–2. Reporting

Top Posts & Pages

Blogroll

Blog History

Recent Posts