Yes, you are correct.  RM20201 and RM20101 are two different tables.  I also agree with you that we need to replace the five part names with a subquery...

Thanks for your suggestion.  After making few adjustments, it works but only when I don't insert into a table.  For example, it gives me error when I add the following...

I followed your your steps and I get the following printed result:

INSERT INTO ##rmf103650513 SELECT APTODCNM, APFRDCNM

from mwltmw.MWI.DBO.RM20201 

WHERE (APFRDCNM NOT LIKE 'CREDT%') AND (APFRDCNM NOT LIKE 'PYMNT%') AND...

the value of gpdb is mwltmw.mwl.dbo.RM20201(server name.databasename.dbo.tablename).  The problem may arise while I am trying to insert into a table.  For example,  if I execute the following query, it executes...

Hi Jeff,

Thanks for your reply.  I believe the problem is in the following line of code:

SET @sql = @sql + 'AND ((SELECT count(a.DOCNUMBR) from ' +...