Can you use temp tables (sql - #tablename) in custom table insert SQL queries? This is for a custom insert table.

I am trying to replicate some code from SQL, and need to create a custom table insert... my SQL query uses a temp table #ELL.  When I try to deploy & execute, it does not understand the temp table.  Can temp tables be used here?  IE. #ELL.. I just need to have it hold some info that later in the query will populate the new custom table in TimeXtender.


Please sign in to leave a comment.