Please Help Stored Procedure, Invalid Object #tempactions

Can you please correct my stored procedure, all i am doing is trying to create a temporary table #tempactions.


When i am doing the following on query analyzer: execute createtempactions


I am getting the error : Invalid object #tempactions








CREATE PROCEDURE dbo.Createtempactions


AS


DECLARE @SQL nvarchar(2000)





if exists (select * from #tempactions)


Begin


Set @SQL = 'drop table #tempactions'


Exec SP_ExecuteSql @SQL


End





Set @SQL = 'Create Table #tempactions(Actionno INT NOT NULL,'+


'actioncode VARCHAR(200),'+


'assignedto VARCHAR(200),'+


'company VARCHAR(200),'+


'duedate datetime,'+


'completedate datetime,'+


'actiondescription VARCHAR(200),'+


'status VARCHAR(200),'+


'comment VARCHAR(200))'


Exec SP_ExecuteSql @SQL


GO








Thank you very much.