To CTE or not to CTE?
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.