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 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>