SQL query

[Ethel]

I have a long sql query that has a lot of unions, pivot tables etc. Is there a simple way I can use it in qlik sense without rewriting it on qlik language? I need to be able to change it in qlik sense and that's why I cannot just copy paste data and enter it manually. 

Please help! 

Thanks a lot in advance!

[abhijitnalekar]

Obviously, it will throw an error on your machine as this sample table is from my environment.

 You have to put your SQL query in this format

[Ethel]

I found an error. The problem was with writing data into  #temptable. I replace it with "with temptable" statement and it worked!