Temporal table on SQL-server

[steelunicorn]

Seems that #table i'm creating in query is being destroyed because Robotask closes session to SQL-server. But after creating #table i want to insert data into it in dataset loop. Is there option avaliable to create session and work with it without autoclosing it?

[Oleg]

RoboTask has only two DB-relative actions:
SQL Query and Dataset Loop

Each action opens its own session.
SQL Query closes the session after execution
Dataset Loop keeps the session opened only within the loop.

[steelunicorn]

That's strongly limits range of possibilities in tasks working with SQL. If I may suggest, it wold be usefull to have actions like "Start SQL-session" and "Close session" in loop-like design.
I mean like this:
1. "Start session"
2. Some actions
3. Some other actions
4. Even moar actions
5. "Close session"

[Oleg]

Yes, maybe it's necessary to add these actions. It will be the set of database actions.
I already wrote this into our ToDo list.