Dong Shin 11.11.2010

  • find duplicate projects functional
    • when services and totals of FY amount match
    • using query below, create dynamic FY values
  • find duplicate projects query
    SELECT p.uid, project_id, center_number, center_name, year, services, SUM(IF(year=1, amount, 0)) as FY1, SUM(IF(year=2, amount, 0)) as FY2, SUM(IF(year=3, amount, 0)) as FY3 FROM `budget_centers` b, budget_amounts a, projects p  WHERE begin_year=2010 AND end_year=2012 AND p.uid = project_id AND b.uid = budget_center_id AND services = ” AND p.uid = @lid GROUP BY p.uid ORDER BY p.uid