This post was originally published on this site
Read Time18 Second
Abstract
There is often the requirement for a compensation report to show each employee in a single row and multiple columns for the pay amounts of each pay component. This is frequently done in a inappropriate which causes performance problems. This blog post describes alternative query and report designs that are not only easier to maintain, but also typically perform much better.
