Dimension reduction, State, Orientation, and Velocity.
Dong Shin 08.06.2010
spent all morning putting together the new Fianancial Data components for Progress Bar updates…
eliminate multiple queries for retrieving Budget Center information
SELECT SUM(case WHEN year=1 then amount else 0 end) as year1, SUM(case WHEN year=2 then amount else 0 end) as year2, SUM(case WHEN year=3 then amount else 0 end) as year3, b.* FROM budget_centers b, budget_amounts ba, appropriations a WHERE b.uid = ba.budget_center_id and project_id =1 AND a.type = b.appropriation group by b.uid
cannot use this because the dynamic nature of FYAmounts!!!