Freeform SQL reports

[Richard Crawford]

Hi all,

 

Does anyone know if it is possible to use temporary tables in Freeform SQL reports in MSTR8?

 ie - create temp table/s -> insert data -> sho results using these tables -> drop tables

 

Kind regards,

 

Richard

[Caio Gouveia]

Ri Richard,

It is not possible to create temp tables in Free Form SQL.
So the code below would not work:

Create table A
Insert into Table A, Select ...
Create table B
Insert into table B, Select ...
Select from Table A join Table B

As a workaround you can you the With clause:

With table A as, Select ...
With table B as, Select ...
Select from table A join table B

This has the same final result.
I hope that helps,

Caio Gouveia
www.dmeaning.com

On Sep 20, 10:48 am, "Richard Crawford"

[Erdem Ozelmas]

One other option that should work is to use report pre-statements VLDB property and put in each of your individual passes in one.

 

Hope it helps.

Erdem

Caio Gouveia <caio.g...@gmail.com> wrote:

Ri Richard,

It is not possible to create temp tables in Free Form SQL.
So the code below would not work:

Create table A
Insert into Table A, Select ...
Create table B
Insert into table B, Select ...
Select from Table A join Table B

As a workaround you can you the With clause:

With table A as, Select ...
With table B as, Select ...
Select from table A join table B

This has the same final result.
I hope that helps,

Caio Gouveia
www.dmeaning.com

On Sep 20, 10:48 am, "Richard Crawford"

wrote:
> Hi all,
>
> Does anyone know if it is possible to use temporary tables in Freeform
> SQL reports in MSTR8?
> ie - create temp table/s -> insert data -> sho results using these tables
> -> drop tables
>
> Kind regards,
>
> Richard

---

Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV.