Recently wrote a query for payroll header information - so this is one line per employee. The resulting query might not be exactly what I'll need on the next job, but this template will be a good starting place. If I use it again I'll continue to update it.