QUERY TO ADD RECORDS TO A TABLE

  • HI,

    I run a case management database which holds records for clients that my company works with. (MS SQL 2000 Server back end MS Access XP front End).

    The database has a client table which holds all the details about the clients we work with there is also a table which holds case notes for each of the clients. I want to add a specific note to a particular list of clients which I have produced as a select query this has then been imported into a new table on which the update will be based.

    In short I want all the clients mentioned in this temporary table to have a case note automatically entered for them into the notes table.

    Any help with this would be great.

    Cheers,

    Neall

  • Start by looking up "INSERT" in BOL.

  • typically, to insert multiple rows, you use a select statement to insert the data.

    a simple example might be:

    INSERT INTO SOMETABLE(ID,NOTES)

    SELECT

    CustomerId,

    'This is a default note that you need to pay for your account by friday'

     From #Temp

    Where paymentmade <> 1

    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!

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

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