4 Replies Latest reply: Jul 23, 2012 11:51 AM by Saurabh Walke RSS

    Copying contents of a temp table

      Hi everyone,

       

      This might have a quick and simple answer but I am trying to copy the contents of one temp table to another one. Anyt idea how this can be done?

       

      Eg:

       

      connect to OLE DB ....

       

       

       

      sql select *

      from "table_name";

      load abc,

                pqr,

                xyz

      resident #temp;

      drop table #temp;

      now, how can I copy contents of this #temp table into another temp table say #test ??

       

      Please let me know!

       

      Thanks!