Mani Bharghava Reddy (Mani Bharghav)
Senior Consultant-Technology
Mani Bharghav Member since 2017 37 posts
Posted: October 23, 2019
Last activity: October 23, 2019
Posted: 23 Oct 2019 5:04 EDT
Last activity: 23 Oct 2019 9:19 EDT

Temp tables in sql query component

Hi All,

We have a big query to be executed this query needs to be executed in 2 steps in MS sql server

first step will be getting some data by using other physical tables and placing them in the Temp table, and after this the second step will use the data in the temp table.

so we used two sql command executes first one will do the temp table query execution and the second will do the second query execution from temp table,

but by the time the second query gets executed the temp table is not available to the second query thread, we googled and found that the temp tables will be cleared immediately when the current connection is closed.

we also tried keeping both the queries in one single sql command, but when we use this approach the controller is not coming out of the execute method.

could some one please help us on this.

we tried

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.