Select Into Statement in Hana

[Former Member]

Hi,

I couldn't find any information about how i am supposed to write 'select into statement for temporary table' in Hana ?

I have seen in Hana documents that i you have to create temporary table with the columns before the statement, I do not want to create temporary table  before the select statement, I want to create the temporary table when select statement executed. Is there a way to do this ?

For example :

In SQL SERVER :

Select myField into #x from myTable

Thank you very much.

Yakup Arslan

Message was edited by: Tom Flanagan

[Former Member · Accepted solution]

Maybe you can create the temporary table with something like the next statement:

create temporary column table NAME as (

     select subquery

);

This notation may be similar to the SELECT INTO.

Have you tried?

[Former Member · Accepted solution]

Hey Jose, It worked. Thanks Yakup

[Former Member · Accepted solution]

It's good to read it.

You're welcome.