EF Function Import does not recognise columns returned by StoredProc

Possible Duplicate:
EF4 - The selected stored procedure returns no columns

I have a stored procedure that creates records in a temporary table, modifies them, and then SELECTS the records.

The issue is that the notice "The selected stored procedure or function returns no columns" appears in the results window when I try to construct a function import and click on "Get Column Information."

Now, if I run it directly from the database, I get the anticipated resultset back, so I KNOW for a fact that it DOES return columns.

You can summarize the saved procedure as follows:

SELECT P.PersonID, P.Surname, P.NickName, P.DateofBirth
INTO #SeriesCompleted   
FROM 
    Table1 T (NOLOCK)
INNER JOIN 
    Table2 P (NOLOCK) ON T.PID = P.PID
;
Select r.PID, SUM(rt.Distance) 'Distance'
INTO #Distance
FROM 
    #SeriesCompleted sc
    inner join table3 rsr (NOLOCK) on rsr.SeriesId = sc.SeriesId
    inner join table4 r (NOLOCK) on r.PID = sc.PID
    inner join table5 rt (NOLOCK) on rt.RouteID = r.RouteID
GROUP BY r.PID;

UPDATE #SeriesCompleted
SET Distance =  d.Distance
FROM #SeriesCompleted sc
INNER JOIN #Distance d on d.PID = sc.PPID;

--Here is where the result is returned.
SELECT distinct sc.PersonID, sc.NickName, sc.Surname, sc.DateofBirth, sc.NumberFinished, sc.Distance
FROM #SeriesCompleted SC