Insert into table With select and multiple value SQL server

Question

guys im trying to insert into a table with multiple value.

i want insert into purchasing table where customerID is gained from Customer table and the SourceID is always 1 because it its default. i try query like this

insert into purchasing (customerID,SourceID) select customerID from Customer where    ************,'1'

but it returns erorr, can u guys help me, how to insert into table with multiple select and default insert

note: ******* is any condition

Girish Vadhel · Accepted Answer · 2014-07-11 02:43:06Z

4

You are writing wrong sql query syntax. Your sql query should be something like:

insert into purchasing (customerID,SourceID) select customerID, 1 from Customer where ***

answered Jul 11, 2014 at 2:43

Girish Vadhel

7451 gold badge5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2978983 Over a year ago

if on case after select customerID i need to select SourceID from another table, can i put select customerid,(select ****** where **** ) where ***** ?

Paul Sturm · Accepted Answer · 2014-07-11 02:42:19Z

1

Try select customerID, 1 from Customer

answered Jul 11, 2014 at 2:42

Paul Sturm

2,1682 gold badges18 silver badges23 bronze badges

Comments

jtorrescr · Accepted Answer · 2014-07-11 02:45:02Z

1

It is due to you have couple of errors in your sql. 1. You have the closing ) but never opened it. 2. Include the default value in your query

insert into purchasing (customerID,SourceID) select customerID, 1 from Customer where ???

answered Jul 11, 2014 at 2:45

jtorrescr

5794 silver badges13 bronze badges

Collectives™ on Stack Overflow

Insert into table With select and multiple value SQL server

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related