Query on a Temporary Table

(2) Share

Report

Posted on by IĆ-15061320-0

Hi,

Is there a way use a Query object to look into a data of a Temporary Table?
Or are Query objects only for normal tables?

I’m trying to speed up some calculating so I’m looking for all possibilities.

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Suggested answer

Khushbu Rajvi. 6,868 Moderator on at

Like (2)

Report

Query on a Temporary Table

If it helps: https://community.dynamics.com/forums/thread/details/?threadid=35460005-db7d-4fab-9df7-469239a55ef9
One_&_Only_Naveen 56 on at

Like (1)

Report

Query on a Temporary Table

No You cannot query Temporary table as there wont be any data in it.

Instead you can use a temporary table to store data from Query to further manipulate it

Hope this helps.
Suggested answer

YUN ZHU 76,182 Super User 2024 Season 2 on at

Like (1)

Report

Query on a Temporary Table

Hi, hope the following can give you some hints.

https://yzhums.com/4869/

Thanks.

ZHU
Suggested answer

xgaronnat 35 on at

Like (1)

Report

Query on a Temporary Table

Query are only executed against database (bypassing the service/NST cache).