Hi Gila,

Thanks for the response.  Actually, that is the result of a really bad cut and paste job.  The string looks like this:

SET @sSQLCmd='

  update sv

     set sv.SupplierInternalKey = t.SupplierInternalKey,

         sv.PublicationStatus...