Post reply

Insert data obtained from temp table

  • October 11, 2011 at 1:10 am

    #390585

    Can i use the results obtained through a temp table to insert data into another table?I am getting data from a query into a temp table. Now I want to insert the data from temp table into another table

  • October 11, 2011 at 1:32 am

    This was removed by the editor as SPAM

  • October 11, 2011 at 2:28 am

    #1392709

    I need a solution wherein I can use my temp table outside the session also

  • October 11, 2011 at 2:46 am

    #1392724

    The scope of the temp table is within the session that created it.

    For example if user 1 has created a global temp table ##temp then user 2 can access this table as long as the session from user 1 is active.

    However you should consider the impact and how to handle a session getting terminated in the middle of an operation. Better to go with a staging table if you perform the operation frequently.

    Jayanth Kurup[/url]

  • October 11, 2011 at 3:31 am

    This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply