---> set NOCOUNT ON insert into tbl_CRM_Interaction( participantId, ownerId, ownerType, FSPro_UserId, SourceId, SourceType, FullName, Title, interactionDate ) values ( , , , , , , , , ) select interactionId=@@identity set NOCOUNT OFF select m.orgId, m.orgType, p.participantId from tbl_FSPro_Members m left outer join tbl_CRM_Participant p on p.operatorId = m.orgId and p.ownerId = m.ownerId and p.ownerType = m.FSL_TableCode and p.marketingActivityId = where m.FSPro_UserId = and m.ownerId = and m.FSL_TableCode = set NOCOUNT ON insert into tbl_CRM_Participant( marketingActivityId, ownerId, ownerType, operatorId, sourceId, sourceType, companyName ) values ( , , , , , , ) select participantId=@@identity set NOCOUNT OFF