You need to include your table name in the ORDER BY clause in windowed function in your CTE.  I'm not sure where to get the results you need.

Also,...

I think the reason that no one has done it, is because the best approach is to use SSRS and export to Word.

Drew

It's because when you moved the Targets JOIN clause, you moved the corresponding ON clause to the end of the query, which means that that join will be evaluated last...

When posting job announcements, it would help if you included where the job was located, preferably in the title.

Drew

This is best done using a reporting tool like SSRS (which can even export directly to Excel).

If that doesn't work, then you will need to use a CROSSTAB...

I believe that this gives the correct results.  It's also requires far fewer reads than Chanthor's version.

;
WITH starts AS
(
    SELECT *,
        CASE WHEN hc.hourly...

The previous solutions require two table scans.  Here is a solution that requires only one table scan.  It does require that the appropriate index (AccountNumber, ProcessDateShort DESC) be in place...

You misunderstood.  If you define your groups on the individual persons, you will get one record FOR EACH PERSON, not one record for a specific person.

Part of the...

Reported as spam.