i create two temp tables in a storeproc.
at the end of the SP, i'd like to copy one of my temp tables to the global tables.
Is it possible to do this easily ? like changing a pointer ?
if yes how ?
do i have to create the table then loop over it to insert all data ?
if this is the case i'd appreciate the sql to do it.
thank you in advance for your help.