-- run this and check DateFinished in the output to see how many
-- rows you should expect to return for December 2012, the current month.
-- The oldest rows will be from the last half hour or so of November.
SELECT
p.BRTNumber,
p.ClientsKey,
p.ProductKey,
p.DateFinished,
p.Finished,
p.ReportType,
p.Premises,
p.OrderDate,
p.ClientKey,
p.Invoiced,
f.CaseNumberKey,
f.Total,
f.Summary,
c.ClientKey AS Expr1
FROM PropertyInformation p
INNER JOIN Fees f
ON p.CaseNumberKey = f.CaseNumberKey
INNER JOIN ClientTable c
ON p.ClientKey = c.ClientKey
WHERE p.Finished = - 1
AND p.ClientKey = 2
AND p.DateFinished >= DATEADD(hour, -135, GETDATE())
AND p.OrderDate > CONVERT(DATETIME, '2011-06-30 00:00:00', 102)
ORDER BY p.DateFinished DESC --p.ClientsKey
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden