This may help you.

John

Your subquery SELECT Max(D.sent_date)... needs a WHERE clause.

John

What happens if you move the two lines you added between the penultimate and the final parentheses?

John

Check what, if anything, is preventing reuse in the log file like this:
SELECT log_reuse_wait_desc
FROM sys.databases
WHERE name = 'MyDatabase';

John

According to the documentation:

The view contains one row per query statement within the cached plan, and the lifetime of the rows are tied to the...

If stats are out of date, the query optimizer is more likely to make a poor choice of execution plan.  The query will take longer to run and deadlocks will...

That's one reason, but the main reason is that you don't have statistics on temp tables (except, I assume on indexes created at declaration time).  That means that the query...

(1) You can have an index on a table variable, provided it supports a primary key constraint that's created at the same time as the variable declaration
(2) Table scans...

Gerald

Yes, that may be the reason.  Or it may be a Windows thing. Maybe Windows doesn't bother adding explicit privileges to the ACL for accounts that are already...

It might be easier to change the service account to another account, then change it back to the original. Make sure you do this in SQL Server Configuration Manager, so...

Try joining on  b.rowid=(a.rowid + 1)

John

Please will you post some table DDL, sample data and expected results?  Your query will return the same row count in every row, which I suspect isn't what you want.

You can't use TOP in the SET clause.  You can try something like this - you may have to include GTM_DOC_PROD in the subquery and tweak the PARTITION BY clause...