Thanks all for the help!

Thanks!

Don't force SQL to fully reprocess the conditions before DELETEing each row, instead use WHERE CURRENT OF in the DELETE:

DECLARE @user VARCHAR(50)
DECLARE @role VARCHAR(50)

DECLARE db_cursor CURSOR...

Being new to cursors, what exactly does the WHERE CURRENT OF db_cursor do? It will keep the SQL criteria in memory on each iteration of the loop?

Thanks Luis, yes I see that I had forgotten to move the cursor forward. I added that and it now performs the transaction. Just curious what you mean by  "suggest...

It looks like because G.LINE_NBR was commented out in CTE2, it can't be used as a join condition in the final Select statement, which is the original issue I had....

I've modified the query to do the SUM aggregation in the final Select query, and I'm just getting the row data in the inner queries. The data is correct in...

PS_DIRECT_DEPOSIT

CREATE TABLE [dbo].[PS_DIRECT_DEPOSIT]
(
         [EMPLID] VARCHAR(11) COLLATE Latin1_General_BIN NOT NULL
       , [EFFDT] DATETIME NOT NULL
       ,...