>Its not working anyway.
>insert #temp exec revertMoves @billHall, @startdate, @enddate, @periodid
>
>Gives me this error:
>
>Invalid object name '#temp'.
>
>Is there any other way to do this?
>
This should work. Did you create the temporary table #temp first? This syntax will not create a table on the fly.
CREATE TABLE #temp ( ... )
INSERT INTO #temp (columns) EXECUTE revertMoves ...
-Mike