Post reply

Views and Tables

  • October 18, 2006 at 10:02 am

    #117216

    Is there a way to insert the contents of a view into another table without having to loop through each record in the view inserting it into the destination table?

     

    Jim

  • October 18, 2006 at 10:20 am

    #666572

    Do you mean SELECT?

    INSERT YourTable

    SELECT Col1, Col2, ...

    FROM YourView

     

  • October 18, 2006 at 11:12 am

    #666594

    and to expand on what Ken said, if the table doesn't exist yet, you can use the INTO command to create it on the fly:

    SELECT Col1, Col2, ...

    INTO MyNewTable

    FROM YourView

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 18, 2006 at 11:42 am

    #666599

    Thanks guys

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

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