I've attached the 3 scripted tables and some data. I would remove the category column from the entry log table. Thanks!

I reduced it down to the following and got the correct number of records the original SP returned bu the sums were all wrong. I didn't filter on UserID.

SELECT ...

I think I understand that. I was able to build the derived output but still had the problem with master table. IS it possible to keep this result in memory...