Unable to execute the temp tables all at a time
I'm trying to create some local temp tables and then from the local temp tables i want to select & pull the data from using all the local temp tables & drop them once data is fetched ... but when i tried to execute all at once its throwing error that the couldn't find the table or relationshiip errors.
when i tried to create 1st local temp tables then execute select query then also same relationship errors..
can you please help me. how to run the query in one go so that i can calculate the time taken to execute the total