Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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!
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page