Thanks for helping everyone....based on the input and another thread regarding retrieving values from an executed procedure, that following code works just fine.

I'm not showing the variable declarations but I...

Thanks for the Exec sp... statement, I'll try it out.

As for more details...I'll try...it is conceptually simple...

Background...Tables: Import (incoming data), Stores (storeids and desc), BatchesSQL (batchid, desc, sql code), BatchesSQLStore...

I understand now about the Exec running in its own space. I plan to read up on it a bit to see if I can get more details...as to the...

I thought I replied to this but it didn't show up...Sorry...I'll try again.

I can't provide the actual code...I haven't built the code yet. Since this part of the project is...