Mani Bharghav Member since 2017 36 posts
Posted: October 23, 2019
Last activity: October 23, 2019

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
Share this page LinkedIn