update tbl_CHD_UserStatus set status = '?' where ownerId= and ownerType = and fspro_userid = select firstName, lastName from tbl_FSPro_Members m where m.fspro_userid = and m.ownerId = and m.fsl_tablecode = update tbl_CHD_UserStatus set status = '?' where ownerId= and ownerType = and fspro_userid = update tbl_CHD_UserStatus set status = 'U' where ownerId= and ownerType = and fspro_userid = select listId from tbl_LST_PartnerLists where listName = and ownerId = and ownerType = and partnerType = 'OPR' insert into tbl_LST_PartnerListItems ( listId, partnerId ) select #_listId#, fseOperatorId from tbl_CHD_UserTargets where ownerId = and ownerType = and fspro_userid = and fseOperatorId > 0 update tbl_CHD_UserStatus set status = 'E' where ownerId= and ownerType = and fspro_userid = update tbl_CHD_UserStatus set status = '?' where ownerId= and ownerType = and fspro_userid = update tbl_CHD_UserStatus set status = '!' where ownerId= and ownerType = and fspro_userid =