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?




      connect to OLE DB ....




      sql select *

      from "table_name";

      load abc,



      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!