But why do you want to create the temp table in two steps, is there any specific reason, you can as well create it with the
CREATE table #mytable (column1 datatype ) syntax directly right? Sorry if I am missing anything here. Well if you are passing the table structure as input parameter to the sp and executing it then it is a different case though.
Thanks
Prasad Bhogadi
www.inforaise.com