Extract data from #temp tables SQL Server

[nihhalmca]

Hi All,

I tried to extract data from #temp tables to Qlik Sense. However load will extract zero records where as SQL Server shows records with same query.

Do i need to add any script to query,as of now written like

SQL

Select

--

#temptable;

Actually i am assuming that #temptables stored in virtual memory (not physical) in SQL Server so Qlik is unable to load records/data. Is it correct? please share you knowledge if you were experienced it.

Thanks, Nihhal.

[Anil_Babu_Samineni]

For me this sounds, There is Privileges problem to the schema?

[Anil_Babu_Samineni]

Add each measure separately to the Master Item and call it out to needed color.

[nihhalmca]

Hi, anyone of you assist on this please?

[Ilya_Bobrov]

Perhaps you can create some kind of view or materialized view? What is the need to use tmp tables?

[gmenoutis]

A #table has scope only within the session that creates it.

A ##table, on the other hand, is temporary but can be accessible from all sessions. It gets deleted when the last session that accessed it comes to an end. Maybe use ##?