This content has been marked as final.
Show 4 replies
-
1. Re: Insert in local temporary table in while loop fails
shawkins Apr 4, 2018 9:02 AM (in response to martin.jesterhoudt)Can you clarify what is not working? No rows? An exception?
-
2. Re: Insert in local temporary table in while loop fails
rareddy Apr 4, 2018 10:00 AM (in response to shawkins)Also why #excel_temp at the insert? can you try excel_temp directly?
-
3. Re: Insert in local temporary table in while loop fails
shawkins Apr 4, 2018 10:09 AM (in response to rareddy)1 of 1 people found this helpfulTo expand on what Ramesh is saying - #excel_temp is an implicit temp table, which is not the same as the explicit excel_temp. In both places you should use #excel_temp or excel_temp.
-
4. Re: Insert in local temporary table in while loop fails
martin.jesterhoudt Apr 5, 2018 10:01 AM (in response to shawkins)Steven, this was the solution. Sorry for not reacting sooner but some other work and an unreachable server prevented me.