Migrate SQL Server Stored Procedures to MySQL

I am in the process of migrating from SQL Server to MySQL database for use with a coldfusion application. In particular, I am stuck in the process of converting the stored procedures. I could really use some help converting the syntax and addressing any other problems that may arise. I am starting with an attempt to convert a single stored procedure and then I figure the rest should fall into place. Here's the example that I'm trying to work with:

****COLDFUSION TAG****



<cfstoredproc procedure="SP_Total_Utilization_Snapshot_Report" datasource="resources">
      <cfprocparam cfsqltype="cf_sql_varchar" dbvarname="@startingWeek" value="#startingWeek#" type="in">
      <cfprocparam cfsqltype="cf_sql_int" dbvarname="@employeeid" value="#employeeid#" type="in">
      <cfprocresult name="getReport">
</cfstoredproc>



****STORED PROCEDURE FROM SQL SERVER****



CREATE PROCEDURE [dbo].[SP_Total_Utilization_Snapshot_Report]
      -- Add the parameters for the stored procedure here
      @startingWeek datetime,
      @employeeid int
AS
BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;

    -- Insert statements for procedure here
      select b.projectname, b.projectid, a.employeeid, c.fname + '' '' + c.lname as EmployeeName, d.role, a.taskDate, b.isBillable, c.showUtilization
into #temp_projects
from td_projectsTasks a join td_projects b on a.projectid=b.projectid
      join td_Employees c on a.employeeid=c.employeeid
      join td_Roles d on a.roleid=d.roleid
where a.taskDate >= @startingWeek and c.showUtilization = 1
order by b.projectname

select
distinct a.projectid, a.employeeid, b.isBillable, b.showUtilization,
''Week1'' = Case When (a.taskDate = @startingWeek) Then hoursProposed Else 0 End,
''Week2'' = Case When (a.taskDate = DateAdd(dd,7,@startingWeek)) Then hoursProposed Else 0 End,
''Week3'' = Case When (a.taskDate = DateAdd(dd,14,@startingWeek)) Then hoursProposed Else 0 End,
''Week4'' = Case When (a.taskDate = DateAdd(dd,21,@startingWeek)) Then hoursProposed Else 0 End,
''Week5'' = Case When (a.taskDate = DateAdd(dd,28,@startingWeek)) Then hoursProposed Else 0 End,
''Week6'' = Case When (a.taskDate = DateAdd(dd,35,@startingWeek)) Then hoursProposed Else 0 End,
''Week7'' = Case When (a.taskDate = DateAdd(dd,42,@startingWeek)) Then hoursProposed Else 0 End,
''Week8'' = Case When (a.taskDate = DateAdd(dd,49,@startingWeek)) Then hoursProposed Else 0 End,
''Week9'' = Case When (a.taskDate = DateAdd(dd,56,@startingWeek)) Then hoursProposed Else 0 End,
''Week10'' = Case When (a.taskDate = DateAdd(dd,63,@startingWeek)) Then hoursProposed Else 0 End,
''Week11'' = Case When (a.taskDate = DateAdd(dd,70,@startingWeek)) Then hoursProposed Else 0 End,
''Week12'' = Case When (a.taskDate = DateAdd(dd,77,@startingWeek)) Then hoursProposed Else 0 End
into #temp_hoursProposed
from td_projectsTasks a join #temp_projects b on a.projectid=b.projectid


select
distinct projectid, employeeId, isBillable, showUtilization,
sum(Week1) as Week1,
sum(Week2) as Week2,
sum(Week3) as Week3,
sum(Week4) as Week4,
sum(Week5) as Week5,
sum(Week6) as Week6,
sum(Week7) as Week7,
sum(Week8) as Week8,
sum(Week9) as Week9,
sum(Week10) as Week10,
sum(Week11) as Week11,
sum(Week12) as Week12
into #temp_hoursProposed2
from #temp_hoursProposed
group by projectid, employeeid, isBillable, showUtilization

select sum(a.week1) as week1, sum(a.week2) as week2, sum(a.week3) as week3, sum(a.week4) as week4, sum(a.week5) as week5, sum(a.week6) as week6,
sum(a.week7) as week7, sum(a.week8) as week8, sum(a.week9) as week9, sum(a.week10) as week10, sum(a.week11) as week11, sum(a.week12) as week12
from #temp_hoursProposed2 a
where employeeid =  @employeeID

drop table #temp_hoursProposed2
drop table #temp_projects
drop table #temp_hoursProposed
END


'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SP_NonBillable_Utilization_Snapshot_Report]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'





I am using MySQL Administrator and understand how to actually setup the stored procedure, but I can't figure out how to modify the syntax. From what I can tell it is creating several temp tables, but I don't even see what/where the output value is.  I have spent a long time looking at this and any help would be appreciated. Thanks in advance!!