Disabled on Dev

UPDATE tbl_IMPORT_1FSOperators SET cho_name = LTRIM(RTRIM(REPLACE(cho_name, CHAR(160), CHAR(32)))), cho_address = LTRIM(RTRIM(REPLACE(cho_address, CHAR(160), CHAR(32)))), cho_address2 = LTRIM(RTRIM(REPLACE(cho_address2, CHAR(160), CHAR(32)))) WHERE ownerId = AND ownerType = AND eai_batchId = select opr.ownerId, opr.fsltablecode, opr.operatorId, m.eai_importId, m.compareId, m.compareStatus from tbl_IMPORT_1fsOperators m with (nolock) inner join tbl_OPR_ClientOperators opr with (nolock) on opr.operatorId = m.operatorId and opr.ownerId = m.ownerId and opr.fsltablecode = m.ownerType where m.eai_batchId= and m.ownerId = and m.ownerType = and nullif( opr.fsl_choId, 0 ) is null and m.compareId > 0 and m.compareStatus = 'G' and m.confirmedYN = 'Y' and not ( m.ownerId = 66 and m.ownerType = 'MSC' ) update tbl_OPR_ClientOperators set fsl_choId = , fsl_choIdStatus = 'G', fsl_choIdBy = , fsl_choIdDate = where ownerId = and fsltablecode = and operatorId = delete from tbl_IMPORT_1FSOperators where eai_importId = delete imp from tbl_IMPORT_1FSOperators imp where imp.eai_batchId = and imp.ownerId = and imp.ownerType = and imp.compareId > 0 and imp.compareStatus in ( 'Y' ) and not ( imp.ownerId = 66 and imp.ownerType = 'MSC' )