How can I use a subquery with the way the criteria field is storing the WHERE statement?

Again, an example for the criteria value is: " STATE = 'AL' AND ZIP...

I don't see how this can help me, the criteria can be different for each row of data

First, maybe I thought have articulated this better. I was trying to give an explaination of my thought process and I got stuck at the function that has the dynamic SQL...

The problem is that the server is always "busy" receiving data (24/7)

I tried the Select... With (NOLOCK) Statement.

The job was running a little bit longer this time but failed again....