select listId from tbl_LST_PartnerLists with (nolock) where ownerId = and ownerType = 'USR' and partnerType = 'CHO' and listName = 'Current 1fs Operator Selections' insert into tbl_LST_PartnerLists ( ownerId, ownerType, partnerType, listType, listName, dateCreated, createdBy ) values ( , 'USR', 'CHO', 'CLIENT', 'Current 1fs Operator Selections', getDate(), ) select partnerId from tbl_LST_PartnerListItems with (nolock) where listId =