UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '< 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '< 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '>= 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = '>= 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Any/All' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Banking' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Banking' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Banking' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Banking' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Banking' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Banking' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Cable/Telecom' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Cable/Telecom' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Cable/Telecom' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Cable/Telecom' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Cable/Telecom' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Cable/Telecom' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = '< 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = '< 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Energy/Utility' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '< 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '< 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '>= 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = '>= 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Financial Services' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = '< 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = '< 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Health Insurance' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = '< 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = '< 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Healthcare' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Insurance' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Insurance' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Insurance' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Insurance' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Insurance' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Insurance' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = '< 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = '< 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = '< 250k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = '< 250k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = '>= 120k' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = '>= 120k' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _becameS8 = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = 'Any/All' AND s._category = 'Won'<BR>UPDATE dashboard_industry_stagesummary s INNER JOIN (SELECT COUNT(DISTINCT(_opportunityID)) '_ct' FROM dashboard_opportunity_stagestate WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _becameClosedLost = 1) o SET s._numOpp = o._ct WHERE s._industry = 'Membership' AND s._dealSize = 'Any/All' AND s._category = 'Lost'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '' WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '' WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '' WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '' WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '' WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '' WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Won' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Any/All' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Banking' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Cable/Telecom' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Energy/Utility' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = '>= 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Financial Services' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Health Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Healthcare' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Insurance' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '< 250k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = '>= 120k' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _qualify = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionDev = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _solutionVal = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _propose = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _negotiate = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>UPDATE dashboard_industry_stagesummary SET _atContract = '',_numOpp = 0 WHERE _industry = 'Membership' AND _dealSize = 'Any/All' AND _category = 'Lost' AND _stat = 'Median'<BR>