Query, to Stored Proc

[Jennifer_Ann_28]

Can someone tell me how to turn a simple query like this below into a stored procedure?

select c.camp_abbr,
		p.name as center,
		count(*) as pac_gifts,
		sum(committee_amt) as pac_amount
from pol_hist.dbo.mytime_pac pac
join pol_com.dbo.campaign c
on pac.camp_id = c.camp_id
join admin.dbo.center p
on p.center_id = pac.center_id
where call_date >= '08/29/2007' --date parameter start date
and call_date < '08/30/2007' --date parameter end date
group by c.camp_abbr,
		p.name
order by c.camp_abbr,
		p.name

[pete_bisby]

[SQL]
CREATE PROCEDURE proc_name (IN first_date DATE, IN second_date DATE)

BEGIN

.... this is where your query goes ....

END;
[/SQL]
This is assuming you're using MySQL as your database server.