Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am developing qlikview reports.
I have created MS SQL Stored procedure. Inside that i have used one #Temp table for insertion.
But, i am unable to insert record using #temp table when i call the stored procedure. (Getting error : unknow temp table).
How to solve this problem....?
Can any one reply for this...?
My best hunch here would be something the ODBC/OLE DB client connector not handling things correctly etc., you are likely best off going at this from the DB vendor side first to alleviate that as the issue, and if the vendor provides info pointing back to something we are doing wrong, then we can likely get somewhere, but most of the time these situations are related to issues with the connector not being able to handle things or incorrect SQL syntax etc. Sorry I do not have anything better, but hopefully you may have already headed this route and found something.
Regards,
Brett