I did not end up using variables as I could not get them to work; however someone else may have better advice on that.

I did notice that I...

What I did was create the CTE at the beginning of the execute SQL query and I was able to write my second query after the CTE within the same...

I was able to get the CTE to work! What a learning experience. Thank you so much for all your help.

Just an update...

When I attempt to save initial SQL query data in a object variable, I am unable to reference that to run the next SQL Query. When I...

I have tried both local and global temp tables and set the RetainSame Connection property to True; however it just hangs when executed? I am so extremely confused now...

Thanks for the quick responses!!!

I was able to save the result set to an Object variable and run without errors; however, I can't figure out how to reference the...