Pass array on to sql and insert it in link table with one value

Question

I've found ways to pass an array to a stored procedure and ways to insert a table into another table. But I want to insert my array in a table as column2 with one other value I have as the value for column1:

INSERT INTO Table1 (column1, column2)  
VALUES (SELECT @value, column2 from @otherTable)

I tried inserting the array into column2 first and then updating column1 to be the one value. But that didn't work and would be insanely expensive anyway.

Is there a reasonable way to do this?

Joe Farrell · Accepted Answer · 2015-05-29 17:27:46Z

4

If I'm understanding you correctly, then all you need is to get rid of the VALUES, like so:

INSERT INTO Table1 (column1, column2)
SELECT @value, column2 from @otherTable;

answered May 29, 2015 at 17:27

Joe Farrell

3,5421 gold badge17 silver badges26 bronze badges

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

2 Comments

Sean Lange Over a year ago

Nice Joe. I was just about to post the same thing. You beat me by a few seconds. :D

Zohar Peled Over a year ago

Beat me as well... Note to self: answer first, edit later. :-)

Collectives™ on Stack Overflow

Pass array on to sql and insert it in link table with one value

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related