sjerromeharris (3/24/2014)

---

Thanks for your post, and the link to the article.

I've tried your suggestion, but its not making much difference to the results that are being returned. I'm expecting around 58 rows but I'm only getting around 40.

Is there anything else I can try? (I've added a couple of extra columns to the query)

SELECT

Users.Department as Dept,

CaseTypes.Description as Case_Type,

Users.Code as FE,

COUNT(Matters.FeeEarnerRef) as No_of_Matters,

ISNULL(SUM(Usr_Int1.Estimated_total_fee),0) as Fee_Estimate

FROM

((Users LEFT JOIN Matters ON Users.Code = Matters.FeeEarnerRef and (Matters.Created >= GetDate() - 7 AND Matters.Created <= GetDate())

INNER JOIN CaseTypes ON Matters.CaseTypeRef = CaseTypes.Code)

INNER JOIN Usr_Int1 ON (Matters.Number = Usr_Int1.MatterNo) AND (Matters.EntityRef = Usr_Int1.EntityRef))

WHERE

((usertyperef =1) or (usertyperef = 2))

GROUP BY

users.code, usertyperef, users.department, casetypes.description, users.department, casetyperef, users.feeearner

ORDER BY

users.department, casetyperef, users.code;

Thank you