Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Easy SQL question.

Discussion in 'Information Technology' started by Glen, Jul 28, 2006.

Tags:
  1. Glen

    Glen
    Expand Collapse
    Guest

    I am SQL stupid and I need some quick help. I need to take all the
    information from one table and insert it into another table for
    archiving. The tables have identical structures but have different
    functions.

    This is what I am trying to do:

    SELECT * INTO tblmaterials FROM tblTempList

    or

    INSERT INTO tblMaterials VALUES tblTempList.*

    or something like that.

    I just need to take all of the materials from the temp list and add to
    an established archive table. Thanks for any help.
     
  2. Loading...

    Similar Threads Forum Date
    Why its easy to be a Sikh and the Master of Puppets Blogs Oct 17, 2015
    easy, develop another addiction! Blogs Oct 16, 2015
    How To Conquer the World: Easy (by the Poet Warrior) Sikh Youth Feb 23, 2013
    USA Not easy to divide Wisconsin Sikh Gurdwara Shooting Donations... Breaking News Sep 6, 2012
    Opinion Human Evolution: No Easy Fix Breaking News Oct 5, 2011

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Try

    INSERT INTO tblmaterials
    SELECT tblTempList.*
    FROM tblTempList

    --
    Good Luck
    BS"D


    "Glen" wrote:

    > I am SQL stupid and I need some quick help. I need to take all the
    > information from one table and insert it into another table for
    > archiving. The tables have identical structures but have different
    > functions.
    >
    > This is what I am trying to do:
    >
    > SELECT * INTO tblmaterials FROM tblTempList
    >
    > or
    >
    > INSERT INTO tblMaterials VALUES tblTempList.*
    >
    > or something like that.
    >
    > I just need to take all of the materials from the temp list and add to
    > an established archive table. Thanks for any help.
    >
    >
     
  4. Glen

    Glen
    Expand Collapse
    Guest

    Thanks a lot Ofer. You rock!
     

Share This Page