select eai_importId, ownertype, ownerId, eai_lineNumber, email, group_name, fseUserId, fseGroupId, fseProcessLine, first_name, last_name, title, organization, address1, address2, city, state, zip, phone, phone_ext, fax, mobile_phone, userID from tbl_IMPORT_GroupMembers with (nolock) where eai_batchid = select fspro_userid from tbl_FSPro_Members with (nolock) where FSPro_UserID = and ownerId = and FSL_tablecode = select fspro_userid from tbl_FSPro_Members with (nolock) where trim(email) = and ownerId = and FSL_tablecode = update tbl_IMPORT_GroupMembers set fseUserId = where eai_importId = update tbl_IMPORT_GroupMembers set fseProcessLine = 'N' where eai_importId = update tbl_IMPORT_GroupMembers set fseProcessLine = 'N' where eai_importId = update tbl_IMPORT_GroupMembers set fseUserId = where eai_importId = select GroupID from tbl_SEC_Groups with (nolock) where GroupName = and OwnerID = and FSL_TableCode = update tbl_IMPORT_GroupMembers set fseGroupId = where eai_importId = update tbl_IMPORT_GroupMembers set fseProcessLine = 'N' where eai_importId = select eai_importId, ownertype, ownerId, eai_lineNumber, email, group_name, fseUserId, fseGroupId, fseProcessLine from tbl_IMPORT_GroupMembers with (nolock) where eai_batchid = and COALESCE(fseProcessLine,'Y') <> 'N' and fseUserId is not null and fseGroupId is not null select MemGrpLinkID from tbl_SEC_MemGrpLink where fspro_userId = and groupId = INSERT INTO tbl_SEC_MemGrpLink ( fspro_userId, groupId ) VALUES ( , ) update tbl_IMPORT_GroupMembers set fseProcessLine = 'N' where eai_importId = #_outputHTML# #_message#