insert into tbl_bcrm_objectivebundles ( ownerid, ownertype, bundlename ) values ( , , ); select email, firstname, lastname from tbl_fspro_members where fspro_userid = and ownerid = and fsl_tablecode = select count( distinct interactionid ) as totalCalls, count( distinct dispositionuserid ) as repCount, count( distinct mfr_id ) as totalMfrs, count( distinct territoryid ) as totalTerrs, count( distinct partnerId ) as totalTargets from qryTrimesterPlanningBaseDataset select distinct mfr_id, mfr_name, TerritoryID, territoryName, territoryShortName, territoryCode from qryTrimesterPlanningBaseDataset order by mfr_name, mfr_id, territoryName insert into tbl_bcrm_objectiveprdlink ( ownerid, ownertype, objectiveid, mfrid, categoryid ) values ( , , , , ) select * from qryTrimesterPlanningBaseDataset where mfr_id = and territoryid = select coalesce(PrimaryManager,0) primaryManager from tbl_ter_territories where territoryid = and ownerid = and fsl_tablecode = insert into tbl_bcrm_objectiveprdlink ( ownerid, ownertype, objectiveid, mfrid, categoryid ) values ( , , , , ) select distinct dispositionuserid from qryChildData select count(*) as recCount from tbl_bcrm_objectivestflink where objectiveid = and fspro_userid = insert into tbl_bcrm_objectivestflink (ownerid, ownertype, objectiveid, fspro_userid, inserttype, quota) values ( , , , , , 0 ) select distinct dispositionuserid, interactionid, partnerid, partnertype from qryChildData update tbl_bcrm_objectivestflink set quota = ( select count(*) from tbl_bcrm_objectivetrglink where objectiveid = tbl_bcrm_objectivestflink.objectiveid and OrigRepAssignment = tbl_bcrm_objectivestflink.fspro_userid ) where objectiveid = and ownerid = and ownertype = update tbl_bcrm_objectives set totalquota = ( select sum(quota) from tbl_bcrm_objectivestflink where objectiveid = ) where objectiveid = and ownerid = and ownertype = update tbl_bcrm_objectives set totalquota = ( select sum(totalquota) from tbl_bcrm_objectives where parentobjectiveid = ) where objectiveid = and ownerid = and ownertype =

Trimester Objective Planning Batch Results

#numberformat(_totalParentObjectives,"9,999")# Enterprise Objectives Created

#numberformat(_totalChildObjectives,"9,999")# Sub Objectives Created

#numberformat(qryTotals.totalTargets,"9,999")# OperatorDistributor Targets

#numberformat(qryTotals.repCount,"9,999")# Sales Reps

 #_processorOutputHTML#