topic Re: Extract data from #temp tables SQL Server in App Development

Extract data from #temp tables SQL Server

nihhalmca — Mon, 02 Sep 2019 15:11:26 GMT

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.

Re: Extract data from #temp tables SQL Server

Anil_Babu_Samineni — Mon, 02 Sep 2019 15:17:27 GMT

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

Re: Extract data from #temp tables SQL Server

Anil_Babu_Samineni — Mon, 02 Sep 2019 15:18:29 GMT

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

Re: Extract data from #temp tables SQL Server

nihhalmca — Tue, 03 Sep 2019 06:48:19 GMT

Hi, anyone of you assist on this please?

Re: Extract data from #temp tables SQL Server

Ilya_Bobrov — Tue, 03 Sep 2019 07:55:02 GMT

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

Re: Extract data from #temp tables SQL Server

gmenoutis — Tue, 03 Sep 2019 10:24:45 GMT

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 ##?