select m.FSPro_UserID, m.salutation, m.firstname, m.lastname, m.ownerId, m.fsl_tablecode, m.title, m.Organization, m.orgId, m.orgType, m.staffMember, m.email, m.FSpro_Password, m.loginenabled, m.phone, m.address1, m.address2, m.city, m.state, m.zipcode, m.countryId, m.CustomFld_1, m.CustomFld_2 from tbl_FSPro_Members m with (nolock) where m.FSL_TableCode = 'CHO' and m.OwnerId in () and m.email = select m.FSPro_UserID, m.firstname, m.lastname, m.title, m.Organization, m.orgId, m.orgType, m.email, m.FSpro_Password, m.loginenabled from tbl_FSPro_Members m with (nolock) where m.FSL_TableCode = 'MSC' and m.OwnerId = 173 and m.email = and nullif( m.orgType, '' ) is not null select o.operatorId, o.companyName from tbl_opr_clientoperators o with (nolock) where o.FSLTableCode = 'MSC' and o.OwnerId = 173 and o.fsl_choId = update tbl_FSPro_Members set FSpro_Password = where FSL_TableCode = 'MSC' and OwnerId = 173 and email = update tbl_FSPro_Members set loginenabled = where FSL_TableCode = 'MSC' and OwnerId = 173 and email = select changePasswordRequired from tbl_fspro_members with (nolock) where fspro_userId = update tbl_fspro_members set fspro_password = , fspro_password_method = 'SHA256', passwordLastChangeDate = , changePasswordRequired = 'N' where fspro_userID = ---> client.ID = 0; client.login = 0;