CREATE PROCEDURE dbo.SPEnrollByCollege2YearsUPTotal

@CurrYear varchar(8),

@PrevYear varchar(8),

@ViewName Varchar(50) AS

Exec ("Select

sum(case

when V.code_ofcl_univ_yr_sem = '" + @CurrYear +"' then (V.numb_ofcl_pers_id)

end) as TotalCurr,

sum(case

when V.code_ofcl_univ_yr_sem ='"+ @PrevYear +"' then (V.numb_ofcl_pers_id)

end) as TotalPrev

into ##TempYears

from "+@ViewName+" V

where ( V.code_ofcl_stud_report_loc = 'UP' )")

select * from [##TempYears]

compute Sum(TotalCurr),sum(TotalPrev)

drop table [##TempYears]