Thanks so much Pradeep, it solved my problem. Thanks again!

Hi Maheer,

Thanks for your clarification, I am able to create the temp table as you demonstrate above. However, I do have problem selecting the data from external table and insert into the temp table. Also the temp table is "disappear" after the queries, is this intended as temp table only persists in the session?

Hi Maheer,

I have tried to pass the same value to the hash functions, but I'm still getting the following error. For your information I'm trying to create the table in the serverless SQL pool. Is there a limitation which prevent me from creating the temp table? As I read from the docs, temp table should be able to be created in serverless SQL pool as well.

The PHP version we deployed was PHP7.4. How do i check what is the limit and how can I change the limit?