Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

QUERY TO ADD RECORDS TO A TABLE Expand / Collapse
Author
Message
Posted Monday, September 24, 2007 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 24, 2007 9:16 AM
Points: 1, Visits: 2
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
Post #402009
Posted Monday, September 24, 2007 7:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, October 21, 2015 7:25 AM
Points: 749, Visits: 315
Start by looking up "INSERT" in BOL.
Post #402016
Posted Monday, September 24, 2007 8:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 14,306, Visits: 37,371
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!
Post #402040
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse