Forum Discussion

vissvess's avatar
vissvess
Helper V
6 years ago

Next higher value

Hi Community experts,  I have a scenario where the data is as follows Sequence Actualenddatetime LOS 1 3/12/2020 12:44:01 L2A 2 3/12/2020 12:44:42 L2B 5 3/12/2020 12:45:02 L2A...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Then maybe there are some restrictions on what you can write when in the DQ mode. You should check the documentation.

Best
D
TomMartens's avatar
TomMartens
Super User
6 years ago

Hey vissvess ,

the creation of temporary objects like temp tables is not supported, the same is also valid for cte's. For this reason you have to rewrite your query like so:

select
a.*
from
(
SELECT top(100)
*
from
fact.sale
) a

The subquery a represents your temp-table.

 

Hopefully, this provides some ideas to tackle your challenge.

 

Regards,

Tom