2 Replies Latest reply on Dec 15, 2011 5:36 PM by Vineela Gampa

    Problem in creating the temporary tables the implicit way

    Vineela Gampa Novice



      Iam planning ot use temporary table creation for one of our usecase.Iam creating temptables as per mentioned in the document.




      Iam unable to create temp tables using the implicit way thats mentioned here. I have posted the statement and the error iam seeing. 


      Query issued : insert into #temptable123(sysid,name) select sysid,name from demodata.user


      Error : Cannot determine element or expression type



      Elapsed Time:  0 hr, 0 min, 0 sec, 0 ms.



      Is this the only way or there is some better way to create temp tables implicit way ?