¿A la ETC o no?
When you are using a pivot pattern, you don't need CTE. Pivot patterns are fairly easy and create powerful results, helping you to become a better SQL user.
You can use a pivot pattern to dynamically aggregrate data with only certain values matching the criteria you provide, making for cleaner, faster results that are more readable and user-friendly. In this video, Jon will teach you how rewriting queries using a pivot pattern can boost your reporting to new levels.
Pivot patterns don't require CTE's or temp tables and can make your reports 50% faster. Get started using this helpful tool today. Click here to watch.