Using CTEs with SQL Reporting Services & Dynamics GP

Mike Urbom and I had a great time doing a webinar recently for the GPUG Special Interest Group (SIG) for SQL Reporting Services. We talked about using Common Table Expressions (CTE) to simplify queries for reports. CTEs were new in SQL Server 2005 and can replace using derived tables. Essentially, they create temporary result sets [...]