Results 1 to 3 of 3

Thread: [RESOLVED] INSERT INTO all records in a table

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Posts
    1,384

    Resolved [RESOLVED] INSERT INTO all records in a table

    Hi all,

    I want insert a number and a date into all the records in a particular table. I.E. There could be 100 records in a table and I want to insert the same week# and date into all the records. However, when I try to use the INSERT INTO function of SQL it is simply adding 1 new record to the table and adding the week# and date to this record.

    How do I add the week' and date to all records in the table?

    Thanks,
    Last edited by Hack; Jun 15th, 2006 at 08:19 AM. Reason: Added [RESOLVED] to thread title and green "resolved" checkmark
    Mel

Posting Permissions

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



Click Here to Expand Forum to Full Width