turn the coldfusion query into the stored procedure . URGENT

<cfquery name="getReport" datasource="cfelsunrise" dbtype="ODBC">	
		Select e.employeeid, e.last_name as empLastName, e.first_name as empFirstName, e.middle_name as empMiddleName, 
				tr.TrainingID, tr.courseID, tr.StdTimeFrame, .et.completiondate,
				er.last_name as erLastName, er.first_name as erFirstName, er.middle_name as erMiddleName, er.EmployeeID as erEmployeeiD,
				ea.last_name as eaLastName, ea.first_name as eaFirstName, ea.middle_name as eaMiddleName, ea.EmployeeID as eaEmployeeiD,
				ea.middle_name as eaMiddleName, l.name, l.locationID, l.state, s.stateid, a.areaID, r.regionID, e.hireDate
			from employee e 
			join employeejobhistory h 			on h.employeeid = e.employeeid
			inner join jobassignment ja 		on (ja.sequence = h.sequence and ja.emplrcd = 0 and ja.enddate is NULL)
			inner join jobcode_list j 			on j.jobcode = h.jobcode
			inner join location l 				on l.locationid = ja.locationid
			Inner join States s					on l.state = s.StateCode 
			inner join JobTrainLink jtl			on (jtl.JobCode = h.JobCode and jtl.DeptID = h.DeptID and jtl.TrainingID is not NULL)
			inner Join TrainingReqmt tr			ON (tr.TrainingID = jtl.TrainingID and tr.courseID in(#crslist#))
			left outer Join TrainReqState trs	ON (trs.TrainReqID = tr.TrainReqID and trs.StateID = s.StateID)
			left outer join employeeTraining et on (e.employeeid = et.employeeid and et.courseID = tr.CourseID and et.Errflag is NULL) 
			left outer join area a 				on a.areaid = l.areaid
			left outer join employee ea 		on ea.employeeid = a.managerEmpID
			left outer join region r 			on r.regionid = a.regionid
			left outer join employee er 		on er.employeeid = r.managerEmpID
			where e.terminationdate is NULL
				and DATEDIFF(dy, #cutoffdate#, e.HireDate) >= 0
				and l.excludeflag != 'Y'
				<cfif selregionalVP gt 0>and r.ManagerEmpID = #selregionalVP#</cfif>
				<cfif selareaManager gt 0>and a.ManagerEmpID = #selareaManager#</cfif>
				<cfif community gt 0>and l.LocationID = #community#</cfif>
			order by er.last_name, er.first_name, ea.last_name, ea.first_name, l.name, l.locationID, 
					e.last_name, e.first_name, e.middle_name, e.employeeID, tr.courseID, et.completiondate
	</cfquery>