Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
For me this sounds, There is Privileges problem to the schema?
Add each measure separately to the Master Item and call it out to needed color.
Hi, anyone of you assist on this please?
Perhaps you can create some kind of view or materialized view? What is the need to use tmp tables?
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 ##?