Results 1 to 3 of 3

Thread: SQL Loop procedure

  1. Nov 16th, 2009, 05:10 AM #1
    igimanigi
    igimanigi is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2008
    Posts
    162

    SQL Loop procedure

    I need help to create a procedure that will allow me to open a table,loop through the table and for each record obtain a value in a certain field and then INSERT it into another table. the second table is empty and i am want to populate it with a value coming from all the records of the first table.
    Reply With Quote Reply With Quote
  2. Nov 16th, 2009, 05:51 AM #2
    leinad31
    leinad31 is offline
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: SQL Loop procedure

    Why not use INSERT INTO dest_table columns_list SELECT columns_list FROM src_table
    Roman Numerals, Number In Words,Indian Currency Format, Modified Insertion Sort, Fibonacci
    Reply With Quote Reply With Quote
  3. Nov 16th, 2009, 09:35 AM #3
    igimanigi
    igimanigi is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2008
    Posts
    162

    Re: SQL Loop procedure

    it worked. thanks a lot.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width